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: 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.