Log is Filling Up

Categories: News, Professional
Comments: No Comments
Published on: February 4, 2010

Today I ran across Paul Randal’s latest post showing how to find open transactions and such.  This is a nice little script and would prove very useful in certain circumstances.  An obvious circumstance would in trying to find what is causing the transaction log to fill or even grow.  Paul posted his article on Feb 1.  An interesting coincidence for me is that I submitted an article for review that very day.  In the article I discussed a couple of methods to help determine the cause of log growth.  My script is more simplistic than Paul’s – and has been adapted for a couple of different purposes.  This script could also be easily adapted to fit other purposes.

As an extension to the article (if it gets published), is a blog about using Event Notifications for the very same purpose (finding the cause of log growth).

Anyway, I justed wanted to pass along that Paul has posted a great script.  Go check it out.

page 1 of 1








Calendar
August 2017
M T W T F S S
« Jun    
 123456
78910111213
14151617181920
21222324252627
28293031  
Content
SQLHelp

SQLHelp


Welcome , today is Thursday, August 24, 2017