What’s New in Monitoring SQL Server Performance
Performance tuning and troubleshooting are time-consuming tasks for the administrator. To help provide insights quickly into performance issues, SQL Server 2008 provides a number of new and enhanced features for monitoring SQL Server performance.
In SQL Server 2005, the Activity Monitor in SSMS showed only the current running processes and the locks currently being held in the system. In SQL Server 2008, the Activity Monitor has been enhanced and now provides a graphical overview of SQL Server activity, as well as information on active user tasks, resource waits, data file I/O, and the recent most expensive queries. Unfortunately, the new information and fancier interface come with the loss of ...
Get Microsoft® SQL Server 2008 R2 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
