Auditing a new server is always fun, sometimes chaotic depending on your discipline and experience. We all know Brent Ozar, (if you dont, and you are a DBA…you really need to start reading online…because hes pro), Brent has been godly 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.