Troubleshooting Database Connection Response Times

Overview 

This document will demonstrate how to troubleshoot DB connection response times. Reports sourced by queries from an external database can have slow data retrieval response times. Decisions has some diagnostic tools for users to troubleshoot SQL query calls and Report load times. 

Example

One of the main tools to accomplish this is the Profiler. This is located in System > Administration > System Tools > Profiler. 

1. Navigate to any Dashboard and then return to the Profiler.
2. When this Report has been refreshed, the Profiler will capture the query response time. 
3. Right-click the relevant row and select Show Children to open a window with a breakdown of detailed information. 
4. Users can also download the Profiler text file. The file will have details on the load time of the Report. 
5. This information can help determine if stored procedures or caching are needed to speed up Report load times.