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.
Speaker focus
Brent Ozar is a Microsoft Certified Master of SQL Server and an MVP. He's a consultant and trainer for SQLskills, a leading database consulting company founded by Paul Randal and Kimberly Tripp. He has over a decade of broad IT experience, performing systems administration and project management before moving into database administration. Brent specializes in performance tuning, disaster recovery and automating SQL Server management. He has worked as a SQL Server expert for Quest Software, and a SQL/SAN/VMware administrator for a $7b wine & spirits distributor.
Brent has experience conducting training sessions, has written several technical articles, and blogs prolifically at http://www.BrentOzar.com. He coauthored SQL Server Internals and Troubleshooting for Wiley/Wrox along with Christian Bolton, Justin Langford, James Rowland-Jones, and Jonathan Kehayias.