september, 2020

fri18sepAll DayI will speak at SQL Saturday CroatiaMicrosoft SQL Server Performance Tuning(All Day: friday) CEST Hotel International Croatia, Miramarska 24, Zagreb, 10000, Croatia

sql-saturday

Abstract

Optimizing the performance of your SQL Server has always been important, but now this task becomes even more important. In times of cloud database services, with a well-functioning SQL Server you can save a lot of money by down-scaling your database or simply get more performance for your money.
In this practical one-day workshop you will learn how to optimally set up, configure and monitor your SQL Server to get the most out of your database.

In detail we will cover the following topics:

  • Concept of the non-preemptive SQLOS
  • Setting of Maximum Degree of Parallelism and Cost Threshold for Parallelism
  • Analyse and resolve waits like latches and blocks
  • PFS, SGAM, GAM, Extent Management
  • Add the best number of files in user database and tempdb
  • Interpret the Query Plan
  • Understand the most common iterators and their memory, CPU and IO impact
  • Use Query Store to find most expensive queries and detect plan regression
  • Index tuning

Speaker for this event

  • Torsten Strauß

    Torsten Strauß

    MVP | MCSE | MCT

    Torsten (MVP, MCSE, MCT) has been working with Microsoft SQL Server since the turn of the millennium and is specialized in performance optimization for large SQL Server environments. He has been a Database Engineer at BP for over two decades and has also been working for SARPEDON Quality Lab as a Principal Microsoft SQL Server Consultant for many years. Torsten is the founder of inside-sqlserver.com and has given more than 120 presentations on Microsoft SQL Server performance optimization at national and international conferences and user groups. Torsten has been recognized as a Microsoft Most Valuable Professional for Data Platform since 2018.

    URL https://inside-sqlserver.com/

    MVP | MCSE | MCT

Organizer

PASS SQLSaturdaycommunityteam@pass.org