May 20, 2011 at 11:50 am
I have a lot of servers that are showing high values for 'Average Wait Time (ms)'. We have very low settings for autogrow and I believe that these waits may be caused by the autogrowth of the datafiles. I'd like to correlate this to the autogrows to test my theory.
Does anyone know what wait category is accumulated when datafiles are growing (and hence causing a query to wait)?
May 20, 2011 at 12:09 pm
PAGELATCH_IO usually. Database growth is a disk wait, but it doesn't trigger it directly, other things would.
You would be better off doing a system review with perfmon counters to locate the actual bottleneck, and doing a fragmentation/statistics check first. Autogrow can eat time but you'd have to have some pretty significant hits for it to be a continuous problem.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
May 20, 2011 at 12:37 pm
I'm not seeing any documentation on PAGELATCH_IO - did you mean PAGEIOLATCH_% ?
May 20, 2011 at 1:00 pm
matthew.gantz (5/20/2011)
I'm not seeing any documentation on PAGELATCH_IO - did you mean PAGEIOLATCH_% ?
No, sorry, crossed my wires. I meant PAGEIOLATCH, sorry. Been one of those mornings... finds more coffee...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply