Video unavailable

SQLBits 2009

Using Perfmon and Profiler

Got a slow application or server, and not sure where to start? Brent will explain how to use the two most popular free tools and how to read their results.

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

Brent Ozar loves to make SQL Server faster. He created sp_Blitz and the SQL Server First Responder Kit, and he loves sharing knowledge at BrentOzar.com.

Brent Ozar's Sessions

The Ascending Key Problem

300-Level Guide to Career Internals: Planning Your Career

500-Level Guide to Career Internals: Building a Brand

Fragmentation Explained in 20 Minutes

The New Robots in SQL Server 2017, 2019, 2022, and Azure

Fundamentals of Stored Procedures

300-Level Guide to Career Internals: Planning Your Career

500-Level Guide to Career Internals: Building a Brand

Deadlocks: Lets Do One, Understand It, and Fix It

"But It Worked in Development!" 3 Hard Performance Problems

Headaches of Blocking, Locking, and Deadlocking

Easy Performance Tuning: an Intro to Wait Statistics

Cool Story, Bro: The DBAreactions Guide to SQL Server 2014

How to Pick SQL Server Hardware

How the SQL Server Engine Thinks

Watch Brent Tune Queries

Virtualization and SAN Basics for DBAs

SQL Server Storage - 1,000GB Level

T-SQL Tuning with Colin Chapman, Enzo Ferrari, and The Stig

Using Perfmon and Profiler