Infrastructure at your Service

Homepage » Trainings » SQL Server Performance Tuning workshop

SQL Server Performance Tuning workshop

dbi InSite Workshops

Is the resolution of performance issues on SQL Server a problem? Your users are complaining about the slowness of applications? You are facing a lack of knowledge in this area and do not know where to start with. Our workshop dbi InSite SQL Server Performance Tuning, including many examples, covers all aspects you need to master regarding tuning and troubleshooting SQL Server. How to improve the performance of your Microsoft infrastructure? This is what our experts are going to show and explain you during this workshop.

Training’s dates

Nyon 03-05.03.2020
Basel 16-18.06.2020
Zurich 16-18.06.2020
Bern 16-18.06.2020
On-site workshop On demand
3 days
CHF 2700.- *

Trainers

  • Stéphane Haby
    Stéphane Haby

(*) Prices are to be considered per participant and without VAT

SOUG (Swiss Oracle User Group) The members of the SOUG (Swiss Oracle User Group) benefit from a 5 % reduction.

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

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

dbi InSite Workshop - book now!

You want to book a dbi InSite Workshop or get more information on our IT trainings? Please fill in the entry form below. We will confirm your participation or come back to you as soon as possible. If, to our regret, the workshop is already fully booked, we will inform you on other dates or alternative solutions.

Training sessions :




Please contact me via :

E-mailPhone

Where did you know dbi services ?



dbi InSite Workshop on-site - request & information

You want dbi services to hold an "on-site" workshop inside your organisation? You have special requirements, e. g. regarding the content, the duration, the date, or the number of participants?
We have good news for you: Our dbi InSite Workshops can be flexibly adapted to your needs! Please just fill in the form below and we will come back to you as soon as possible. You may also use this form to inquire on the future dates of our dbi InSite Workshops.





Please contact me via :

E-mailPhone

Where did you know dbi services ?