SQL Server Perfmon Monitoring: Why?
If you’re going into Windows Task Manager when your SQL Server slows down, that’s like waiting until the Check Engine light on your car dashboard lights up. Sure, it tells you when there’s a problem – but at that point, it’s too late.
In this five minute video, Brent Ozar explains why DBAs should use Performance Monitor, a free tool that ships with Windows, to diagnose and trend performance issues before they become showstoppers.
For more information, check out the SQL Server Performance Monitor topic in the wiki.
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: