Hi All,
Thanks for the replies.
Below is the detail of the dump log file you asked for
•2007-12-23 10:37:13.02 spid2s SQL Server has encountered 1 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [H:\Production\CompanyProfile\CompanyProfile_200712.ndf] in database [CompanyProfile] (12). The OS file handle is 0x000008B8. The offset of the latest long I/O is: 0x000025fe4e2000
•2007-12-23 10:37:13.02 spid2s SQL Server has encountered 1 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [H:\Production\CompanyProfile\FusionReference.ndf] in database [CompanyProfile] (12). The OS file handle is 0x00000894. The offset of the latest long I/O is: 0x00000040b1c000
•2007-12-23 10:37:13.02 spid2s SQL Server has encountered 1 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [H:\Production\CompanyProfile\Fusion.ndf] in database [CompanyProfile] (12). The OS file handle is 0x00000890. The offset of the latest long I/O is: 0x00000039eac000
•2007-12-23 10:37:13.02 spid2s SQL Server has encountered 1 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [H:\Production\CompanyProfile\FusionMain.mdf] in database [CompanyProfile] (12). The OS file handle is 0x00000864. The offset of the latest long I/O is: 0x00000006526000
•2007-12-23 10:37:23.02 spid2s SQL Server has encountered 1 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [D:\MSSQL\MSDBLog.ldf] in database [msdb] (4). The OS file handle is 0x00000880. The offset of the latest long I/O is: 0x00000000979000
•2007-12-23 10:38:39.90 Server Using 'dbghelp.dll' version '4.0.5'
•2007-12-23 10:41:48.71 spid87 A time-out occurred while waiting for buffer latch -- type 2, bp 051A6AB8, page 10:19922697, stat 0x7c0040d, database id: 12, allocation unit Id: 484272212956179/202795456246057, task 0x00C143E8 : 7, waittime 300, flags 0x1a, owning task 0x00DECD48. Not continuing to wait.
•2007-12-23 10:42:40.46 spid71 A time-out occurred while waiting for buffer latch -- type 2, bp 0C0C9424, page 1:12949, stat 0x4c1010f, database id: 12, allocation unit Id: 327680/281474977038336, task 0x008DBA68 : 0, waittime 300, flags 0x1a, owning task 0x00C14208. Not continuing to wait.
•2007-12-23 10:46:24.32 spid2s SQL Server has encountered 1 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [D:\MSSQL\mssqlsystemresource.mdf] in database [mssqlsystemresource] (32767). The OS file handle is 0x00000600. The offset of the latest long I/O is: 0x000000005e0000
•2007-12-23 10:46:24.32 spid2s SQL Server has encountered 37 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [H:\Production\CompanyProfile\CompanyProfile_200712.ndf] in database [CompanyProfile] (12). The OS file handle is 0x000008B8. The offset of the latest long I/O is: 0x0000252b198000
•2007-12-23 10:46:24.32 spid2s SQL Server has encountered 1 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [D:\MSSQL\master.mdf] in database [master] (1). The OS file handle is 0x000005D4. The offset of the latest long I/O is: 0x00000000178000
•2007-12-23 10:46:24.34 Server ***Unable to get thread context - no pss
•2007-12-23 10:46:24.36 Server * *******************************************************************************
•2007-12-23 10:46:24.36 Server *
•2007-12-23 10:46:24.36 Server * BEGIN STACK DUMP:
•2007-12-23 10:46:24.36 Server * 12/12/07 10:46:24 spid 0
•2007-12-23 10:46:24.36 Server *
•2007-12-23 10:46:24.36 Server * Non-yielding Scheduler
•2007-12-23 10:46:24.36 Server *
•2007-12-23 10:46:24.36 Server * *******************************************************************************
•2007-12-23 10:46:24.39 Server Stack Signature for the dump is 0x00000261