SQLServerCentral Runs sp_Blitz - Reliability

  • Steve Jones - SSC Editor

    SSC Guru

    Points: 715104

  • Brent Ozar

    SSCrazy

    Points: 2351

    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: 7287

    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

    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: 2351

    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.

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

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