January 29, 2013 at 4:07 pm
I am performing update statistics with fullscan on a huge table ( about 200gb). In the wait types i see that the spid wait type is PAGEIOLATCH_SH. I have been running this for every 10 secs and i see see this wait type. I have another job running in parallel which is also updating the statistics on the same server. Could it be bad IO system?
January 29, 2013 at 4:21 pm
Um, lot of factors. I wouldn't say the I/O subsystem is bad. All the wait means is that it's waiting for the drive to send it data. If you're updating with fullscan, you're scanning every inch of the table. So, yeah, that's normal.
I wouldn't worry about it in this case unless you're seeing other issues outside of this. Fullscans just take a while.
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 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply