Summary
This article details how to address a report that is slow or does not finish rendering.
Article sections
Symptoms
For Solver Private Host and BI360 4x customers, when reports are running slow, the following can be checked to see if they are causing bottlenecks leading to speed issues.
Causes/Resolutions
There are many reasons why this can happen. When your reports never get to the rendering phrase where the button never "greys out", you are pinging your SQL with queries that are not completed in a timely manner. The following should be checked:
- You cannot ping the SQL server:
- This can be resolved by checking if the server you are on can ping the SQL Server using the command line.
- If you are on Version 4, you can also check BI360 Administrator to see if the Data Connection exists.
- Your Solver/BI360 Database is too large:
- As you add more data to your database, you will need to perform database tuning to ensure that queries against it are running optimally. Please consult your database administration (DBA) to make sure that a "maintenance" process is in place.
- A large database can also have large log files. Large log files can slow down queries being run by the Solver application. Please consult with your DBA to make sure a proper process is in place for large log files.
- This article helps troubleshoot this, but a Solver technician can assist with this if your DBA cannot:
- The SQL server needs more ram and processors:
- Over time, if Databases are not cleaned out of data, SQL queries can become slower especially if the number of BI360/Solver users is expanding or reports are getting larger. By increasing these aspects or dedicating the SQL Server to only Solver queries, you will reduce runtimes.
- The OSR_Repository/Solver_Repository/BI360_Repository Compatibility mode has been changed on the SQL server to match the year of the SQL Server Management System (SSMS):
- This can cause the query from the BI360/Solver application to get stuck or run until the server runs out of CPU. Revert back the compatibility mode if this occurs.
Check out this article for report configurations/design that can lead to performance issues.
Properties
Applies to
- Private Host
- BI360