THE COLUMNS ARE

TYPE WAIT TIME S PCT RUNNING PCT

DO THESE STATS INDICATE ANYTHING?

CXPACKET 3344303.7276.4476.44

PAGEIOLATCH_SH 407470.349.3185.76

LCK_M_SCH_M 173911.163.9889.73

ASYNC_NETWORK_IO 118890.632.7292.45

BROKER_TASK_STOP 93700.662.1494.59

LCK_M_S91672.272.10 96.69 ...

oops i was using exec sys.dm_os_wait_stats

instead of SELECT * FROM sys.dm_os_wait_stats

help appreciated anyhows ssc!

no indexing done on a nightly basis, and its all queries that can get slow regardless of age

how do i gateher statistics with sys.dm_os_wait_stats?

wait statistics for disks and processor just

physical disks range from 0-160, and processor really no waits at all