2007 Database Log Writes/Sec
I'm looking for a baseline for this perfmon monitor. Anyone know where to find a formula for this?
December 12th, 2011 10:58am
On Mon, 12 Dec 2011 15:52:31 +0000, The_Messenger wrote:
>I'm looking for a baseline for this perfmon monitor. Anyone know where to find a formula for this?
It depends on what volume of changes are occuring in your storage
group(s). If there's no activity at all I think there'll be one log
file "roll" every 15 minutes.
---
Rich Matheisen
MCSE+I, Exchange MVP
--- Rich Matheisen MCSE+I, Exchange MVP
Free Windows Admin Tool Kit Click here and download it now
December 12th, 2011 3:12pm
This is a perfmon monitor, I thought MS would have some information so when I looked at the results of the monitor I could get more info.
Yeah, I'm looking for a formula. Maybe experience would help. I realize there are a lot of variables, just want more info so I can set a baseline for my environment.
December 12th, 2011 3:16pm
On Mon, 12 Dec 2011 20:09:42 +0000, The_Messenger wrote:
>This is a perfmon monitor,
I know.
>I thought MS would have some information so when I looked at the results of the monitor I could get more info.
As I said, the activity depends on what changes are taking place in
your storage groups.
>Yeah, I'm looking for a formula. Maybe experience would help. I realize there are a lot of variables, just want more info so I can set a baseline for my environment.
Your baseline should be, well, based, on what measurements you take
over the course of several "normal" periods of activity. It's unlikely
that the number of log writes per second is going to greatly affect
performance unless the spindle itself is unable to keep up with the
IOPS.
---
Rich Matheisen
MCSE+I, Exchange MVP
--- Rich Matheisen MCSE+I, Exchange MVP
Free Windows Admin Tool Kit Click here and download it now
December 12th, 2011 5:05pm
yes, I realize the activity is based on the changes that are taking place in storage groups. Log writes are made for changes that are made. This is exactly why I want to monitor the activity. Writes to the logs can give a heads up on anything
going on with the database.
No need to go back and forth with this, MS does offer formulas for many perfmon monitors, I thought there might be one log writes. Just a question.
December 12th, 2011 5:25pm
On Mon, 12 Dec 2011 20:09:42 +0000, The_Messenger wrote:
>This is a perfmon monitor,
I know.
>I thought MS would have some information so when I looked at the results of the monitor I could get more info.
As I said, the activity depends on what changes are taking place in
your storage groups.
>Yeah, I'm looking for a formula. Maybe experience would help. I realize there are a lot of variables, just want more info so I can set a baseline for my environment.
Your baseline should be, well, based, on what measurements you take
over the course of several "normal" periods of activity. It's unlikely
that the number of log writes per second is going to greatly affect
performance unless the spindle itself is unable to keep up with the
IOPS.
---
Rich Matheisen
MCSE+I, Exchange MVP
--- Rich Matheisen MCSE+I, Exchange MVP
Free Windows Admin Tool Kit Click here and download it now
December 13th, 2011 12:59am
yes, I realize the activity is based on the changes that are taking place in storage groups. Log writes are made for changes that are made. This is exactly why I want to monitor the activity. Writes to the logs can give a heads up on anything
going on with the database.
No need to go back and forth with this, MS does offer formulas for many perfmon monitors, I thought there might be one log writes. Just a question.
December 13th, 2011 1:19am
Hi
If so , could I close the case. If you have any issue, please feel free let us know.
Regards!
TechNet Subscriber Support
in forum
If you have any feedback on our support, please contact
tngfb@microsoft.com
Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually
answer your question. This can be beneficial to other community members reading the thread.Gavin
TechNet Community Support
Free Windows Admin Tool Kit Click here and download it now
December 13th, 2011 4:54am
Thanks, yes this can be closed.
December 20th, 2011 11:48am