Performance Monitoring & Troubleshooting
|Level||300 – Advanced|
|Price||Early Bird 130€ Until 17th of september
Regular 150€ after 17th of september
|Location||Microsoft Danmark – Kanalvej 7, 2800 Lyngby|
|Times||09.00 – 17.00|
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”. And 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 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 complex correlations
- Monitoring Methodology, Tools & Techniques
- Dynamic Management Views (DMVs)
- Wait Statistics
- Extended Events for Workload & Query-Analysis
- Query Store
- Investigating Memory Problems
- Identifying and Remediating Plan Regression
- Analysis of Indexes & Statistics
- Detecting I/O Latency problems
- Investigating Tempdb Performance
- Locking & Blocking Analysis, Concurrency problems
- What to look for with In-Memory objects
Note that we will not look (back) at Profiler however and solely focus on the current tools & techniques working from SQL Server 2012 onwards up to SQL Server 2016.
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: If you want to play along please bring a laptop running SQL Server 2012 or newer, with at least 20GB of free drive space. I will distribute the demo databases for you to restore, and you can follow along with the demos with the likewise provided scripts. But you are welcome to just sit back and consume this one fully packed one day precon.
Prerequisites: Basic understanding of the SQL Server relational engine and Transact-SQL, Basic familiarity with Dynamic Management Views (DMVs) and Query Plans
Andreas Wolter is both a Microsoft Certified Master (MCM) on SQL Server 2008 and a Microsoft Certified Solutions Master Data Platform (MCSM) SQL Server 2012 and has also been awarded with the MVP for SQL Server.
He is the founder of Sarpedon Quality Lab, a Germany-based company that specializes in Development and Optimization of SQL Server Database- and Datawarehouse-architectures with focus on performance and scalability as well as a special passion for security.
With over a decade of experience with SQL Server he can be met at various international conferences and delivering training for the SQL Server Master-Class seminar-series held in Europe.
You can follow him at Twitter at @AndreasWolter.
Microsoft Danmark – Kanalvej 7, 2800 Lyngby