Just nu kan du inte boka den här utbildningen. Besök sidan Infrastruktur och ta en titt på Informators aktuella kurser.
MS50487
Advanced SQL Server 2008 R2: Tuning a Scalable and Performance-Optimized Database Environment
This three-day 300-400 level Instructor-Led Training course focuses on performance and tuning tasks: architecture, memory, waits and events, storage, CPU, DML processing, concurrency, TempDB considerations, and diagnostics toolsets in a scale-up or scale-out infrastructure. Throughout the course, students practice the art of tuning many key components of the SQL Server 2008 R2 environment through a series of labs and demonstrations. Performance and tuning best practice methodologies are emphasized and practiced in the labs and demonstrations rather than taught. The course covers a broad spectrum of features with numerous deep dives into key areas required for building scalable and performance optimized database environment in real-world scenarios.
This training can be paid by SA-Voucher
OBS! Denna kurs har dragits tillbaks av Microsoft och i nuläget har vi inga klara releasedatum framåt! Självklart är du välkommen att kontakta oss så vi snabbt kan återkoppla när vi får mer info själva!
Audience:
This course is for experienced IT Professionals who work in an enterprise-level environment and require the skills to support and maintain a highly available Microsoft SQL Server 2008 R2 database servers.
Course outline:
Module 1: Introduction
This module explains how SQL Server 2008 R2 has many varied services and components that can be run together or installed separately across servers.
Module 2: SQL Server Architecture
This module explains how SQL Server 2008 R2 architecture governs its behavior.
Module 3: Waits and Extended Events
This module explains how SQL Server 2008 R2 offers a range of means for capturing performance related data for further evaluation.
Module 4: Management Data Warehouse (MDW)
This module explains how to perform SQL Server 2008 R2 performance monitoring and base lining, replay traces and monitor the server for performance issues.
Module 5: Performance and Tuning Tool Sets
This module explains how SQL Server 2008 R2's performance can be analyzed and how tuning can be performed.
Module 6: Workload Conflicts and how to Govern them in SQL Server
This module explains how to perform workload governance using SQL Server's Resource Governor.
Module 7: Memory Management and Configuration
This module explains how SQL Server 2008 R2 allocates and uses memory and how it can be monitored and configured.
Module 8: Storage Hardware Considerations and Best Practices
This module explains how SQL Server 2008 R2 uses storage resources and how it can be monitored and configured.
Module 9: Data Placement and Handling Best Practices
This module explains how SQL Server 2008 R2 uses space and how such things as various indexing approaches can influence that usage.
Module 10: Tuning the Brain - The CPU
This module explains how SQL Server 2008 R2 uses the CPU resource and how it should be considered, how it can be monitored, and configured.
Module 11: The Ever Present TempDB
This module explains how SQL Server 2008 R2 uses TempDB and how it can be configured if necessary to cope with heavy loads.
Module 12: The Lock Architecture
This module explains how SQL Server 2008 R2 isolation levels affect locking behavior.
Module 13: SQL Engine and the Query Processing Architecture
This module explains how the SQL Server 2008 R2 query optimizer uses indexes, statistics, plan guides, and plan cache management.