Loading Course Schedule...
PT5919
Training Summary
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.
Prerequisites
The student must be familiar with Microsoft SQL Server 2005 or SQL Server 2000. No prior experience with SANs is required.
Duration
1 Day/Lecture & Lab
Audience
This class is designed for the DBA, system designer and system architect who are familiar with SQL Server.
Course Topics
- 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