You are leaving our Website
Using an external Link:
You are now leaving our website. The following page is operated by a third party. We accept no responsibility for the content, data protection, or security of the linked page..
URL:
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?'
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.
Guaranteed implementation:
from 2 Attendees
Booking information
Price:
2.100,00 € plus VAT.
(including lunch & drinks)
Appointment selection:
No appointment available
Authorized training partner
Authorized training partner
Memberships
Memberships
Shopping cart
DB320: SQL Server Troubleshooting & Tuning
was added to the shopping cart.