Synopsis
SQL Server 7 Admin: Monitoring Events shows users how to monitor and trace engine events.

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: LA7C16
After completing SQL Server 7 Admin: Monitoring Events the user should be able to:

Monitor SQL Server engine event performance
Explain tracing and trace architecture
Create traces using the Create Trace Wizard SQL Server Profiler and extended stored procedures
Run and save traces
Modify and replay traces

Introduction to Monitoring
Monitoring SQL Server
Goals of monitoring
Tools for monitoring SQL Server

Understanding Trace Architecture
Monitoring event categories
Data columns logged for all events
Data columns logged for specific events

Creating Traces with the Trace Wizard
Creating a trace
Running a trace
Viewing and saving a trace

Creating Traces with Other Tools
Using SQL Server Profiler
Using Extended Stored Procedures

Managing Traces
Running traces
Modifying traces
Replaying traces

Analyzing Traces
Replay options
Creating and replaying SQL scripts

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: Watching & Optimizing (LA7C17)
SQL Server 7 Admin: Server Repair (LA7C18)
SQL Server 7 Admin: More Troubleshooting (LA7C19)

Microsoft® is a registered trademark of Microsoft Corporation.