January 28, 2013 at 3:28 pm
I am using below query to find total wait time for wait type 'PAGEIOLATCH_SH' . There is nothing else running on this server except a process which i suspect is spending most time on 'PAGEIOLATCH_SH' type.
select *,((wait_time_ms)/1000)/60 AS Total_Wait_Mins ,(wait_time_ms)/(waiting_tasks_count) As Avg_WaitTime_InMs
from sys.dm_os_wait_stats
where wait_type ='PAGEIOLATCH_SH'
Lets say so far its been 10 mins since my test query is running and in the TotalWaittime column if it shows as 5 mins, does it mean my query spent 5 mins just on this wait type?
P.S: I did clear the stats before collecting the data.
January 29, 2013 at 12:20 pm
Pretty much, but you're not dealing with a server problem with PAGEIOLATCH. That's a Disk I/O wait type. Your Drive I/O is just huge and you're waiting until you can get stuff to memory to use it.
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