+49 (911) 80 10 30

Give us a call or have us call you back!

Simply leave a message with your callback appointment

Your Name *

Your phone number *

Callback date *

Callback time *

Your request *

In order to process your request, it is necessary to process the data you provide. This means that by submitting the contact form, you consent to your data being processed (see Privacy Policy). You can object to the processing of your data at any time.

* All fields marked with an asterisk are mandatory fields.
Send a message

Your Name *

Your email *

Your phone number

Your request *

In order to process your request, it is necessary to process the data you provide. This means that by submitting the contact form, you consent to your data being processed (see Privacy Policy). You can object to the processing of your data at any time.*

* All fields marked with an asterisk are mandatory fields.
Social Media

Share page

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.

Appointment selection

Appointments in English language (0)


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

Possible course languages: German

Request prefered appointment period:

Your Name *

Your email *

Your phone number

Preferred period from *

Preferred period to *

Number of participants *

Your message

* All fields marked with an asterisk are mandatory fields.

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

Request prefered appointment period:

Your Name *

Your email *

Your phone number

Preferred period from *

Preferred period to *

Number of participants *

Your message

* 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.