DB320: SQL Server Troubleshooting & Tuning

Training: Microsoft™ - Databases

Participants learn how to improve SQL Server performance through query techniques, targeted use of indexes, and optimal configuration. The course covers execution plans, join behavior, Query Store, automatic tuning, and monitoring with Profiler and Extended Events. Exercises reinforce troubleshooting bottlenecks and setting up efficient monitoring mechanisms.

Unfortunately there are currently no available appointments.
Would you like to request an appointment? Then click on 'No matching appointment?'

Request prefered appointment period:

* All fields marked with an asterisk are mandatory fields.

Agenda:

  • Fundamentals
    • Hardware-based optimization of SQL Server
    • Configuration of working memory and query memory
    • Usage of filegroups for performance optimization

  • Query optimization
    • Analysis of execution plans
    • Analysis of used JOIN types
    • Internal processing of JOIN operators
    • Control of parallel execution of queries
    • Performance advantages of stored procedures
    • Plan guides for controlling the execution plan of stored procedures
    • Parameterization of queries
    • Query Store
    • Live Query Statistics

  • Performance optimization using indexes
    • Checking the indexing of a database
    • Definition of queries that can use indexes effectively

  • Methods for automatic optimization
    • Automatic tuning
    • Using the Query Store and automatic optimization

  • Monitoring and controlling of SQL Server (performance and security)
    • Profiler
    • Extended events
    • Server and database audits
    • Use of C2 monitoring
    • Data collection
    • Policy management
    • Resource control

  • Techniques for high availability of SQL Server
    • Operation of SQL Server in cluster
    • AlwaysOn high availability groups
    • Database mirroring (for backward compatibility)

  • Methods for information gathering
    • Reports in Management Studio
    • System views
    • Performance counters





Objectives:

The participants of the course DB320 SQL Server Troubleshooting & Tuning learn the optimization of SQL Server performance through various aspects regarding server configuration as well as through customized query techniques.

Target audience:

This 3-day workshop DB320 SQL Server Troubleshooting & Tuning is ideal for:

  • Database Administrators
  • SQL Users

Prerequisites:

To follow the learning pace and course content of the training DB320 SQL Server Troubleshooting & Tuning effectively, participants should have fundamental knowledge of SQL Server functionality and usage. Experience in SQL programming language and SQL Server administration is advantageous.

We recommend prior attendance of the trainings:

Description:

The 3-day workshop DB320 SQL Server Troubleshooting & Tuning is designed for database administrators and SQL users with basic knowledge in SQL Server and SQL programming. Participants learn to improve SQL Server performance through query techniques, targeted use of indexes, and optimal configuration.

Key topics include analysis of execution plans and JOIN behavior, utilization of Query Store, automatic tuning methods, and monitoring with tools like Profiler and Extended Events. Additionally, high availability with Clustering and AlwaysOn is covered. Hands-on exercises enable identification and resolution of performance bottlenecks as well as implementation of efficient monitoring mechanisms.

check-icon

Guaranteed implementation:

from 2 Attendees

Booking information

Price:

2.100,00 € plus VAT.

(including lunch & drinks)

Authorized training partner

NetApp Partner Authorized Learning
Commvault Training Partner
CQI | IRCA Approved Training Partner
Veeam Authorized Education Center
Acronis Authorized Training Center
AWS Partner Select Tier Training
ISACA Accredited Partner
iSAQB
CompTIA Authorized Partner
EC-Council Accredited Training Center

Memberships

Allianz für Cyber-Sicherheit
TeleTrust Pioneers in IT security
Bundesverband der IT-Sachverständigen und Gutachter e.V.
Bundesverband mittelständische Wirtschaft (BVMW)
Allianz für Sicherheit in der Wirtschaft
NIK - Netzwerk der Digitalwirtschaft
BVSW
Bayern Innovativ
KH-iT
CAST
IHK Nürnberg für Mittelfranken
eato e.V.
Sicherheitsnetzwerk München e.V.