Transaction log size doubled

• 2005_DBA

  Mr or Mrs. 500

  Points: 524

  More actions

  August 2, 2010 at 5:50 pm

  #236132

  Hi,

  In last couple of month I have noticed that transaction log size for one my database is almost double. I spoke with the application guys who use this database from front end says there is not any significant change in use of this database. They are still processing same amount of transaction. I am wondering what information do I need to look at to find out why this TLog is double in size. What cause it ? Where to start from ?

  Any help will greatly appreciated. Thanks in advance.

  Regards,

  2005_DBA

• Ron McCullough

  SSC Guru

  Points: 63877

  More actions

  August 2, 2010 at 7:41 pm

  #1201321

  May I suggest you read the following articles, which might assist you.

  gail Shaws article:

  http://www.sqlservercentral.com/articles/64582/

  http://www.sqlservercentral.com/articles/Transaction+Log/65877/

  Jason Brimhall,

  http://www.sqlservercentral.com/articles/Log+growth/69476/

  Hugo Shebbeare in

  http://www.sqlservercentral.com/blogs/hugo/archive/2009/1/17/it-s-minus-twenty-five-outside-and-i-m-writing-about-transaction-log-files.aspx

  http://www.sqlservercentral.com/blogs/sql_performance/archive/2010/3/10/how-to-schedule-perfmon-log-for-to-analyze-sql-counter.aspx

  Paul Randal

  http://www.sqlskills.com/BLOGS/PAUL/post/Script-open-transactions-with-text-and-plans.aspx

  http://www.sqlskills.com/BLOGS/PAUL/post/Inside-the-Storage-Engine-More-on-the-circular-nature-of-the-log.aspx

  http://www.sqlskills.com/BLOGS/PAUL/post/How-do-checkpoints-work.aspx

  http://technet.microsoft.com/en-us/magazine/2009.02.logging.aspx

  If everything seems to be going well, you have obviously overlooked something.

  Ron
  
  Please help us, help you -before posting a question please read[/url]
  Before posting a performance problem please read[/url]