Training

How We Are Different

Course Summaries

Course Logistics

Private Classes

Request for Information

Course Surveys

 

 
Optimizing Microsoft SQL Server 2005

Overview

This class is designed for the DBA, system designer and system architect who are familiar with SQL Server. The student will become proficient with the integration and optimization of of SQL Server on a storage area network (SAN) platform. In addition this class includes the usage and interpretation of the SQL Profiler, optimizing indexes and SQL statements using the Query Analyzer.

Course Objectives

More than sixty percent of SANs deployed today will use one of the major relational database management systems to run applications and present increasing amounts of valuable information to end users. The "Optimizing SQL Server 2005" course combines in-depth technical training on SAN fundamentals with SQL Server concepts, to provide the student with a comprehensive ability to plan, configure and deploy Microsoft’s SQL Server 2000 in a SAN environment.


"Optimizing SQL Server 2005" is designed for the system designer/architect and database administrator. This class will cover not only the architecture and function of the SAN, but how it interacts with SQL Server and how it should be configured in a database Environment. After completing this class, the student will have all the basics to maximize their SQL Server and SAN investment.

Course Agenda

  • Introduction to SAN Architecture
  • Overview of SQL Server 2005 and I/O
  • SQL Server 2005 Parameters
  • SQL Server 2005 Performance Monitor Counters
  • RAID & I/O Topics
  • Architecting a SQL Server SAN solution
  • SAN hardware components and their configuration
  • SAN software components and their configuration
  • SQL Server Clusters on a SAN
  • SQL Server and SAN Performance
  • Backup, Recovery and Disaster Survival

Prerequisites

The student must be familiar with Microsoft SQL Server 2005 or SQL Server 2000. No prior experience with SANs is required.

Lab Work

This course includes hands-on labs where the student can become familiar with SAN hardware in a SQL Server environment.

Delivery

For more information about scheduling this course, please call us at: 1 (800) 887-4513, or e-mail us at:

 
 

Performance TuningŪ Corporation All Rights Reserved
Performance TuningŪ is a Registered Trademark of Performance TuningŪ Corporation
Tune Right - Run FastŪ is a Trademark of Performance TuningŪ Corporation