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
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.
SR12 all servers
Windows Server 2008 R2 all servers
Dev is virtual, Prod is physical.
I will check Prod, but on Dev Firewall is 3x off
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.
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.
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.
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.