Monitoring and Controlling Resources in Microsoft SQL Server 2008 (E-Learning)

Printer-friendly version
Vendor: 
Microsoft
Subject: 
Database
Overview: 

Length:2.00 hours - Excluding labs and assessments
Published:Aug 25, 2009
Language:English
Audiences:IT Professional
Level:Advanced
Technology:Microsoft SQL Server 2008
Type:Course
Delivery method:Self-pace Course

Course Contents: 

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

Objective: 

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

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.

For more information on Monitoring and Controlling Resources in Microsoft SQL Server 2008 (E-Learning) please feel free to contact us online or call us at 416-513-1535.