SQL Server Performance Tuning and Troubleshooting

Hi There,

Do not miss the 8-hr virtual class happening at Data Platform Virtual Summit 2022.

Pre-Con: SQL Server Performance Tuning and Troubleshooting

Abstract: Nothing is perfect, which means that your database maybe not perfect as well. And one day you may decide that your database is slow and it’s time to optimize it. But.. Where to start? When to end? What to look at? Which queries are slow? How to identify the real bottleneck? And so on, and so on. There are a lot of questions that should be answered in a process of performance tuning.

In this workshop, we will find answers to all these questions going from collecting data for analysis, through identifying bottlenecks to optimization of the particular queries. In this way, we will learn performance tuning practical techniques and solve a bunch of issues in real time. And despite I’m a big fan of Profiler and old-fashioned tools and technics, new, more interesting and useful instruments are available nowadays, so will use them to find the bottleneck and tune performance. Minimum of theory and a lot of practice.

Date: Sep 12 & 13.

Time: 06:30 AM to 10:30 AM EDT (View in your timezone)

Modules: