MP9004: Microsoft - Monitoring Performance > SQL Server 2005 MCTS 70-431

Monitoring Performance

This course explains how to monitor the performance of a SQL Server 2005 system.

Topics:
SQL Server Management Studio
Using Activity Monitor
Working with Log File Viewer
Server-Maintained Information
Using Windows System Monitor
Working with SQL Server Profiler
Defining a Profiler Trace

Objectives:
Describe monitoring tools used by SQL Server 2005
Identify the features of Log File Viewer
Describe the types of server-maintained information found in SQL Server 2005
List types of System Monitor counters
Define a SQL Profiler trace

Duration:
2 Hours