Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


How to reset performance counter SQL Server:Databases - Log growths


How to reset performance counter SQL Server:Databases - Log growths

Author
Message
Mohammed Imran Ali
Mohammed Imran Ali
Valued Member
Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)

Group: General Forum Members
Points: 73 Visits: 258
Hi,

I have a value of 690 for the performance counter "SQL ServerBigGrinatabases - 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...
vinurajr
vinurajr
SSCommitted
SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)

Group: General Forum Members
Points: 1798 Visits: 208
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?
Mohammed Imran Ali
Mohammed Imran Ali
Valued Member
Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)

Group: General Forum Members
Points: 73 Visits: 258
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...
John Mitchell-245523
John Mitchell-245523
SSCertifiable
SSCertifiable (7.5K reputation)SSCertifiable (7.5K reputation)SSCertifiable (7.5K reputation)SSCertifiable (7.5K reputation)SSCertifiable (7.5K reputation)SSCertifiable (7.5K reputation)SSCertifiable (7.5K reputation)SSCertifiable (7.5K reputation)

Group: General Forum Members
Points: 7502 Visits: 15159
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
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search