Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to reset performance counter SQL Server:Databases - Log growths Expand / Collapse
Author
Message
Posted Friday, February 27, 2009 4:24 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Sunday, November 16, 2014 8:25 PM
Points: 72, Visits: 252
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...
Post #665595
Posted Wednesday, March 4, 2009 5:29 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Tuesday, August 19, 2014 3:18 AM
Points: 1,798, Visits: 194
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?
Post #668046
Posted Saturday, March 7, 2009 6:51 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Sunday, November 16, 2014 8:25 PM
Points: 72, Visits: 252
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...
Post #671038
Posted Monday, March 9, 2009 8:21 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Friday, October 31, 2014 11:06 AM
Points: 5,430, Visits: 10,108
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
Post #671537
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse