SQLServerCentral Runs sp_Blitz - Reliability

Question

SQLServerCentral Runs sp_Blitz - Reliability

Steve Jones - SSC Editor

SSC Guru

Points: 736173
More actions
January 15, 2013 at 12:01 am

#74337

Comments posted to this topic are about the item SQLServerCentral Runs sp_Blitz - Reliability

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Brent Ozar SSCrazy Points: 2451 More actions · Answer 1

The log-bigger-than-database check is one of my favorite recent additions. I can't believe how often it comes up, and it's something I never would have thought to check for manually. It's so easy to fix, too.

Richard M. SSCertifiable Points: 7401 More actions · Answer 2

Brent Ozar (1/15/2013)
The log-bigger-than-database check is one of my favorite recent additions. I can't believe how often it comes up, and it's something I never would have thought to check for manually. It's so easy to fix, too.

You're right there. I've seen this many times, more in system that are set up, but the maintenance plans are never put in place becausse the associated application is not setup/installed right away. When the system actually goes into production (and the DBA's are not notified of this), no t-log backups can have quite an impact in t-logs eating up disk space.....

_______________________________________________________________________
For better assistance in answering your questions, click here[/url]

Abu Dina SSChampion Points: 14155 More actions · Answer 3

As if the other 167 lines returned by sp_blitz wasn't enough!

I also found this.. tut tut tut tut tut

LOL......

---------------------------------------------------------

It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
David Edwards - Media lens[/url]

Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
Howard Zinn

Brent Ozar SSCrazy Points: 2451 More actions · Answer 4

Hahaha, yeah, that's fixed in the upcoming v17. The funny part is that sp_Blitz doesn't actually use WITH RECOMPILE, but the check looks for the words, and the words are in the check itself, hahaha.