TEMPDB LDF size is increasing


I have a Instance of SQL Server 2000-SP4 in Win2003. TempDB locates in separate local drive. Having 4 Data file, each of 2.5 GB and Growth is restricted. LDF is unrestricted Growth. Two Questions... 1.I need to know why LDF is increasing, although we can't see anything in DBCC OPENTRAN.It is not possible to use SQL Profiler as this is production. 2. Can I shrinck the LDF File on line.

more ▼

asked Mar 30, 2010 at 12:43 AM in Default

avatar image

binoy 1
22 2 2 2

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

Check out the article I wrote for SSC.


I show a method which you can use to determine the cause of your log growths.

I would not shrink during production hours if you are in a heavy transaction environment with high uptime requirements. You will need to notify the business of the potential for slowness or an outage when you shrink it.

more ▼

answered Mar 30, 2010 at 02:19 AM

avatar image

5.5k 11 13 20

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Mar 30, 2010 at 12:43 AM

Seen: 1684 times

Last Updated: Mar 30, 2010 at 05:45 AM

Copyright 2018 Redgate Software. Privacy Policy