Microsoft® SQL Server 2012 Unleashed
by Ray Rankins, Paul T. Bertucci, Chris Gallelli, Alex T. Silverstein
Activity Monitor
The Activity Monitor saw some dramatic changes in SQL Server 2008 that were carried forward to SQL Server 2012. These changes build on the foundation established in SQL Server 2005 and help provide much more information related to the performance of your SQL Server instance.
Before we get into the details of the Activity Monitor, let’s make sure you know where to find it. It is no longer found in the Management node of the Object Explorer. Instead, you right-click the name of the server instance in the Object Explorer, and you see a selection for Activity Monitor.
When the Activity Monitor launches, you see a new display with four different graphs, as shown in Figure 4.9. The graphs include % Processor Time (from SQL Server), ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access