01/09/2008 01:37:13,spid3s,Unknown,MEMORYCLERK_SQLSERVICEBROKERTRANSPORT (Total) <nl/> VM Reserved = 0 KB <nl/> VM Committed = 0 KB <nl/> AWE Allocated = 0 KB <nl/> SM Reserved = 0 KB <nl/> SM Committed = 0 KB <nl/> SinglePage Allocator = 48 KB <nl/> MultiPage Allocator = 0 KB
01/09/2008 01:37:13,spid3s,Unknown,MEMORYCLERK_SOSNODE (Total) <nl/> VM Reserved = 0 KB <nl/> VM Committed = 0 KB <nl/> AWE Allocated = 0 KB <nl/> SM Reserved = 0 KB <nl/> SM Committed = 0 KB <nl/> SinglePage Allocator = 46496 KB <nl/> MultiPage Allocator = 14760 KB
01/09/2008 01:37:13,spid3s,Unknown,MEMORYCLERK_HOST (Total) <nl/> VM Reserved = 0 KB <nl/> VM Committed = 0 KB <nl/> AWE Allocated = 0 KB <nl/> SM Reserved = 0 KB <nl/> SM Committed = 0 KB <nl/> SinglePage Allocator = 240 KB <nl/> MultiPage Allocator = 432 KB
01/09/2008 01:37:13,spid3s,Unknown,MEMORYCLERK_SQLQERESERVATIONS (Total) <nl/> VM Reserved = 0 KB <nl/> VM Committed = 0 KB <nl/> AWE Allocated = 0 KB <nl/> SM Reserved = 0 KB <nl/> SM Committed = 0 KB <nl/> SinglePage Allocator = 506880 KB <nl/> MultiPage Allocator = 0 KB
01/09/2008 01:37:13,spid3s,Unknown,MEMORYCLERK_BHF (Total) <nl/> VM Reserved = 0 KB <nl/> VM Committed = 0 KB <nl/> AWE Allocated = 0 KB <nl/> SM Reserved = 0 KB <nl/> SM Committed = 0 KB <nl/> SinglePage Allocator = 64 KB <nl/> MultiPage Allocator = 0 KB
01/09/2008 01:37:13,spid3s,Unknown,MEMORYCLERK_SQLXP (Total) <nl/> VM Reserved = 0 KB <nl/> VM Committed = 0 KB <nl/> AWE Allocated = 0 KB <nl/> SM Reserved = 0 KB <nl/> SM Committed = 0 KB <nl/> SinglePage Allocator = 16 KB <nl/> MultiPage Allocator = 0 KB
01/09/2008 01:37:13,spid3s,Unknown,MEMORYCLERK_FULLTEXT (Total) <nl/> VM Reserved = 0 KB <nl/> VM Committed = 0 KB <nl/> AWE Allocated = 0 KB <nl/> SM Reserved = 0 KB <nl/> SM Committed = 0 KB <nl/> SinglePage Allocator = 16 KB <nl/> MultiPage Allocator = 0 KB
01/09/2008 01:37:13,spid3s,Unknown,MEMORYCLERK_SNI (Total) <nl/> VM Reserved = 0 KB <nl/> VM Committed = 0 KB <nl/> AWE Allocated = 0 KB <nl/> SM Reserved = 0 KB <nl/> SM Committed = 0 KB <nl/> SinglePage Allocator = 80 KB <nl/> MultiPage Allocator = 16 KB
01/09/2008 01:37:13,spid3s,Unknown,MEMORYCLERK_SQLHTTP (Total) <nl/> VM Reserved = 0 KB <nl/> VM Committed = 0 KB <nl/> AWE Allocated = 0 KB <nl/> SM Reserved = 0 KB <nl/> SM Committed = 0 KB <nl/> SinglePage Allocator = 8 KB <nl/> MultiPage Allocator = 0 KB
01/09/2008 01:37:13,spid3s,Unknown,MEMORYCLERK_SQLSERVICEBROKER (Total) <nl/> VM Reserved = 0 KB <nl/> VM Committed = 0 KB <nl/> AWE Allocated = 0 KB <nl/> SM Reserved = 0 KB <nl/> SM Committed = 0 KB <nl/> SinglePage Allocator = 128 KB <nl/> MultiPage Allocator = 304 KB
01/09/2008 01:37:13,spid3s,Unknown,MEMORYCLERK_SQLCLR (Total) <nl/> VM Reserved = 0 KB <nl/> VM Committed = 0 KB <nl/> AWE Allocated = 0 KB <nl/> SM Reserved = 0 KB <nl/> SM Committed = 0 KB <nl/> SinglePage Allocator = 8 KB <nl/> MultiPage Allocator = 0 KB
01/09/2008 01:37:13,spid3s,Unknown,MEMORYCLERK_SQLCONNECTIONPOOL (Total) <nl/> VM Reserved = 0 KB <nl/> VM Committed = 0 KB <nl/> AWE Allocated = 0 KB <nl/> SM Reserved = 0 KB <nl/> SM Committed = 0 KB <nl/> SinglePage Allocator = 728 KB <nl/> MultiPage Allocator = 0 KB
01/09/2008 01:37:13,spid3s,Unknown,MEMORYCLERK_SQLSTORENG (Total) <nl/> VM Reserved = 11392 KB <nl/> VM Committed = 11392 KB <nl/> AWE Allocated = 0 KB <nl/> SM Reserved = 0 KB <nl/> SM Committed = 0 KB <nl/> SinglePage Allocator = 10864 KB <nl/> MultiPage Allocator = 1096 KB
01/09/2008 01:37:13,spid3s,Unknown,MEMORYCLERK_SQLUTILITIES (Total) <nl/> VM Reserved = 360 KB <nl/> VM Committed = 360 KB <nl/> AWE Allocated = 0 KB <nl/> SM Reserved = 0 KB <nl/> SM Committed = 0 KB <nl/> SinglePage Allocator = 296 KB <nl/> MultiPage Allocator = 0 KB
01/09/2008 01:37:13,spid3s,Unknown,MEMORYCLERK_SQLOPTIMIZER (Total) <nl/> VM Reserved = 0 KB <nl/> VM Committed = 0 KB <nl/> AWE Allocated = 0 KB <nl/> SM Reserved = 0 KB <nl/> SM Committed = 0 KB <nl/> SinglePage Allocator = 1352 KB <nl/> MultiPage Allocator = 112 KB
01/09/2008 01:37:13,spid3s,Unknown,MEMORYCLERK_SQLQUERYEXEC (Total) <nl/> VM Reserved = 0 KB <nl/> VM Committed = 0 KB <nl/> AWE Allocated = 0 KB <nl/> SM Reserved = 0 KB <nl/> SM Committed = 0 KB <nl/> SinglePage Allocator = 376 KB <nl/> MultiPage Allocator = 120 KB
01/09/2008 01:37:13,spid3s,Unknown,MEMORYCLERK_SQLBUFFERPOOL (Total) <nl/> VM Reserved = 16809984 KB <nl/> VM Committed = 16384 KB <nl/> AWE Allocated = 14820144 KB <nl/> SM Reserved = 0 KB <nl/> SM Committed = 0 KB <nl/> SinglePage Allocator = 0 KB <nl/> MultiPage Allocator = 1160 KB
01/09/2008 01:37:13,spid3s,Unknown,MEMORYCLERK_SQLGENERAL (Total) <nl/> VM Reserved = 0 KB <nl/> VM Committed = 0 KB <nl/> AWE Allocated = 0 KB <nl/> SM Reserved = 0 KB <nl/> SM Committed = 0 KB <nl/> SinglePage Allocator = 88928 KB <nl/> MultiPage Allocator = 4800 KB
01/09/2008 01:37:13,spid3s,Unknown,Memory node Id = 0 <nl/> VM Reserved = 16971688 KB <nl/> VM Committed = 177168 KB <nl/> AWE Allocated = 14820144 KB <nl/> SinglePage Allocator = 3479368 KB <nl/> MultiPage Allocator = 47536 KB
01/09/2008 01:37:13,spid3s,Unknown,Memory Manager <nl/> VM Reserved = 16977448 KB <nl/> VM Committed = 182840 KB <nl/> AWE Allocated = 14820144 KB <nl/> Reserved Memory = 1024 KB <nl/> Reserved Memory In Use = 0 KB
01/09/2008 01:37:13,spid3s,Unknown,LazyWriter: warning <c/> no free buffers found.
01/09/2008 01:36:13,spid3s,Unknown,SQL Server has encountered 1 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [D:\NKS_DB\DB_TEAM\BAS\NK_BAS_Data.NDF] in database [TEAM] (14). The OS file handle is 0x0000000000000AF0. The offset of the latest long I/O is: 0x000001bf25c000
01/09/2008 01:23:33,Backup,Unknown,BACKUP LOG WITH TRUNCATE_ONLY or WITH NO_LOG is deprecated. The simple recovery model should be used to automatically truncate the transaction log.
01/09/2008 00:00:07,spid14s,Unknown,This instance of SQL Server has been using a process ID of 2408 since 2008-1-5 11:29:29 (local) 2008-1-5 3:29:29 (UTC). This is an informational message only; no user action is required.
01/09/2008 01:37:13,spid3s,Unknown,OBJECTSTORE_LBSS (Total) <nl/> VM Reserved = 0 KB <nl/> VM Committed = 0 KB <nl/> AWE Allocated = 0 KB <nl/> SM Reserved = 0 KB <nl/> SM Committed = 0 KB <nl/> SinglePage Allocator = 136 KB <nl/> MultiPage Allocator = 1312 KB
01/09/2008 01:37:13,spid3s,Unknown,USERSTORE_SXC (Total) <nl/> VM Reserved = 0 KB <nl/> VM Committed = 0 KB <nl/> AWE Allocated = 0 KB <nl/> SM Reserved = 0 KB <nl/> SM Committed = 0 KB <nl/> SinglePage Allocator = 32 KB <nl/> MultiPage Allocator = 0 KB
01/09/2008 01:37:13,spid3s,Unknown,USERSTORE_OBJPERM (Total) <nl/> VM Reserved = 0 KB <nl/> VM Committed = 0 KB <nl/> AWE Allocated = 0 KB <nl/> SM Reserved = 0 KB <nl/> SM Committed = 0 KB <nl/> SinglePage Allocator = 464 KB <nl/> MultiPage Allocator = 0 KB
01/09/2008 01:37:13,spid3s,Unknown,USERSTORE_TOKENPERM (Total) <nl/> VM Reserved = 0 KB <nl/> VM Committed = 0 KB <nl/> AWE Allocated = 0 KB <nl/> SM Reserved = 0 KB <nl/> SM Committed = 0 KB <nl/> SinglePage Allocator = 2224 KB <nl/> MultiPage Allocator = 0 KB
01/09/2008 01:37:13,spid3s,Unknown,USERSTORE_DBMETADATA (Total) <nl/> VM Reserved = 0 KB <nl/> VM Committed = 0 KB <nl/> AWE Allocated = 0 KB <nl/> SM Reserved = 0 KB <nl/> SM Committed = 0 KB <nl/> SinglePage Allocator = 7528 KB <nl/> MultiPage Allocator = 0 KB
01/09/2008 01:37:13,spid3s,Unknown,USERSTORE_SCHEMAMGR (Total) <nl/> VM Reserved = 0 KB <nl/> VM Committed = 0 KB <nl/> AWE Allocated = 0 KB <nl/> SM Reserved = 0 KB <nl/> SM Committed = 0 KB <nl/> SinglePage Allocator = 6376 KB <nl/> MultiPage Allocator = 240 KB
01/09/2008 01:37:13,spid3s,Unknown,CACHESTORE_SYSTEMROWSET (Total) <nl/> VM Reserved = 0 KB <nl/> VM Committed = 0 KB <nl/> AWE Allocated = 0 KB <nl/> SM Reserved = 0 KB <nl/> SM Committed = 0 KB <nl/> SinglePage Allocator = 3536 KB <nl/> MultiPage Allocator = 0 KB
01/09/2008 01:37:13,spid3s,Unknown,CACHESTORE_EVENTS (Total) <nl/> VM Reserved = 0 KB <nl/> VM Committed = 0 KB <nl/> AWE Allocated = 0 KB <nl/> SM Reserved = 0 KB <nl/> SM Committed = 0 KB <nl/> SinglePage Allocator = 16 KB <nl/> MultiPage Allocator = 0 KB
01/09/2008 01:37:13,spid3s,Unknown,CACHESTORE_BROKERTO (Total) <nl/> VM Reserved = 0 KB <nl/> VM Committed = 0 KB <nl/> AWE Allocated = 0 KB <nl/> SM Reserved = 0 KB <nl/> SM Committed = 0 KB <nl/> SinglePage Allocator = 8 KB <nl/> MultiPage Allocator = 0 KB
01/09/2008 01:37:13,spid3s,Unknown,CACHESTORE_BROKERREADONLY (Total) <nl/> VM Reserved = 0 KB <nl/> VM Committed = 0 KB <nl/> AWE Allocated = 0 KB <nl/> SM Reserved = 0 KB <nl/> SM Committed = 0 KB <nl/> SinglePage Allocator = 56 KB <nl/> MultiPage Allocator = 0 KB
01/09/2008 01:37:13,spid3s,Unknown,CACHESTORE_BROKERRSB (Total) <nl/> VM Reserved = 0 KB <nl/> VM Committed = 0 KB <nl/> AWE Allocated = 0 KB <nl/> SM Reserved = 0 KB <nl/> SM Committed = 0 KB <nl/> SinglePage Allocator = 8 KB <nl/> MultiPage Allocator = 0 KB
01/09/2008 01:37:13,spid3s,Unknown,CACHESTORE_BROKERUSERCERTLOOKUP (Total) <nl/> VM Reserved = 0 KB <nl/> VM Committed = 0 KB <nl/> AWE Allocated = 0 KB <nl/> SM Reserved = 0 KB <nl/> SM Committed = 0 KB <nl/> SinglePage Allocator = 8 KB <nl/> MultiPage Allocator = 0 KB
01/09/2008 01:37:13,spid3s,Unknown,CACHESTORE_BROKERDSH (Total) <nl/> VM Reserved = 0 KB <nl/> VM Committed = 0 KB <nl/> AWE Allocated = 0 KB <nl/> SM Reserved = 0 KB <nl/> SM Committed = 0 KB <nl/> SinglePage Allocator = 8 KB <nl/> MultiPage Allocator = 0 KB
01/09/2008 01:37:13,spid3s,Unknown,CACHESTORE_BROKERKEK (Total) <nl/> VM Reserved = 0 KB <nl/> VM Committed = 0 KB <nl/> AWE Allocated = 0 KB <nl/> SM Reserved = 0 KB <nl/> SM Committed = 0 KB <nl/> SinglePage Allocator = 8 KB <nl/> MultiPage Allocator = 0 KB
01/09/2008 01:37:13,spid3s,Unknown,CACHESTORE_BROKERTBLACS (Total) <nl/> VM Reserved = 0 KB <nl/> VM Committed = 0 KB <nl/> AWE Allocated = 0 KB <nl/> SM Reserved = 0 KB <nl/> SM Committed = 0 KB <nl/> SinglePage Allocator = 176 KB <nl/> MultiPage Allocator = 0 KB
01/09/2008 01:37:13,spid3s,Unknown,CACHESTORE_STACKFRAMES (Total) <nl/> VM Reserved = 0 KB <nl/> VM Committed = 0 KB <nl/> AWE Allocated = 0 KB <nl/> SM Reserved = 0 KB <nl/> SM Committed = 0 KB <nl/> SinglePage Allocator = 0 KB <nl/> MultiPage Allocator = 8 KB
01/09/2008 01:37:13,spid3s,Unknown,CACHESTORE_XMLDBATTRIBUTE (Total) <nl/> VM Reserved = 0 KB <nl/> VM Committed = 0 KB <nl/> AWE Allocated = 0 KB <nl/> SM Reserved = 0 KB <nl/> SM Committed = 0 KB <nl/> SinglePage Allocator = 8 KB <nl/> MultiPage Allocator = 0 KB
01/09/2008 01:37:13,spid3s,Unknown,CACHESTORE_XMLDBELEMENT (Total) <nl/> VM Reserved = 0 KB <nl/> VM Committed = 0 KB <nl/> AWE Allocated = 0 KB <nl/> SM Reserved = 0 KB <nl/> SM Committed = 0 KB <nl/> SinglePage Allocator = 8 KB <nl/> MultiPage Allocator = 0 KB
01/09/2008 01:37:13,spid3s,Unknown,CACHESTORE_XMLDBTYPE (Total) <nl/> VM Reserved = 0 KB <nl/> VM Committed = 0 KB <nl/> AWE Allocated = 0 KB <nl/> SM Reserved = 0 KB <nl/> SM Committed = 0 KB <nl/> SinglePage Allocator = 8 KB <nl/> MultiPage Allocator = 0 KB
01/09/2008 01:37:13,spid3s,Unknown,CACHESTORE_VIEWDEFINITIONS (Total) <nl/> VM Reserved = 0 KB <nl/> VM Committed = 0 KB <nl/> AWE Allocated = 0 KB <nl/> SM Reserved = 0 KB <nl/> SM Committed = 0 KB <nl/> SinglePage Allocator = 48 KB <nl/> MultiPage Allocator = 0 KB
01/09/2008 01:37:13,spid3s,Unknown,CACHESTORE_NOTIF (Total) <nl/> VM Reserved = 0 KB <nl/> VM Committed = 0 KB <nl/> AWE Allocated = 0 KB <nl/> SM Reserved = 0 KB <nl/> SM Committed = 0 KB <nl/> SinglePage Allocator = 16 KB <nl/> MultiPage Allocator = 0 KB
01/09/2008 01:37:13,spid3s,Unknown,CACHESTORE_TEMPTABLES (Total) <nl/> VM Reserved = 0 KB <nl/> VM Committed = 0 KB <nl/> AWE Allocated = 0 KB <nl/> SM Reserved = 0 KB <nl/> SM Committed = 0 KB <nl/> SinglePage Allocator = 40 KB <nl/> MultiPage Allocator = 0 KB
01/09/2008 01:37:13,spid3s,Unknown,CACHESTORE_XPROC (Total) <nl/> VM Reserved = 0 KB <nl/> VM Committed = 0 KB <nl/> AWE Allocated = 0 KB <nl/> SM Reserved = 0 KB <nl/> SM Committed = 0 KB <nl/> SinglePage Allocator = 144 KB <nl/> MultiPage Allocator = 0 KB
01/09/2008 01:37:13,spid3s,Unknown,CACHESTORE_PHDR (Total) <nl/> VM Reserved = 0 KB <nl/> VM Committed = 0 KB <nl/> AWE Allocated = 0 KB <nl/> SM Reserved = 0 KB <nl/> SM Committed = 0 KB <nl/> SinglePage Allocator = 23024 KB <nl/> MultiPage Allocator = 16 KB
01/09/2008 01:37:13,spid3s,Unknown,CACHESTORE_SQLCP (Total) <nl/> VM Reserved = 0 KB <nl/> VM Committed = 0 KB <nl/> AWE Allocated = 0 KB <nl/> SM Reserved = 0 KB <nl/> SM Committed = 0 KB <nl/> SinglePage Allocator = 3150232 KB <nl/> MultiPage Allocator = 21384 KB
01/09/2008 01:37:13,spid3s,Unknown,CACHESTORE_OBJCP (Total) <nl/> VM Reserved = 0 KB <nl/> VM Committed = 0 KB <nl/> AWE Allocated = 0 KB <nl/> SM Reserved = 0 KB <nl/> SM Committed = 0 KB <nl/> SinglePage Allocator = 137984 KB <nl/> MultiPage Allocator = 1544 KB
01/09/2008 01:39:13,spid3s,Unknown,LazyWriter: warning <c/> no free buffers found.
01/09/2008 01:37:13,spid3s,Unknown,MEMORYBROKER_FOR_RESERVE <nl/> Allocations = 63360 <nl/> Rate = 0 <nl/> Target Allocations = 1296921 <nl/> Future Allocations = 339276 <nl/> Last Notification = GROW
01/09/2008 01:37:13,spid3s,Unknown,MEMORYBROKER_FOR_STEAL <nl/> Allocations = 17900 <nl/> Rate = 0 <nl/> Target Allocations = 975545 <nl/> Future Allocations = 0 <nl/> Last Notification = GROW
01/09/2008 01:37:13,spid3s,Unknown,MEMORYBROKER_FOR_CACHE <nl/> Allocations = 417021 <nl/> Rate = 0 <nl/> Target Allocations = 1374666 <nl/> Future Allocations = 0 <nl/> Last Notification = GROW
01/09/2008 01:37:13,spid3s,Unknown,Big Gateway <nl/> Configured Units = 1 Available Units = 1 Acquires = 0 <nl/> Waiters = 0 Threshold Factor = 8 Threshold = -1
01/09/2008 01:37:13,spid3s,Unknown,Medium Gateway <nl/> Configured Units = 8 Available Units = 8 Acquires = 0 <nl/> Waiters = 0 Threshold Factor = 12 Threshold = -1
01/09/2008 01:37:13,spid3s,Unknown,Small Gateway <nl/> Configured Units = 32 Available Units = 32 Acquires = 0 <nl/> Waiters = 0 Threshold Factor = 380000 Threshold = 380000
01/09/2008 01:37:13,spid3s,Unknown,Optimization Queue <nl/> Overall Memory = 11970478080 Target Memory = 7991664640 Last Notification = GROW Timeout = 6 Early Termination Factor = 5
01/09/2008 01:37:13,spid3s,Unknown,Small Query Memory Objects: Grants=0 Waiting=0 Maximum=12800 Available=12800 Limit=12800
01/09/2008 01:37:13,spid3s,Unknown,Query Memory Objects: Next Request=0 Waiting For=0 Cost=0 Timeout=0 Wait Time=0 Last Target=1215855
01/09/2008 01:37:13,spid3s,Unknown,Query Memory Objects: Grants=2 Waiting=0 Maximum=1203220 Available=1139860 Limit=1203055
01/09/2008 01:37:13,spid3s,Unknown,Global Memory Objects: <nl/> Resource= 358 <nl/> Locks= 3556 <nl/> SE Schema Mgr= 826 <nl/> SQLCache= 10761 <nl/> Replication= 2 <nl/> ServerGlobal= 48 <nl/> XPGlobal= 2 <nl/> Xact= 87 <nl/> SETLS= 8 <nl/> DatasetMemObjs= 16 <nl/> SubpDescPmos= 9 <nl/> SortTables= 35
01/09/2008 01:37:13,spid3s,Unknown,Process physical/virtual memory pressure: 0/0 System physical memory pressure: 0
01/09/2008 01:37:13,spid3s,Unknown,Procedure Cache: TotalProcs=123907 TotalPages=416791 InUsePages=10651
01/09/2008 01:37:13,spid3s,Unknown,Buffer Counts: Committed=1823120 Target=1822992 Hashed=1378193 <nl/> Internal Reservation=364598 External Reservation=53535 <nl/> Stolen Potential=1325538 <nl/> Min Free=800 Visible=1822992 <nl/> Available Paging File=16473894912
01/09/2008 01:37:13,spid3s,Unknown,Buffer Distribution: Stolen=27910 Free=0 Cached=417017 <nl/> Database (clean)=1112790 Database (dirty)=265338 <nl/> I/O=62 <c/> Latched=3
01/09/2008 01:37:13,spid3s,Unknown,OBJECTSTORE_LOCK_MANAGER (Total) <nl/> VM Reserved = 65536 KB <nl/> VM Committed = 65536 KB <nl/> AWE Allocated = 0 KB <nl/> SM Reserved = 0 KB <nl/> SM Committed = 0 KB <nl/> SinglePage Allocator = 28424 KB <nl/> MultiPage Allocator = 0 KB
01/09/2008 01:37:13,spid3s,Unknown,OBJECTSTORE_SERVICE_BROKER (Total) <nl/> VM Reserved = 0 KB <nl/> VM Committed = 0 KB <nl/> AWE Allocated = 0 KB <nl/> SM Reserved = 0 KB <nl/> SM Committed = 0 KB <nl/> SinglePage Allocator = 272 KB <nl/> MultiPage Allocator = 0 KB
01/09/2008 01:37:13,spid3s,Unknown,OBJECTSTORE_SNI_PACKET (Total) <nl/> VM Reserved = 0 KB <nl/> VM Committed = 0 KB <nl/> AWE Allocated = 0 KB <nl/> SM Reserved = 0 KB <nl/> SM Committed = 0 KB <nl/> SinglePage Allocator = 1608 KB <nl/> MultiPage Allocator = 48 KB
今天JOB运行正常，
但该SERVER总是存在：
01/08/2008 19:25:48,spid3s,Unknown,SQL Server has encountered 43 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [G:\RiskH2000DB\MFT\data\ro_mft_d_00_00.ndf] in database [RiskH2000] (5). The OS file handle is 0x0000000000000C88. The offset of the latest long I/O is: 0x000000044b4000
01/08/2008 18:31:45,spid3s,Unknown,SQL Server has encountered 240 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [E:\temp\tempdata_1.ndf] in database [tempdb] (2). The OS file handle is 0x000000000000085C. The offset of the latest long I/O is: 0x000004128e0000
01/08/2008 18:30:27,Server,Unknown,Process 66:0:6 (0x1b4c) Worker 0x00000000918541C0 appears to be non-yielding on Scheduler 0. Thread creation time: 12844240404424. Approx Thread CPU Used: kernel 0 ms <c/> user 0 ms. Process Utilization 43%. System Idle 43%. Interval: 75030 ms.
昨天早上从网上看到的一个案例。大家都可以分析下。这种案例毕竟不是人人都能遇到的。
我也没有准确的答案，大家讨论下。
