Server Speed Slow

[kevbrown]

Our QlikView server installation performance is poor and would like to know of any quick wins to speed it up

What is the best way to approach the analysis? Is there a set process of deduction that i could use to diagnose any problems? Is there anything specific to look for in the log files?

The QlikView documents are held on a distribution server (QlikView03) which is separate from the from the main QlikView server (QlikView).  I have spent most of the day taking calls from people who are concerned that there dashboards have not been refreshed.

We have 33 dashboards that are refreshed daily (ie 24 hours behind) at specific times and 11 that are refreshed though out the day at intervals ranging from 5 to 360 minutes. This issue does not seem to be consistent on some days it works without needing a restart. Today was exceptional I restarted the service on QlikView03 several times and not all dashboards have been refreshed today.

Any help would be greatly appreciated

Kev

[Anonymous]

Kevin, 

Do look at Marcus idea re too many parallel tasks.

Also the Task Log points to the qvw reload log, could you get hold of that and share it.

[kevbrown]

ok I'll take a look, thanks. Not able to get hold of another log other than one that was downloaded earlier

07/10/2015 15:05:56 Error   Document open threw an exception. Exception=The currently executing operation was aborted.

07/10/2015 15:05:57 Error   The task "Reload and Distribute of Information Services\AE_KPIs" failed. Exception:

1. QDSMain.Exceptions.DistributionFailedException: Distribute failed with errors to follow. ---> System.Threading.ThreadAbortException: Thread was being aborted.

   at QVBWrapper.DocumentPool.Checkout(ILogBucket logBucket, eCheckoutMode checkoutMode, String fileName, Boolean clearAll, Boolean clearLocks, Boolean clearOneAndOnlyOnes, Boolean reduce, String variableName, String variableValue, AbortCallbackCheck abortCallbackCheck, String sectionAccessUsername, String sectionAccessPassword, DocumentRestoreMode documentRestoreMode, Boolean withData, Boolean forceQvbAllocation)

   at QDSMain.DistributeTask.OpenDocument(TaskResult taskResult, String fileName)

   at QDSMain.DistributeTask.Distribution(String fileName, DistributionRequest distributionRequest, TaskResult taskResult, String repeatVariableName, String currentRepeatVariableValue)

   at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)

   --- End of inner exception stack trace ---

   at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)

   at QDSMain.Task.AbstractTask.TaskExecution(ILogBucket logBucket, TaskResult taskResult)

07/10/2015 15:05:57 Error   Task failed with exception

07/10/2015 15:05:57 Error   Exception=The currently executing operation was aborted.

[marcus_sommer]

In general - you will need to be able to access all qlikview loggings else it will be very hard to found and fix the reason for any problems.

- Marcus

[Bill_Britt]

Hi Kevin,

How many reload engines do you have set? If you have more than 9 you will need to increase the Desktop Heap setting.

Bill