IT-Practice: SQL Server Performance Workshop

Course PW30

  • Duration:
    • 2 days

Dates:

  • Implementation planned - places still available
  • Implementation - probability high - still places available
  • There are no more seats available. For many courses, it may still be possible to participate online, via virtual classroom.
  • Course times: As a rule, our seminars are held from 10:00 am to 5:00 pm on day 1 and from 9:00 am to 4:00 pm on the following days. Changes are possible. The concrete seminar times you will find in the binding order confirmation.
03.02.2025 - 04.02.2025 Virtual Classroom
  • 1790 EUR / Person
German
23.06.2025 - 24.06.2025 Virtual Classroom
  • 1790 EUR / Person
 German
29.09.2025 - 30.09.2025 Virtual Classroom
  • 1790 EUR / Person
 German
01.12.2025 - 02.12.2025 Virtual Classroom
  • 1790 EUR / Person
 German

The course provides basic knowledge about performance-relevant structures and options in the SQL Server environment. Approaches for performance troubleshooting are discussed and the information provided by Microsoft as "on-board resources" (e.g. via dynamic administration views) and tools for the creation of performance monitoring and trace logs and their evaluation are presented. An introduction to the index structures and index types of MS SQL Server and the necessary maintenance and possible optimisation measures is also covered. Basics and approaches are discussed and further steps are shown.
The course serves to acquire practical knowledge and to exchange experiences. Manufacturer certification is not provided.

Overview of SQL Server architecture and internal structures from a performance perspective

  • SQL Server components and SQLOS
  • Scheduling & Waits
  • SQL Server I/O - Storage, relevant key data, test options
  • Database and file structures
  • SQL Server memory
  • SQL Server parallel processing - blocking, concurrency problems

SQL Server index architecture and statistics

  • Index basics
  • Index types and important differences
  • Statistics
  • Maintenance, upkeep and analysing information

Performance analysis - first steps

  • Current activity
  • Analysing dynamic management views (DMVs)

Further steps - tools, approaches

  • Performance Monitor - important indicators, recording monitor logs, baselining
  • SQL Server Profiler - recording traces, relevant events, filtering
  • SQL Server Extended Events - recording event logs
  • Evaluation approaches
  • SQL Server Query Store

Optimisation options, detailed analysis

  • Database Optimisation Advisor Tool (DTA)
  • Query and execution plan analysis

Administrators of MS SQL Server environments; database developers; SQL Server power users

Basic knowledge of relational databases; basics of working with MS SQL Server and the Windows platform

The course price includes

  • Break catering for face-to-face training: drinks, biscuits and lunch

We are also happy to organise this training as an in-house seminar. Ask for your individual offer.

The course is offered in German.

Contact us

SoftwareONE

IT CAMPUS
Customer Training Solutions

Blochstraße 1
D-04329 Leipzig
*The services of SoftwareONE Deutschland GmbH directly serving school and educational purposes are predominantly VAT-exempt according to § 4 No. 21 a) bb) UStG. Contact us - we are happy to help!