SQL Server 6.5: Tuning for Performance
Product Code: SQSC06 Time: 7 Hour(s) CEUs: Available

Summary:

This course provides instruction on tuning Microsoft SQL Server 6.5 to optimize performance.

Objectives:

After completing this course, students will 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

Outline:

  • Configuring and Tuning SQL Server
  • Optimizing SQL Server Configuration Options
  • Measuring SQL Server System Performance
  • Miscellaneous Performance Topics

Features:

  • Exercises that allow users to practice the application
  • 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 application
  • A glossary

Applicability:

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

Prerequisites:

Previous courses in, or experience with, NT Server administrationSQL Server 6.5: IntroductionSQL Server 6.5: Installation and SetupSQL Server 6.5: Users and ReplicationSQL Server 6.5: Database AdministrationSQL Server 6.5: System Management

Technical Requirements:

200MHz Pentium with 32MB Ram. 640 x 480 256-color video (800 x 600 is recommended). Windows 98 or higher. Minimum Connection Speed: 28.8k. Internet Explorer 5.0 or higher (5.5 or higher for MindLeaders Central) required. Macromedia Flash player 6.0 is recommended for full functionality, but not required to play the courses. Sound card, with speakers or headphones is recommended, but not required to play the courses. JavaScript must be enabled. Netscape and AOL browsers not supported.

Google

Copyright Information:


Terms of Use:

None

Copyright © 2004 MindLeaders. All rights reserved.