Auditing a new server is always fun, sometimes chaotic depending on your discipline and experience. We all know Brent Ozar, (if you don’t, and you are a DBA…you really need to start reading online…because he’s pro), Brent has been kind enough to post his BLITZ! script which makes auditing SQL Servers…fun, painless and almost relaxing.
As with any script…dont copy and paste and run…unless you are completely secure with your job. I use all of the queries in his script, not in sucession obviously but this is a most excellent way to get a grip on any server.
Brent…I wish I was going to PASS so that I could buy you a beer.