Using DMVs for Performance Root Cause
Duration: 60 minutes
Track: Enterprise Database Administration & Deployment
What are your first steps when you hear one of your SQL Servers is having a performance problem? In this demo-driven session, we will discuss key DMVs that can provide us data quickly. We will examine a number of example queries that can lead us to a quick root cause analysis in a number of different situations. This session will be kept at a very functional level, and should be accessible for anyone interested in SQL Server performance.