July 4, 2011 at 6:17 am
Hi folks,
Wait stats name and count for a server that has been up 5 days are below.
I read that OLEDB can be nothing to worry about as it includes DBCC checks etc, but it still seems pretty high.
Can anyone provide anything else they would investigate, given the figures below?
thanks
Task waiting tasks count
OLEDB228727843
SLEEP_TASK8419523
ASYNC_NETWORK_IO4694990
BACKUPIO4200633
SOS_SCHEDULER_YIELD3726435
PAGEIOLATCH_SH1484436
BACKUPBUFFER1126449
WRITELOG922888
LAZYWRITER_SLEEP337275
PAGEIOLATCH_EX280870
IO_COMPLETION193497
PAGELATCH_EX94377
SQLTRACE_BUFFER_FLUSH80368
SLEEP_BPOOL_FLUSH55467
BACKUPTHREAD35066
PAGELATCH_SH6885
CMEMTHREAD6276
PAGEIOLATCH_UP5836
MSQL_XP3788
RESOURCE_SEMAPHORE_MUTEX401
THREADPOOL396
LOGBUFFER379
SOS_RESERVEDMEMBLOCKLIST190
ASYNC_IO_COMPLETION169
LCK_M_SCH_M101
July 5, 2011 at 10:23 am
Do you use a lot of Linked Servers?
Found this too:
http://www.sqlservercentral.com/Forums/Topic336973-146-1.aspx
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply