Database administration is a fundamental responsibility but we are often reactive to a ticket, an email or conversation about something that happened after the fact. But without a set known-good measurements to compare against how do you know what to look at? This session will show you how to capture a performance baseline for a SQL Server instance. The session will help you decide what and when to capture data and where to store it. Then we will walk through different tools and scripts to use.
What I will leave with: Understanding of methods and tools to capture performance and identify issues. You will be able to start collecting performance information and be more knowledgeable about your environment.