Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

amien
Valued Contributor

why is loading a QVD file (optimized) slower on prod then on dev

I have a QVD file with contains about 10mil records. On development it loads in QMC within 25 seconds
(optimized). On Prod it will take more then 1 minute

Prod has more resource then Dev. Prod has 128GB of memory and 28 CPUs

Prod is a distrubution server only (accesspoint is on another server).

the QVD file is on the same location. So there should not be any network traffic between servers.

Virus scanner is off.

For could be the reason why development is faster then prod?

Thanks in advanced

8 Replies

Re: why is loading a QVD file (optimized) slower on prod then on dev

Yes, it seems strange. Maybe there are different configurations on the firewall / group policies. I think it would be helpful if you provide more details like the used OS + QV releases, the used hardware (Intel or AMD, ...), virtual or physically and so on.

- Marcus

amien
Valued Contributor

Re: why is loading a QVD file (optimized) slower on prod then on dev

Hi Marcus,

SR12 all servers

Windows Server 2008 R2 all servers

Dev is virtual, Prod is physical.

All Intel

I will check Prod, but on Dev Firewall is 3x off

Re: why is loading a QVD file (optimized) slower on prod then on dev

At least there is one difference (virtual/physical) between the servers but the impact from them should be rather reversed - so I think this will be rather not the reason.

The mentioned qvd is not very big so that a load of them should not touch the any hardware-resouces even if there are other processes / tasks running. But to exclude anything like that and that the whole windows environment had any problem - could you repeat this after a restart from the qlikview services respectively the OS.

- Marcus

MVP
MVP

Re: why is loading a QVD file (optimized) slower on prod then on dev

Have you measured the drive throughput and ressource occupation on both systems?

Re: why is loading a QVD file (optimized) slower on prod then on dev

Maybe RAM exhaustion? You say that the AccessPoint is on another server, but the AP is just a web site which poses almost no load on a server machine (RAM or CPU). Where is your QVS located? On a separate machine as well?

Maybe I/O channel differences? The production machine may have a slower I/O channel (disks and such) than the virtual server. The hardware on which virtual machines are configured is usually highly parallelized with lots of high-speed memory and extremely fast disks (because of having the reponsibility to run multiple virtual machines with acceptable performance at the same time). It's difficult to compare virtual machines with real physical machines.

Peter

amien
Valued Contributor

Re: why is loading a QVD file (optimized) slower on prod then on dev

i'v checked the drive throughput, using performance monitor (i guess this is what you mean). The disk performance (k/sec) is much lower on prod. all the files are on E: i assume this is also not a network location. How can i check this? it's not mapped or something like this.

amien
Valued Contributor

Re: why is loading a QVD file (optimized) slower on prod then on dev

QVS is on a difference server. only QDS runs on this server.

MVP
MVP

Re: why is loading a QVD file (optimized) slower on prod then on dev

Open the Microsoft Management Console (start > run > mmc) and load in the Disk Management snap-in. This will show you show you which drive letters are assigned to which disks and you can check the disk properties (right click > properties) to see the vendor / details.

Community Browser