Performance Issue

[spsrk_84]

Hi All,

I am facing a issue w.r.t data loads through publisher.Till last week the Data loads use to happen very fastly i.e 1 million rows of data hardly takes  2-3 mins.All of a sudden i dont know what has happened the loads time  increased to 23 mins for the same 1 Million rows of data. I have checked with the nwtworking guys is there any problem from their end.Manually if i copy the files from QV server to my local the speed is too good (up to 2 MBPS).

The reason i am posting this issue is to know is there any configurations do we need to check in this kind of scenario's or if you have suggestion to be followed to reslove this issue.

Please give ur inputs/suggestions.

Regards,

Shiva

[Miguel_Angel_Baeyens]

Hi Shiva,

If you have not upgraded the OS or done any other change in the computer and software, the first try I'd do is log on to the Server as the QlikView services account, then open Desktop and do a manual reload of the script just in case all paths and drives are properly set, and permissions as well.

Is there any chance that the process is running along with any other intensive usage process such as backups, antivirus scans, or so?

By the way, once the document reloads, does it work fine (objects rendering, calculations, change of sheets) or it performs poorer than before?

Hope that helps.

Miguel

[spsrk_84]

Hi Miguel,

I am facing the issue during the initial loads process from DB to Qvd.Later on everything is working fine.

Regards,

Shiva

[Miguel_Angel_Baeyens]

Hi,

Does the process work fine when the reload is done by the Desktop instead of the Server? Any differences?

Miguel

[spsrk_84]

Hi,

Both the ways(Through QV Publisher & Desktop ) i am facing the same performance issue.

[Miguel_Angel_Baeyens]

Hi,

Is is possible that some changes had happened to the database or the driver? What if you run one of the SQL statements in your script through a query analyzer or any similar tool that allows you to perform SQL queries to your data? Do they run as slow as they do with QlikView?

Miguel

[spsrk_84]

Hi,

No Changes were done neither to database or the drivers.I ran simple select query from Qlikview server it  took the same time similar to  job through the publisher.

Regards,

Shiva

[Miguel_Angel_Baeyens]

Shiva,

What if you do that same SQL SELECT within the data source query analyzer? Does it take the same time or does it run faster?

I still don't see how is this related to QlikView Server... (not saying it's not because QlikView, but that it's difficult to see where is the issue).

Miguel

[StefanBackstrand]

Except for the excellent advise from Miguel, I would reference to the script log files (which is called DocumentLog.txt and will be stored next to the task log on the Publisher machine (or wherever the Distribution Service application data folder is located)), to see where in the script the difference is - basically, what part is taking more time now than it did before? Is it the connection to the database (driver, network)? The fetch of data (network, database performance)? Script execution or data transformation on the QDS node (performance, data amount drastically changed) and so on. Find the difference.

You can read the script log file with QlikView to visually find differences in large script files.

/edit: Saw now that this was over a year old, I wonder why it showed up in my feed just now.. ?

[#10]

Currently suffering this exact same issue QV11 publisher server running fine up until yesterday now a job that used to run in 20 mins takes hours via the QMC but run the QVW manually on the server it runs in 20 mins as expected. Pulling from SQL 2016 but been that way for months nothing changed on either servers. Was a root / fix ever found to this?