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:

You can also download this video to watch it later: