Back to Home

Timeout Issues

Overview

From our current understanding, currently a query within our GetReviewRecord stored procedure causes timeouts of the application when the indexes on some of our tables get fragmented. This fragmentation seems to be caused by one of our overnight jobs, either the delete job or the sampling job.

Steps

1. Check in the Database Performance Analyzer tool for the 0099 database to see if the query we are worried about is causing issues. See Screenshot 1.
2. Contact Bud Oberheim to request the update stats command be run by a DBA
3. Monitor the tool once the command has been executed to verify the problem is resolved

Screen Shot 1