I have a few additional that I do, in no particular order. While I agree with all you've posted and how critical they are intiailly, I believe some metrics of the physical server are equally important. I started a new job recently and have been real anal with collecting all of the below, after ensuring I had completed your top ten list
. If SQL server is my responsibility, I either will get the info myself (if I have access to the physical server? or will push those who can to get it for me (Network Admin, etc.)!
1) Sufficient free disk space on the server for future growth
2) Memory and it's allocation
3) Disk arrays, speed, number of physical drives, what's where with respect to the databases (is tempdb on it's own disks)? How about log and data files?
4) Number of CPUs and their speed
5) OS and service pack level?
6) What else is running on MY SQL server? Why?
7) Is /AWE or /3GB in the boot.ini file? If so, why?
8) Obtain growth metrics over time so I can forecast potential growth (see #1)
This is not a complete list either. I just wanted to put my 2 cents in before the weekend begins! Thanks for listening.
