Microsoft SQL Server Monitoring and Performance Tuning

The course is designed for database professionals who have experience with the management or development of a database system and want to be able to effectively monitor and tune the performance of the database system.

• We will introduce you into the SQL Server sources and how they are used
• Methods for SQL Server monitoring
• Evaluation of measured values and identification of the problem
• Recommended configurations and solving methods

• Basic knowledge of Microsoft Windows operating systems
• The ability to understand and work with T-SQL at the level of the MOC 2778 or GOC277 course
•  Knowledge in the field of database administration at the level of the course MOC 6231

Basic SQL Server sources and the work with them

• SQL Server Architecture
• Memory Usage
• Working with the repository
• CPU and queries execution
• Object Lock  and Latches
• Tempdb System Database

Methods for Monitoring SQL Server

• Performance Monitoring
• SQL Profiler
• Dynamic Management Views
• Evaluation of measured values and identification of the problem
• Activity monitoring
• Data Collector
• SQLDiag
• Extended Events
• SQLIO

Evaluation of measured values and identification of the problem

• Information about performance counters and their characteristics
• Recommended counters ‘ values
• Identifying of possible bottlenecks and problems

Recommended configurations and methods of solution

• SQL Server configuration and recommended procedures
• Database configuration and recommended procedures
• Identification of possible bottlenecks and problems

Previous courses

Complete Administration of Microsoft SQL Server [GOC6345]

Related courses

Monitoring and Performance Tuning T-SQL Queries [GOC631]