slow sql server load times - what is the best way to determining cause
Hello,
After upgrading to Qlik Sense Nov 2020 with Patch 2 I have noticed slow load times from SQL Server.
What are some of the ways to determine the cause of slow sql sever load times? As an example this could be from a network change that I am not aware of.
If there is a reason to suspect the upgrade please let me know.
I would not suspect a QS upgrade to degrade TSQL performance. I would start with your DBA's and see if maintenance has been performed on indexes as well as statistics for the database(s)/table(s) in question. If not maintained and up to date, these can cause TSQL query plans to be sub-optimal. Also, has there been an inordinate amount of data growth recently?
I would not suspect a QS upgrade to degrade TSQL performance. I would start with your DBA's and see if maintenance has been performed on indexes as well as statistics for the database(s)/table(s) in question. If not maintained and up to date, these can cause TSQL query plans to be sub-optimal. Also, has there been an inordinate amount of data growth recently?
