Am i interpreting this correctly for PAGEIOLATCH wait type?

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » Am i interpreting this correctly for...

Am i interpreting this correctly for PAGEIOLATCH wait type?

Rate Topic

Display Mode

Topic Options

Author

Message

curious_sqldba

Posted Monday, January 28, 2013 3:28 PM

Ten Centuries

Group: General Forum Members
Last Login: 2 days ago @ 4:13 PM
Points: 1,172, Visits: 2,687

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.

Post #1412681

Evil Kraig F

Posted Tuesday, January 29, 2013 12:20 PM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 6:29 PM
Points: 5,688, Visits: 6,141

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.

- Craig Farrell

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 | Forum Netiquette
For index/tuning help, follow these directions. |Tally Tables
Twitter: @AnyWayDBA

Post #1413242

« Prev Topic | Next Topic »

Permissions