DPA helps us with ongoing identification of slow running SQL code
April 19, 2019
DPA helps us with ongoing identification of slow running SQL code
Score 9 out of 10
Vetted Review
Verified User
Overall Satisfaction with SolarWinds Database Performance Analyzer
We use it to monitor our complex solution that provides location and video feed for a fleet of connected vehicles. The solution is an extremely complex set of MSSQL Databases with constant data flow of around 5000 messages per minute. Each message required several different post-processing tasks that are developed as SPs Triggers and Jobs in the SQL server. We make a lot of changes to the solution constantly. Sometimes these can result in a massive slowdown speed in parsing of the incoming messages. We use the DPA to analyze the situation when this happens and to catch the piece of SQL code that is causing this to resolve real-time issues.
- Quickly points out what is slowing down our SQL server
- Provides daily statistics on most ran queries and their wait time
- Operates flawlessly with no maintenance
- Sometimes it cannot tell the SQL query text - I believe its when Entity Framework SQL is being ran
- Email notification when a SQL statement starts "killing" the whole server
- Full text search of specific SQL termS in all of the SQL code that it has captured
- Positive is we are now able to resolve Live DB issues within minutes where previously it could have taken us hours or days
It was the only software that was able to reliably itself identify for us the SPs that have taken a long run time. The other tools were unable to identify this for us. So we have discontinued using them.