Why make something, if there is already something very good made by someone else.
The is useful when you need to do a
fast health check.
What does Brent Ozar says about his script:
We need to put on our latex gloves, do a little poking
around, and discover the dirty secrets before they catch us by surprise. That’s
where our sp_Blitz script comes in.
sp_Blitz helps you rapidly assess configuration, security, health, and
performance issues. We organize the results in a prioritized list and give you
simple explanations of each risk. The
results will include details about your server plus a column of links that you
can copy/paste into your browser for more information about each issue
Look for his script here: sp_Blitz
Please take a look at this fabulous script.