Examples of Using Perfmon and Profiler
by Brent Ozar
After learning how to use Perfmon and Profiler to capture statistics about your SQL Server, how do you go about troubleshooting to find out what the problem is? In this eleven minute video, Brent walks through four example problems he had, what the numbers told him, and what he recommended to management to solve the issues.
The scripts and related links for this podcast are:
- SQL Server Profiler – the wiki article here about how to use Profiler.
- Using Perfmon Counters with SQL Server – how to get started with Performance Monitor.
- Writing a Performance Report – how to use Profiler and Perfmon to write a management report for SQL Server.
- Index Performance Tuning Scripts – sample scripts that show you how to find missing indexes, indexes that aren’t being used, and more.
If you have an MP3 player or a portable video player and you want to download our videos automatically, you can subscribe to our podcast feeds here:
- MP4 (Apple) Video Feed
- WMV (Microsoft) Video Feed
- MP3 Audio-Only Feed
- Zune One-Click Subscribe for Video
- Zune One-Click Subscribe for MP3
You can also download this video to watch it later:
Tags: PerfMon, performance monitor, profiler, trace
Share this post with friends
