Synopsis
SQL Server 7 Admin: Watching & Optimizing shows users how to monitor and tune resource usage by SQL Server.

Audience
This course is for database administrators who want to learn how to administer SQL Server 7.0 or who are preparing for the MCSE exam 70-028: Administering Microsoft SQL Server 7.0.

Time
3 hours

Product Code: LA7C17
After completing SQL Server 7 Admin: Watching & Optimizing the user should be able to:

Monitor SQL Server performance
Tune and optimize SQL Server
Limit resources used by queries

Monitoring Disk I/O Performance
Exploring Performance Monitor
SQL Server objects
Monitoring disk performance

Monitoring CPU and Memory Usage
Monitoring CPU resources
Monitoring memory usage

Other Monitoring Processes
Monitoring with SQL Server Enterprise Manager
Monitoring with T-SQL commands

Optimizing Server Performance
Tuning guidelines for SQL Server
Optimizing memory usage
Optimizing I/O performance
Changing the options
Optimizing CPU usage

This course has the following features:

Exercises that allow users to practice in SQL Server 7.0
A file containing the text of the exercises
Simulations that allow users to practice course skills even if they don't have access to SQL Server 7.0
A glossary
A Skill Assessment

Courses on Relational Database Management Systems or equivalent experience
Courses on Windows NT administration or equivalent experience
Courses on Database Concepts or equivalent experience
Courses on SQL or equivalent experience
SQL Server 7 Admin: Security Strategy (LA7C01)
SQL Server 7 Admin: System Requirements (LA7C02)
SQL Server 7 Admin: Migration Planning (LA7C03)
SQL Server 7 Admin: Replication Plans (LA7C04)
SQL Server 7 Admin: Installing the Server (LA7C05)
SQL Server 7 Admin: Other Installations (LA7C06)
SQL Server 7 Admin: Configuring (LA7C07)
SQL Server 7 Admin: Security Management (LA7C08)
SQL Server 7 Admin: Managing Accounts (LA7C09)
SQL Server 7 Admin: Managing Permissions (LA7C10)
SQL Server 7 Admin: Database Management (LA7C11)
SQL Server 7 Admin: Loading Databases (LA7C12)
SQL Server 7 Admin: Backups and Restores (LA7C13)
SQL Server 7 Admin: Managing Replication (LA7C14)
SQL Server 7 Admin: Management Tasks (LA7C15)
SQL Server 7 Admin: Monitoring Events (LA7C16)

SQL Server 7 Admin: Server Repair (LA7C18)
SQL Server 7 Admin: More Troubleshooting (LA7C19)

Microsoft® is a registered trademark of Microsoft Corporation.