Overall Satisfaction with SQL Sentry
We use SQL Sentry to monitor our production database servers. We use it mainly for performance tuning for our environments. We also use it to analyse expensive queries, blockages, deadlock and so on. Then from the analysis, we apply optimizations accordingly.
- It captures all relevant information about captured queries, from physical metrics to row counts. It packs all the information we need to analyse our database performance.
- It provides a great graphic user's interface to have quick understanding of what is going in the environment, and gives facility to check historical values for the metric in question.
- It could be improved on the way how the SQL Sentry database is managed, for example archiving old data, and also could have SQL agent jobs to do regular maintenance jobs to make it perform better.
- Also it might be an good idea to have a web interface.
- It would be good to be able to configure what kinds of queries to capture in each server instance.
SolarWinds SQL Sentry Feature Ratings
Using SQL Sentry
3 - IT
1 - Advanced understanding of SQL Server, from logic to physical aspects.
- Performance tuning.
- Disk space monitoring.
- Blockage analyse and resolution.
- Improve employee efficiency.
- Improve user experience.
Using SQL Sentry
Pros | Cons |
---|---|
Like to use Relatively simple Easy to use Well integrated Consistent Quick to learn Convenient Feel confident using | Requires technical support |
- Analyse curent blockage in SQL Server
- Index monitoring and maintainence
- Analyse long running queries