Course 10157: Monitoring and Controlling Resources in Microsoft SQL Server 2008

Introduction This two-hour course provides you with the skills and knowledge required to monitor and control resources in SQL Server 2008. You will learn about various tools, such as Activity monitor, System monitor and Profiler, which can be used to monitor SQL Server 2008. You will also learn how to control resources by using Policy-Based Management and Resource Governor.

Topics covered in this course include:

• Introduction to Monitoring
• Using Windows Reliability and Performance Monitor
• Using SQL Server Profiler
• Using SQL Server Data Collector
• Using Resource Governor
• Using Policy-Based Management

Student prerequisites:

To benefit from this course, the learner must be familiar with using Microsoft Windows. They must have knowledge of basic relational database concepts and querying data by using Transact-SQL. They must be familiar with the role of a database administrator.
Objectives At the end of the course, students will be able to:

• Describe monitoring.
• Use Windows Reliability and Performance Monitor.
• Use SQL Server Profiler.
• Use SQL Server Data Collector.
• Control resources by using the Resource Governor.
• Control SQL Server by using Policy-Based Management.

Modules & Lessons Course Overview Module Overview Navigation Overview Navigation Overview Course Information Course Information Monitoring and Controlling Resources in Microsoft SQL Server 2008 Module Overview Introduction to Monitoring Introduction Importance of Monitoring Types of Performance Monitoring Tools Importance of Baselining How to Use Activity Monitor How to Use Transact-SQL to Monitor SQL Server 2008 Self Test Using Windows Reliability and Performance Monitor Introduction Characteristics of Windows Reliability and Performance Monitor Common Objects to Monitor How to Use Windows Reliability and Performance Monitor How to Create a Data Collector Set Self Test Using SQL Server Profiler Introduction What Is SQL Server Profiler? Event Categories in SQL Server Profiler How to Use SQL Server Profiler Creating a SQL Server Profiler Template How to Integrate SQL Server Profiler with Windows Data Collector Self Test Using SQL Server Data Collector Introduction What Is SQL Server 2008 Data Collector? How to Create a Management Data Warehouse How to Use System Data Collectors How to Create Custom Data Collectors Self Test Using Resource Governor Introduction Control Resources Using Resource Governor Components of Resource Governor How to Create a Resource Governor Instance Control Applications with Resource Governor Self Test Using Policy-Based Management Introduction Purpose of Policy-Based Management Components of Policy-Based Management How to Create a Policy Self Test Best Practices Best Practices Lab: Monitoring and Controlling Resources in Microsoft SQL Server 2008 Lab Overview Scenario Exercise Information Launch the Lab Lab Review Module Summary Module Summary Glossary Glossary System Requirements To view this course, you need:

• A Pentium II, 256 MB RAM with a processor speed greater than or equal to 400 MHZ
• Microsoft® Windows® 2000 or higher
• Microsoft Internet Explorer 6.0 or higher
• Adobe Flash 7.0 or higher (1MB disk space needed to install)
• Microsoft Silverlight 4.0 or higher
• Microsoft Windows Media Player 7.0 or higher
• Microsoft XML Core Services 3.0 or higher
• A Super VGA monitor with minimum screen resolution 1024x768, with 16-bit color.
• A sound card, and either speakers or headphones (for multi-media audio).
• Internet bandwidth of 56K or faster. Broadband internet access is recommended.

For courses containing Virtual Server-based labs (courses in the IT Professional and Developer Catalog), you will need:

• Microsoft Virtual Server ActiveX control (1MB disk space needed to install)

Test your computer's capabilities to see if it supports this course. Accessibility Requirements The following software must be running on your computer in order to access this course with Screen Reader Software:

• Microsoft Internet Explorer 6.0 or higher
• Window-Eyes from GW Micro
• JAWS from Freedom Scientific
• MSAA enabled