techorama, deep knowledge IT conference
May 06 - 08 | 2024 Antwerp | Belgium

0 (Zero) to Hero: Essential SQL Server Performance Tuning for Everybody

Monday 06 May

09:00 - 17:00

Pinal Dave

This demo-oriented day-long session revolves around a storyline of an organization where various performance tuning issues shows up. We assume the role of newbie and discuss essential performance tuning concepts to manage the day-to-day operations of SQL Server.
The basic philosophy behind this session is that every day should have a personal favourite script toolbox that they can use when facing adverse situations.
A very common workflow for fixing any performance problem is in two steps:
Part 1: Run Diagnostic Queries
Part 2: Run Problem Resolving Queries
We take the above workflow and play a new employee role in the organization. Here are a few topics we discuss during the session and each of the topics has its challenges, solutions, and ready to run scripts.
• How to Solve Common Performance Issues - Reactively?
• Resource Bottlenecks – IO, CPU, Memory
• TempDB and Contention
• Identifying Slow Running Queries
• Indexing Issues and Quick Fixes
• Wait Stats and Queries
• Statistics and Execution Plans
• Live Plans
• How to Solve Common Performance Issues – Proactively?
• Index Strategies
• Database File Deployments
• Resource Governor and Alerts
• In-Memory OLTP Optimization
• Columnstore Indexes
• Query Store
At the session's end, every attendee receives all the demos executed with the necessary explanation. Additionally, we prepare an action item list to diagnose any SQL Server for performance-related issues and their potential solutions.
Time to get started with your journey to Essential SQL Server Performance Tuning.
Note: This session is built keeping both online attendees and in-person attendees in mind. It is equally exciting and interactive for both of them.

Pinal Dave is a SQL Server Performance Tuning Expert and an independent consultant. He has authored 12 SQL Server database books, 35 Pluralsight courses and has written over 5200 articles on database technology on his blog at a Along with 17+ years of hands-on experience, he holds a Masters of Science degree and a number of database certifications.