How come I've missed this? I don't know, but I'm writing this blog post so to bookmark this site. You'll find a handful of scripts, mainly using Dynamic Management Views and Functions, to monitor various aspects of SQL Server. http://www.microsoft.com/technet/scriptcenter/scripts/sql/sql2005/default.mspx?mfr=true
Read More...