Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
we have a production and a test server with equal ressources and equal qlikview installation.
Now, on testserver a qvd with 2'000'000 rows is read in 5 seconds (raw optimised), in steps of 300'000 rows.
On prodserver, the same file needs 10seconds for loading (raw optimised), every 150'000 record load is displayed instead.
What could cause this difference?
Thank you - Marcel
A thread with a very similar scenario is this one:
No answer is marked as solution.
I have moved the qvd file to different hard discs on either the prod and the testserver. The problem remains the same, dev read has double speed than reading the qvd on the prod server.
I will now turn off Virus scanner on prod and check. Reinstalled QV.exe on prod as well.
Only other thing I find is that MS MDAC versions are different on both servers, but this should not have an impact.
Hi Marcel,
To fully isolate the case, if you got exactly the same resource, same storage, same clock speed, etc, I would check if there are other factors that get in the way.
On prod server, is there a server active? before doing the tests, do you check that you have no other disk activity?
The dev and prod are on the same space? what happends if you move the qvd to a local folder on these servers?
Thinkable are different user-settings in Qlik like generating a log-file and/or writing it instantly. Maybe there are more settings which may have an impact especially if there were adjustments to the easter egg settings. To exclude any influence from them you could remove the settings.ini (after a backup) to see if it makes any differences.
- Marcus
Is the amount of *available* resources identical in both cases? If the production server is busier, this may be an issue where the reason for slower read is having fewer resources available to actually work with vs. a less-busy test server.
Hi
I have already deleted the settings.ini ("easter eggs"), but no difference.
The log file settings are the same (local logging in c:\programdata\QlikView\...),
written immediately.
The amount of available ressources (c: / d: disk) is even slightly better on prod.
Yes, there is a QV Server running on both systems. However, if no job (qvb.exe) is running,
still no difference.
Even If a stop the QV Services on prod and disable them, no difference. QV.exe on Test reads qvd files optimized
always double as fast as on prod.
I have stopped running processes on the prod server as possible, still no difference.
The load processes were equally fast on both systems until specific date Feb, 15. Thereafter, out
of a sudden, load speed of both qv.exe and qvb.exe started to be doubled on prod.
I suggest you should try to run some testing tool, one that integrate cpu and disk.
You should check if it's a general problem, rather then Qlik related problem, before investigating further in Qlik direction.
Before looking for any technically reasons on the OS + hardware side I suggest to exclude if any possible all thinkable causes on the Qlik side. This means for example:
If nothing significantly changes or gives any interesting hints to follow you may trying some more direct load-checks, for example:
By all trials a close look on the taskmanager or more specialized tools like the resource manager may be also useful to notice any specifics.
- Marcus
Thank you, these are good ideas how to test further. I will try out all of them.
Marcel