Overall Satisfaction with SQL Sentry Performance Advisor
Because we provide internal and external to different clients (6000 clients); the idea was to centralize the monitoring to one dedicated server, receive the alerts and take actions. Even thought there was already one in place; having a SQL dedicated one makes the DBA task way more easy.
People used to complained a lot of the issues of the solutions we provide was due to the SQL; after SQL Sentry I can show the stats and numbers speaks by themself - they were mostly code issues.
People used to complained a lot of the issues of the solutions we provide was due to the SQL; after SQL Sentry I can show the stats and numbers speaks by themself - they were mostly code issues.
- Saving the SQL stats and showing them in an easy and graphical manner
- I can easily do a report on SQL stats
- I can actually see what user or application caused deadlocks or is blocking the DB
- From version to version SQL Sentry changes the way it collects data; that can cause some misreadings or incorrect stats.
- When you first see the stats from Performance Advisor you need to expend a lot of time until you have an idea of what they mean.
- The documentation is not easy to understand.
- TOAD, IDERA and QBS
It is easy to install; not intrusive and most importantly does not try to replace the SQL Management Studio, it works with it.