Forum Replies Created

Viewing 3 posts - 1 through 4 (of 4 total)

  • RE: Virtualised SQL 2008 Performance Problem

    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 ...

  • RE: Virtualised SQL 2008 Performance Problem

    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

  • RE: Index Creation and Log files

    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...

Viewing 3 posts - 1 through 4 (of 4 total)