SQL Server 2012 Optimization, Performance Tuning and Troubleshooting

During this five-day intensive course, students will learn the internal architecture of SQL Server and the typical environments it operate in. This will enable them to better diagnose problems and improve the performance of their SQL Server environments. Students will also dive through the various bottlenecks of SQL Server, learn how to optimize them, and troubleshoot common problems.
Before attending this course, it is recommended that students have the following skills:Experience with SQL ServerUnderstanding of database concepts Experience with SQL Server administration Experience with Transact-SQL programming Knowledge of SQL Server Performance Tuning concepts
5 Days/Lecture & Lab
This course is intended for SQL Server administrators who are responsible for monitoring, troubleshooting and optimizing database servers and installations and SQL Server developers who are responsible for developing efficient SQL Server queries and stored procedures
  • SQL Server Architecture
  • SQL Server CPU
  • Introduction of SQL Server Memory Architecture
  • SQL Server Files and Filegroups
  • Introduction to Disk Subsystem Terminology and Architecture
  • Physical Architecture of Databases and Storage Internals
  • Transaction Log and tempdb
  • Monitoring and Tuning the Performance of the SQL Server Disk Subsystem
  • Introduction to SQL Server performance tuning tools
  • SQL Server concurrency
  • SQL Server Locking
  • SQL Server Data Types
  • Statistics
  • SQL Server Indexing and Index Maintenance
  • Execution Plans
  • Poorly Performing Coding Practices
  • Plan Guides, Query Hints, UDFs, and Computed Columns
  • SQL Server Partitioning
  • Optimizing Data Loading
  • Database Maintenance

Related Scheduled Courses