O'Reilly logo

SQL Server® 2008 Administration: Real World Skills for MCITP Certification and Beyond by Tom Carpenter

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required