February 27, 2009 at 4:24 am
Hi,
I have a value of 690 for the performance counter "SQL Server:Databases - Log Growths". Also, the database has not grown much and the value is staying the same for over three days now.
I want to bring this value down or reset it. Can any one suggest the way to accomplish this task?
Cheers...
March 4, 2009 at 5:29 am
what are the things u tried to bring this down...?
1) shrink the file?
2) restarted the server?
3) Detach the server?
4) Offline the DB?
March 7, 2009 at 6:51 pm
1) shrink the file -- Does not reduce this value
2) restarted the server -- Resets the value to 0
3) Detach the server -- Does not change the value
4) Offline the DB -- Did not try this
Restarting/Detaching/ Taking the database offline causes a down time. I would like to know if there is a way to bring this value without causing a downtime.
Cheers...
March 9, 2009 at 8:21 am
Not as far as I know, since, according to Books Online, this counter measures the "Total number of times the transaction log for the database has been expanded". I don't understand why you'd want to reset the counter, though - if you know how the value at the beginning of a period and at the end of a period, then you can calculate how many growths have occurred during the period.
John
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply