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.
|
Get more out of your Software
Improve your Skills
Prepare for Certification
Save time every time and reduce frustration.
Our online training material lets you:
TEST your skills
LIST the areas where you need additional training
Take lessons that TEACH SKILLS to improve these areas
Tests your skills again
NO HIDDEN CHARGES.
NO SETUP or SHIPPING CHARGES.
NO ads or banners in the training material.
No selling of your personal information, no email lists.
Just 100% Quality Training at one low price.
Repeat the courses as often as you need, you have 12 months of unlimited
access and can view your scores anytime so you can easily track your progress.
Our training is tested and guaranteed to provide RESULTS and save you TIME.
All courseware is online 24 hours a day.
Our courseware is optimized so content delivery is fast even with a 28.8 modem
connection.
If you can get on the Internet you can access the training, ANYWHERE, ANYTIME.
