Training objectives
- Master the necessary tools to monitor and resolve performance problems
- Understand how SQL server is using the resource systems (CPU, I/O, memory, network) and how to configure it for reaching an optimal performance
- Master the key principals of the data access optimization (functioning of the SQL server Optimizer, reading of Execution Plans, anti-patterns, indexing strategy)
- Understand and resolve performance problems related to the locking and transaction system under SQL server
Topics
- DBA toolbox for the performance (extended events, DMV, DTA…)
- Performance modelling (key principals of the normalization, choice of the data type, collation, SQL anti-patterns)
- Internal mechanisms and SQL server maintenance to increase performance (pages and extents, files and filegroups, allocation algorithms, logging and recovery, tempdb)
- Strategy for data indexing (index type, data access and selectivity, management of the fragmentation)
- Transactions and locking (concurrence of the data access and transaction levels, locks, deadlocks, latches)
- Understand execution plans, caching and statistics
- Understand the SQL server wait types
Method
- Presentation with many practical exercises
- Case studies, live demos, discussions
- Networking during coffee breaks, lunch, and apéro on the last day (included in price, except for on-site workshops)
Target groups
- Database administrators (DBA) as well as network, system, and application administrators responsible for or supporting SQL Server databases
- Prerequisite: good knowledge and experience in SQL Server databases
Related trainings & events
- dbi InSite “SQL Server DBA essentials workshop”
Language & documentation
- Workshop training normally held in English; French or German possible instead as course languages
- Documentation: content details, scripts, case study solutions as PDF file (in English)
For your information
- IT performance management : review and tuning
- Testimonials : what customers are saying about dbi services