SQL Sat Cork 2019 - Pre Con - Troubleshoot and optimize SQL Server like a p...

Event Information

Share this event

Date and Time

Location

Location

Western Gateway Building

Western Road

Cork

Ireland

View Map

Event description

Description

System Troubleshooting and Performance Tuning are always considered to be very challenging tasks. Different problems tend to mask each other degrading performance and affecting user experience in the system.

In this one-day training class, Dmitri (MVP, MCM and author of “Pro SQL Server Internals”) will demonstrate the set of techniques he uses while performing system analysis and performance troubleshooting. Dmitri will show how various issues present themselves in the systems, explain why those issues occur and how to diagnose and address them.

You will learn how to identify and optimize inefficient queries, address concurrency and blocking issues, reduce excessive CPU load, and improve tempdb performance and disk and transaction log throughput. You will see common configuration, database design and code mistakes and understand how to avoid them.

Here more from Dmitri

https://www.youtube.com/watch?v=uZ61z61Kdhw&feature=youtu.be


Modules Covered

  • SQL Server Execution Model and Wait Statistics Analysis

  • Inefficient queries: how to detect and optimize; patterns to avoid

  • Concurrency and blocking issues

  • Query execution, compilation and plan caching issues

  • Miscellaneous issues: latch contention, tempdb issues, t-log throughput, I/O latency, parallelism overhead, etc.

  • SQL Server and Database configuration best practices

Key Takeaways for The Audience

  • Learn how to identify and address common issues in the systems based on Wait Statistics, DMV, xEvents, Performance Counters, DB Schema analysis and other techniques

  • Understand how to identify and tune inefficient queries and indexes

  • Learn how to address concurrency issues in the system

  • Learn how to address other miscellaneous issues (high CPU, bad tempdb performance, t-log and I/O latency, plan caching and others)

  • Understand SQL Server configuration best practice

Demos

The demos will cover multiple common problems (one by one) demonstrating:

  • How problems present themselves in the system (waits, dmvs, perf counters, etc)

  • How to confirm that problems actually exist

  • How to address the problems

Date and Time

Location

Western Gateway Building

Western Road

Cork

Ireland

View Map

Save This Event

Event Saved