May 2010
Intermediate to advanced
815 pages
21h 55m
English
book
SQL Server® 2008 Administration: Real World Skills for MCITP Certification and Beyond
by Tom Carpenter
Content preview from SQL Server® 2008 Administration: Real World Skills for MCITP Certification and Beyond
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,
Start your free trial
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 ...