Optimizing Microsoft SQL Server (includes SAN)

The student will become proficient with the integration 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.
The student must be familiar with Microsoft SQL Server 2005 or SQL Server 2000. No prior experience with SANs is required.
1 Day/Lecture & Lab
This class is designed for the DBA, system designer and system architect who are familiar with SQL Server.
  • Introduction to SAN Architecture
  • Overview of SQL Server 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

Related Scheduled Courses