If youre going into Windows Task Manager when your SQL Server slows down, thats like waiting until the Check Engine light on your car dashboard lights up. Sure, it tells you when theres a problem - but at that point, its 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:
http://sqlserverpedia.com/wiki/Performance_Monitor
You can also view this video in higher quality and in all your favorite mobile formats here:
http://sqlserverpedia.com/blog/sql-server-performance-tuning/sql-server-perfm...
awesome!!!
cncp1980 1 month ago
Awesome intro to perf mon. Thanks for posting.
maverickreviews 1 year ago
Nice!
Smartdba 3 years ago