This event has no dates available for booking. Please contact the event organiser.

Practical SQL Server Performance Analysis - Andreas Wolter

This full-day Precon will teach you techniques for general troubleshooting and performance analysis from start-up to advanced techniques. A Highlight is the possibility to connect live to the Demo Server hosted on Azure via your local SSMS to analyze prepared scenarios on your own. This is probably the first ever PreCon with a continuously running workload for analysis by all attendees! We analyze a choice from the following scenarios:
• Investigating Memory Problems
• Identifying Plan Regression
• Analysis of Indexes & Statistics
• Detecting I/O Latency problems
• Investigating Tempdb Performance
• Locking & Blocking Analysis, Concurrency problems
Techniques & Tools taught:
• SQL Server Architecture & Internals
• Monitoring Methodology, Tools & Techniques:
• Dynamic Management Views (DMVs)
• Wait Statistics
• Extended Events for Workload & Query-Analysis
• Query Store
• By request: Overview on Third-Party tools

Expect lots of demos and a deep dive into core concepts of SQL Server.

Andreas Wolter has been specialized in SQL Server for 18 years. He is not only a Microsoft Certified Master (MCM) but also one of 2 Microsoft Certified Solutions Masters Data Platform (MCSM) in the Asia Pacific Region and has been awarded with the MVP several times.
His company Sarpedon Quality Lab, which offers its services in Europe, the Middle East, Southeast Asia, and Australia is focusing on development and optimization of high performing OLTP Systems and big Data Warehouse Architectures.

till 5:00 pm


Multicultural Hub
Level 1, 506 Elizabeth Street, Melbourne, Victoria 3000

Contact Details