Using Perfmon and Profiler
Learning Performance Monitor and Profiler are the first step in performance tuning. Brent Ozar will show you how to get started with these tools, how to slice and dice the results, and even how to data mine the results to look for interesting trends. Whether you like to monitor performance with native tools or third party utilities, knowing how the native tools work will help you get better results.
Attendees will learn why Perfmon is like a Nissan GT-R's dashboard, how to interpret the best Perfmon counters, and how to use free tools like ClearTrace and data mining to take your tuning to the next level.
Brent Ozar specializes in making SQL Server faster and more reliable.
He's a Microsoft Certified Master of SQL Server and MVP, and he has over a decade of experience. He coauthored Professional SQL Server 2008 Internals and Troubleshooting, created sp_Blitz™ and sp_AskBrent™, and he loves sharing knowledge at BrentOzar.com.