Platinum Sponsor

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.

Presented by Brent Ozar at SQLBits V
  • Downloads
    Video available WMV Video 210 MB
  • SpeakerBIO
    brent_ozar.jpg
    Brent Ozar is a Microsoft Certified Master of SQL Server and an MVP.  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.
    http://www.brentozar.com/ http://feeds2.feedburner.com/BrentOzar-SqlServerDba
  • Video
  • Session Files Explorer
    The network name cannot be found.