Home Forums SQL Server 2008 SQL Server 2008 - General What does Logging mean in the Resource Waits section of Activity Monitor in Sql Server 2008? RE: What does Logging mean in the Resource Waits section of Activity Monitor in Sql Server 2008?

  • Thanks for the pointer to BOL.

    I have ran the query and the worst offending seem to be the following

    NAME Wait CountWait Time MSMax Wait Time MSSignal WaitTime

    LAZYWRITER_SLEEP 392136382873704187632982

    REQUEST_FOR_DEADLOCK_SEARCH765713828719645001382871964

    XE_TIMER_EVENT 1276438287109930001382869148

    XE_DISPATCHER_WAIT 872382811081272706510

    LOGMGR_QUEUE 858754438252896614396500086

    SQLTRACE_BUFFER_FLUSH 9533038135609949033124

    FT_IFTS_SCHEDULER_IDLE_WAIT632937968365360388297

    CHECKPOINT_QUEUE 58583632929512132168600

    WRITELOG 85613792020721745678645332

    SLEEP_TASK 4508822193493788358126874

    BROKER_TO_FLUSH 186919 19143219218898667

    ASYNC_NETWORK_IO 7850808203245215400120107

    PAGEIOLATCH_SH 103881123072621500326797

    This was ordered by total wait time. But call me a numpty, I have read the BOL description for most of the above and it means nothing to me.

    If you saw these figures apart from being appalled what would you then go and look at? We have a SCSI raid drive as we are on a hosted server using the web edition of SQL.

    Many thanks. Graeme.