Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQLServerCentral Runs sp_Blitz - Reliability Expand / Collapse
Author
Message
Posted Tuesday, January 15, 2013 12:01 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 6:29 PM
Points: 32,834, Visits: 14,975
Comments posted to this topic are about the item SQLServerCentral Runs sp_Blitz - Reliability






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1407048
Posted Tuesday, January 15, 2013 6:07 AM


Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Today @ 10:57 AM
Points: 66, Visits: 400
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.


Post #1407212
Posted Tuesday, January 15, 2013 6:36 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 9:58 AM
Points: 1,093, Visits: 2,605
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
Post #1407238
Posted Tuesday, January 15, 2013 6:44 AM


Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Wednesday, April 09, 2014 2:57 AM
Points: 704, Visits: 3,270
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

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
Post #1407244
Posted Tuesday, January 15, 2013 6:46 AM


Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Today @ 10:57 AM
Points: 66, Visits: 400
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.


Post #1407245
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse