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.

No Comments - Leave a comment

Leave a comment

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>






Calendar
February 2010
M T W T F S S
« Jan   Mar »
1234567
891011121314
15161718192021
22232425262728
Content
SQLHelp

SQLHelp


Welcome , today is Sunday, April 20, 2014