SQL Server 6.5: Tuning for Performance

Synopsis
SQL Server 6.5: Tuning for Performance provides instruction on tuning Microsoft ® SQL Server TM 6.5 to optimize performance.

Audience
This course is for anyone preparing for the MCSE Exam 70-026 System Administration for Microsoft ® SQL Server TM 6.5 or anyone who needs to tune SQL Server to optimize its performance.

Time
7 hours

Product Code: SQSC06

After completing SQL Server 6.5: Tuning for Performance the user should be able to:

Select the appropriate settings for locks

Configure the number of worker threads

Select the appropriate settings for read ahead

Identify the benefits of installing the tempdb database in RAM

Tune and monitor memory use

Configuring and Tuning SQL Server

Configuration Variables

Setting Configuration Options

Optimizing SQL Server Configuration Options

Memory Utilization

Validating Memory Configuration

Optimizing Parallel Read Operations

Measuring SQL Server System Performance

Using Performance Monitor

Monitoring SQL Server Performance Counters

Miscellaneous Performance Topics

BCP and Performance

tempdb and Performance

This course is distributed with

Exercises with sample files that allow users to practice in SQL Server 6.5

A file containing the text of the exercises

Simulations that allow users to practice course skills even if they don't have access to the SQL Server 6.5 product

A SQL Server 6.5 glossary

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.