Practical Performance Monitoring & Troubleshooting SQL Server

Precon Session Details

You are in a DBA, developer or consultant role, supporting SQL Server databases and often someone asks you to take a look at a badly performing database application, certain queries or even “the whole server”. Over and over again you find yourself in the situation of “how to find the root cause in the least amount of time”.

This full-day precon with Andreas Wolter, a former Program Manager for SQL Server at Microsoft, will teach you techniques for general troubleshooting and performance analysis from start-up to advanced techniques.

Among them are:

• SQL Server architecture & internals – the fundament to understanding correlations
• Monitoring methodology, tools & techniques
• Windows Performance Monitor
• Dynamic Management Views (DMVs)
• Wait statistics
• Extended Events for workload & query-analysis
• Query Store
• Azure SQL database watcher (intro)
  
  The above techniques will be used to:
• Identify the most impactful problematic queries
• Detect I/O latency problems
• Investigate Tempdb performance
• Analyze indexes & statistics
• Analyze locking & blocking and concurrency problems
• Identify query plan regression
  
  While no one has evolved into a performance-tuning-master in one single day, you can be sure to learn valuable techniques and concepts to build upon for day-to-day work. And of course, we will also discuss possible solutions or even implement them live. So, at your next phone call “Help, the server is slow!” you know will where to start.
  
  Expect lots of demos and a deep dive into core concepts of SQL Server.
  
  Hands-on! – Attendees who want to directly try out some of the techniques shown can connect to the demo-server which is under a constant workload simulation live with SQL Server management studio themselves! (All that is required is to bring a laptop with SSMS installed and ability to connect to a SQL Server on the internet on a given port)

About the Speaker:

Andreas Wolter

Data Architect, Security, Sarpedon Quality Lab

Andreas Wolter is a former Program Manager for Access Control in Azure SQL and SQL Server at Microsoft. In this role, he led the design of the external authorization system used by Purview policies and Azure database and data warehouse in Fabric. He was also the driving force behind the revamping of the permission system, introducing new permissions and roles that allow for monitoring and troubleshooting without elevated privileges, covering more than 600 system views and commands used by Azure's database watcher and other SQL Server performance monitoring tools.

With 25 years of experience in SQL Server across various clients and industries, Andreas is one of only seven Microsoft Certified Solutions Masters for Data Platform (MCSM) worldwide. He has been a frequent speaker at conferences for over a decade and regularly shares insights on data security and performance through his blog at andreas-wolter.com/en/blog-en.

Andreas is the founder of Sarpedon Quality Lab LLC, a consulting company specializing in SQL Server performance, high availability, and security, which he manages in partnership with Sarpedon Quality Lab Germany.

Event Logistics

This all-day precon is intended to provide extensive training, and therefore attendees are encouraged to remain on-site for the entire day, if possible. Breakfast, lunch, coffee, and beverages will be provided. There will be breaks throughout the day, provided at times that fit well into the precon content.

Group discounts are available for any group registering with 5+ attendees. Please contact us for more information on this savings opportunity.