Viewing 3 posts - 1 through 4 (of 4 total)
Thank you Grant .
(I saw you present at SQL in the City - London actually!)
Using Glenn Berry's query i can confirm it's all pointing back at I/O >
wait_type ...
November 29, 2012 at 7:16 am
data and tempdb are on S:
log are on L:
I ran -
select wait_duration_ms , wait_type, blocking_session_id from sys.dm_os_waiting_tasks order by 1 desc
2512536962ONDEMAND_TASK_QUEUENULL
2512536575BROKER_TRANSMITTERNULL
2512536575BROKER_TRANSMITTERNULL
2512530889KSOURCE_WAKEUPNULL
2512530880BROKER_EVENTHANDLERNULL
26978702XE_DISPATCHER_WAITNULL
906459CHECKPOINT_QUEUENULL
34778DISPATCHER_QUEUE_SEMAPHORENULL
8612XE_TIMER_EVENTNULL
4828REQUEST_FOR_DEADLOCK_SEARCHNULL
3910SQLTRACE_INCREMENTAL_FLUSH_SLEEPNULL
996BROKER_TO_FLUSHNULL
462LAZYWRITER_SLEEPNULL
211LOGMGR_QUEUENULL
thanks
s
November 29, 2012 at 3:16 am
Thank you Jason
So if I presize database MDF file this should not happen?
I did advise presizing data files a while ago but the message got lost somewhere.
Big thank you
I will...
June 17, 2011 at 9:18 am
Viewing 3 posts - 1 through 4 (of 4 total)