Thursday, December 29, 2011

SQL Server fast health check script

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.

No comments:

Post a Comment