If you have been given a SQL server and have no idea as to how it is configured, the script below (by Brent Ozar) will help.
This is a great way to find out alot of information in once quick step. Brent even provides information on why and how to correct issues that were found.
Be sure you visit his site and search for an updated version. Great job Brent and Friends!!
The version I have here is version 17 of the sp_Blitz v17.sql
Download script here: https://docs.google.com/file/d/0B07PMQYOhF2DYUFZdDlDTXlnV0E/edit?usp=sharing
About Me - Who is DR DBA?
- Who am I?
- Hello. My name is Rudy Panigas and I am a Production Senior Microsoft SQL Server Database Administrator (DBA) with over 14 years of experience. Have published articles with SQL Central, am a leader for the my local PASS chapter in Toronto (TORPASS) and love to automate anything SQL including disaster recovery. I created this blog to share my views, knowledge and to discuss Microsoft SQL server in order to help out others in this field. Please test these scripts before using. I do not warranty and do not take any responsibility for it, its misuse or output it creates. You can reach me at this email address: firstname.lastname@example.org