Practical SQL Server Performance Analysis - Andreas Wolter

hero
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.

On Friday 29 June 2018 at 9:00am till 5:00 pm

Location

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

Contact Details

Map
Contact Form
Practical SQL Server Performance Analysis - Andreas Wolter

Make a booking, click below

Resend tickets to your email address.

Contact the event organiser.

You can review the event organiser's terms and conditions here.

Practical SQL Server Performance Analysis - Andreas Wolter

Contact name: SQL Saturday Melbourne

Your name is required. Your name contains invalid characters.
Message is required.

You can review the event organiser's terms and conditions here.

If you can't find your tickets, click here.

Your email has been sent.

The organiser will be sent the details of this message.

Sorry

Sorry, there appears to have been an error. Please try again later.