Monitoring SQL Server 2000 Performance

Overview/Description
To explain how to monitor SQL Server for optimal performance

Target Audience
Database administrators, application developers, system administrators, and students preparing for Microsoft certification in installing, configuring, and administering Microsoft SQL Server 2000 Enterprise Edition

Prerequisites
Experience working in a medium to enterprise computing environment that uses SQL Server 2000 Enterprise Edition; at least one year’s experience administering SQL Server; at least one year’s experience implementing relational databases in environments that contain heterogeneous databases, SQL Server security integrated with Windows Authentication, client/server configurations of 50 to 50,000 or more users, web configurations that use Internet Information Services (IIS) or COM+, databases as large as 2 TB, and multiple installations of SQL Server 2000

Expected Duration
90 Minutes

Objectives:

Monitoring SQL Server 2000 Performance

  • explain the reasons for monitoring a SQL Server system, the factors that affect performance, and how to detect a bottleneck.
  • design a monitoring and tuning methodology for diagnosing and resolving performance issues.
  • describe system-level monitoring tasks and the appropriate tools for each task.
  • describe SQL Server specific or query specific monitoring tasks and the appropriate tools for monitoring these tasks.
  • monitor SQL Server using the SQL Profiler.
  • monitor SQL Server using T-SQL.


    • Course Number: 31566_eng