Performance Studio
Earlier in this chapter, you looked at the Reliability and Performance Monitor as it exists in Windows Server 2008. The Reliability and Performance Monitor is there whether SQL Server 2008 is installed on the system or not. However, SQL Server 2008 introduces its own performance toolset that Microsoft calls the Performance Studio in their various exam objectives. The Performance Studio is really just a hook into this underlying performance-gathering technology in Windows Server and the implementation of a storage mechanism known as the Management Data Warehouse (MDW). The good news is that you can set it all up in just a few minutes.
SSIS is required for Performance Studio to work. The SQL Server Agent service must be running ...
Get SQL Server® 2008 Administration: Real World Skills for MCITP Certification and Beyond 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.