SQL Server Performance Tuning Nowadays

Nothing is perfect, which means that your database might not be 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? Which queries are slow? How to identify the actual bottleneck? And so on, and so on. There are a lot of questions that need answers in the process of performance tuning. In this full-day training session, we will find answers to all these questions. We will go 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 many issues in real-time. And despite I’m (well, maybe I was) a big fan of Profiler and old-fashioned tools and technics, new, more exciting, and valuable instruments are available nowadays. And we will use them to find the bottlenecks and tune the performance with a minimum of theory and a lot of practice.