SQL Server 7 Admin

Education Online - Career Education --- e-learning for Everyone.

Home

Training

Products

Specials

Tips

Resources

Login

FAQ's

Free Demo

Courses

Certification

Pricing

News

Contact Us

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.