Monitoring and Performance Tuning T-SQL Queries

• The primary audience for this course is individuals who develop and optimize SQL Server database solution and queries

• Describe query lifecycle
• Monitor queries and analyze performance problems
• Desing and optimize index strategy
• Understand query plans
• Descripe transactions and concurrency

• Basic knowledge of the Microsoft Windows operating system and its core functionality
• Working knowledge of Transact-SQL
• Experience with database design

Query lifecycle

• SQL Server architecture
• Query lyfecycle
• Query optimization process
• SQLOS, Memory, CPU, Threads
• Performance killers

Monitor queries and analyze performance problems

• Performance Monitor
• SQL Profiler
• Dynamic Management Views
• Activity monitor
• Data Collector
• Extended Events
• Performance problem analysis

Index strategy

• Deep index description
• Index design
• Statistics
• Index maintenance
• Index monitoring

Execution plans

• What is execution plan ?
• Plan reading and analysis
• Plan caching
• Adhoc and procedure plans

Concurrency control

• Transactions and concurrency control
• Locks
• Transaction Isolation Level

Previous courses

Database design and programming in Microsoft SQL Server and Azure SQL Database [GOC632]

Creation of advances T-SQL queries in Microsoft SQL Server [GOC278]

Related courses

Microsoft SQL Server Monitoring and Performance Tuning [GOC630]