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.