PASS is fast approaching, and as a countdown to the big event where SQL Server performance management will make a big splash with 2 HUGE releases, I’ll be going over what’s hot in Spotlight on SQL Server Enterprise and Foglight for SQL Server.

CPU Diagnostics.  Let’s face it, as a DBA it’s not easy when CPU issues arise.  There are all sorts of things that could be to blame, and a plethora of ways to troubleshoot the problem.  Spotlight has built a strong reputation for the way it helps DBAs diagnose performance problems with an intuitive interface and built-in workflows, but in version 6.0 we’ve taken the next step.  Actually, it’s more of a leap.  Spotlight on SQL Server Enterprise now automatically diagnoses CPU conditions, and presents a dynamic output defined by what’s been identified as the root cause.  By bringing together SQL Server and Windows metrics, controls, and views in a single dashboard – you’re one click away from “problem solved”.

Spotlight on SQL Server Enterprise CPU Diagnostic Drill-down

This entry was posted on Wednesday, October 28th, 2009 at 7:00 PM and is filed under SQL Server, Spotlight on SQL Server. You can follow any responses to this entry through the RSS 2.0 feed. Both comments and pings are currently closed.