Category: Performance Analysis (4)

SQL Sentry Performance Advisor (PA) for Windows is one of our newer product offerings, and I think one that could use a little bit of use-case clarification.
In my last post I covered the exciting new intelligent alerting features in SQL Sentry v8. Next up in the series is another huge and often requested feature: Baselining.
It's tempting to insert some clever reference to everyone's favorite vegetable juice medley here, but I will refrain, for fear of diminishing what is perhaps the most significant SQL Sentry release to date!
Our ultimate objective with this release of SQL Sentry Performance Advisor was to increase visibility and manageability around AlwaysOn in dramatic fashion, thereby enabling it to reach its full potential. This new functionality is so powerful, some of our clients are even using it for resource management across commodity servers, something I'm not sure the AlwaysOn creators ever envisioned. I'll delve into that in a future post, but for now, I wanted to give some insight into these features.
Since its introduction in SQL Server 2005 SP1, mirroring has become a common method to provide high availability for critical databases. With any HA strategy, proper monitoring is a must to ensure...

Top Categories

See all

Get the best SQL query analysis and optimization tool – free!

Plan-Explorer-logo-RGB-800px
  • Index Analysis Sandbox
  • Statistics Analysis with Histogram
  • Management Studio Add-in
  • Plan Diagram
  • Deadlocks
  • History and Comments
Free Download Learn More