4 Replies Latest reply: Sep 20, 2016 10:54 AM by Jay Seigel RSS

    Where can I find best pratices? Backing up, server setup?

    Jay Seigel

      Hi

       

      I have been looking for the answer to some of these questions, I am administrating a Windows Server 2008 HPC Edition, xeon E5649 @2.53GHz 3 procs. 80gb memory and 64bit os.  The C drive has the OS and QlikView ver 11.00.11414.0 sr2 x64. It is 2tb and currently has 118gb free. The D drive has archived files.

       

      Our normal builds are a smaller c OS driver 80-120gb, then the application or data would be on a separate drive, Then a archive drive. We are having issues backing up the C drive.

       

      Below are my questions, any help would be great. thanks in advance.


      1. Best Practice for setting up the server drives?
      2. Best Practice for Backups?
      3. Would a highly defragged drive cause backup issues? Windows defrag only shows 7% but defraggler shows 70%.

       

       

        • Re: Where can I find best pratices? Backing up, server setup?
          Peter Turner

          Hi Jay,

           

          1. Best Practice for setting up the server drives?

          This depends on your/IT preference but usually a smaller C drive for the OS and programs, with a larger D Data drive to store your QlikView content such as dashboards, QVDs and anything else that is required to use the apps.

          Then maybe another drive letter if there are achieve or files that don't need backing up, or store them to the network.


          2. Best Practice for Backups?

          If its a VM then snapshot as required, with some retention on the 'D Data' drive so you could compare a dashboard from afew days ago with the current one.

          I'd say you could use any backup program.


          3. Would a highly defragged drive cause backup issues? Windows defrag only shows 7% but defraggler shows 70%.

          Drive fragmentation would only slow down the OS and QlikView reading/writing files.



          • Re: Where can I find best pratices? Backing up, server setup?
            Colin Albert

            You are running a very old version of QlikView  11.0 sr2 was released Nov 2012!

             

            V11.0 has been superceeded by v11.2 which is currently on SR15 or look at QlikView v12 which is on SR5.

            To support users running IE11 you need a minimum of v11.2 SR5

             

            I would suggest upgrading, as there have been hundreds of fixes released since your version.

            • Re: Where can I find best pratices? Backing up, server setup?
              Colin Albert

              Do the backup logs indicate whether any specific files or folders are causing the backup failure?

              How are you backing up the files - to another HDD, to tape, across a network? QVW and QVD files can be very large and this may be an issue for you backup system / software.

              Could it be a contention issue - is you backup trying to access files at the same time as QlikView?

               

               

              I would look for any old versions or duplicates of your QlikView apps (QVW files) as if these contain data they may be large.

               

              You can remove the data from the old apps if you wish to retain them for reference of the scripts which will reduce their file size. QlikView only accesses disk when opening an app and reloading data. One the app has been opened, all data is in RAM so fragmentation will not affect QlikView.

              • Re: Where can I find best pratices? Backing up, server setup?
                Jay Seigel

                Thank you Peter and Colin for your input, we were able to get a snapshot of the server. We will look into upgrading it.