Troubleshooting Database Connection Response Times

Overview 

This document will demonstrate the tools and ways to troubleshoot DB connection response times. Reports that are 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. For this example, an external database connection has been configured for Southwind DB. Data is retrieved from the database by a query and a Report displays the fetched information. 

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. The information can be viewed by expanding the ReportViewService > BuildReportViewInfo.
   For detailed information, click Download > Text View.

   

4. Right-click the relevant row and select Show Children to open a window with a breakdown of detailed information. 

   

5. Users can also download the Profiler text file. The file will have details on the load time of the report. 
6. This information can be utilized to help determine if stored procedures or caching are needed to speed up Report load times.