The SQL Server Performance Optimization and Troubleshooting training course is designed to demonstrate the knowledge and skills to improve the performance of their SQL servers.
The course begins with a look at some common real-life performance problems based on customer case studies. Next, it explores techniques to scope performance issues using the top-down troubleshooting approach. The course concludes by examining many techniques for troubleshooting and improving performance.
Purpose
|
Learn to address common real-life performance problems both at the server and T-SQL code level. Learn about troubleshooting approaches, techniques, features and tools with SQL Server 2019 and Azure SQL Database. |
Audience
|
Developers, data analysts, and database administrators who work with the SQL Server database platform on-premises or in Azure and troubleshoot performance related problems. |
Role
| Data Engineer - DevOps Engineer - Software Developer - System Administrator |
Skill Level
| Intermediate |
Style
| Workshops |
Duration
| 5 Days |
Related Technologies
| Back-End Development Training | SQL | Cloud Computing Training | Azure |
Productivity Objectives
- Utilize the top-down troubleshooting approach that includes detailed problem scoping
- Identify troubleshooting entry points with wait statistics
- Apply troubleshooting approaches with different scopes in on-premises SQL Server and Azure database-as-a-service environments
- Analyze a database environment and do health checks
- Identify configuration and sizing problems including major red flags
- Identify and troubleshoot resource utilization (CPU, memory, and IO) problems
- Use tools and scripts to monitor and troubleshoot the server and your T-SQL workload
- Utilize T-SQL coding best practices to avoid common performance and scalability bottlenecks and identify coding antipatterns
- Utilize optimal indexing and identify indexing related performance problems
- Analyze query plans to both prevent and identify performance and scalability problems at the T-SQL code level