Infrastructure at your Service

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 09-11.11.2021
Basel 23-25.11.2021
Zurich 23-25.11.2021
Bern 23-25.11.2021
OnSite/InSite On demand
3 days
CHF 2700.- *

Trainers

  • StĂ©phane Haby
    Stéphane Haby

By booking a dbi services’ InSite workshop, the customer commits to respecting the Sales and Service General Conditions

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

-5% for SOUG, SwissPUG, or DOAG members
Members of the SOUG (Swiss Oracle User Group), SwissPUG (Swiss PostgreSQL User Group) or DOAG (Deutsche Oracle-Anwendergruppe) are entitled to a discount of 5% on our trainings

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" (in your premises) workshop for you ? 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 ?