Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Server 2008 R2 in hung state. Need help in analyzing the log. Expand / Collapse
Author
Message
Posted Tuesday, April 22, 2014 4:27 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, July 18, 2014 6:10 AM
Points: 10, Visits: 228
2014-04-20 20:02:08.51 spid5s SQL Server has encountered 28 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\MSSQL\Data\tempdb_5.ndf] in database [tempdb] (2). The OS file handle is 0x0000000000000D60. The offset of the latest long I/O is: 0x0000002b6e0000
2014-04-20 20:02:08.52 spid5s SQL Server has encountered 1 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\MSSQL\Data\tempdb_6.ndf] in database [tempdb] (2). The OS file handle is 0x0000000000000D68. The offset of the latest long I/O is: 0x00000039690000
2014-04-20 20:02:08.52 spid5s SQL Server has encountered 28 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\MSSQL\Data\tempdb_7.ndf] in database [tempdb] (2). The OS file handle is 0x0000000000000D6C. The offset of the latest long I/O is: 0x000000352f0000
2014-04-20 20:02:08.53 spid5s SQL Server has encountered 24 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\MSSQL\Data\tempdb_3.ndf] in database [tempdb] (2). The OS file handle is 0x0000000000000BAC. The offset of the latest long I/O is: 0x0000003a530000
2014-04-20 20:02:08.53 spid5s SQL Server has encountered 20 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\MSSQL\Data\tempdb_4.ndf] in database [tempdb] (2). The OS file handle is 0x0000000000000D64. The offset of the latest long I/O is: 0x00000030b40000
2014-04-20 20:02:08.53 spid5s SQL Server has encountered 20 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\MSSQL\Data\tempdb.mdf] in database [tempdb] (2). The OS file handle is 0x0000000000000C0C. The offset of the latest long I/O is: 0x00000069a20000
2014-04-20 20:02:08.53 spid5s SQL Server has encountered 1 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\MSSQL\Data\tempdb_8.ndf] in database [tempdb] (2). The OS file handle is 0x0000000000000D70. The offset of the latest long I/O is: 0x00000053930000
2014-04-20 20:02:08.53 spid5s SQL Server has encountered 2 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\MSSQL\Data\tempdb_2.ndf] in database [tempdb] (2). The OS file handle is 0x0000000000000D34. The offset of the latest long I/O is: 0x0000004e8a0000
2014-04-20 20:07:12.64 spid5s SQL Server has encountered 235 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\MSSQL\Data\tempdb_7.ndf] in database [tempdb] (2). The OS file handle is 0x0000000000000D6C. The offset of the latest long I/O is: 0x0000003bd50000
2014-04-20 20:07:12.64 spid5s SQL Server has encountered 230 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\MSSQL\Data\tempdb_6.ndf] in database [tempdb] (2). The OS file handle is 0x0000000000000D68. The offset of the latest long I/O is: 0x00000040210000
2014-04-20 20:07:12.64 spid5s SQL Server has encountered 229 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\MSSQL\Data\tempdb.mdf] in database [tempdb] (2). The OS file handle is 0x0000000000000C0C. The offset of the latest long I/O is: 0x00000070330000
2014-04-20 20:07:12.64 spid5s SQL Server has encountered 228 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\MSSQL\Data\tempdb_5.ndf] in database [tempdb] (2). The OS file handle is 0x0000000000000D60. The offset of the latest long I/O is: 0x00000031fe0000
2014-04-20 20:07:12.64 spid5s SQL Server has encountered 233 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\MSSQL\Data\tempdb_8.ndf] in database [tempdb] (2). The OS file handle is 0x0000000000000D70. The offset of the latest long I/O is: 0x0000005a810000
2014-04-20 20:08:33.13 spid5s SQL Server has encountered 219 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\MSSQL\Data\tempdb_2.ndf] in database [tempdb] (2). The OS file handle is 0x0000000000000D34. The offset of the latest long I/O is: 0x0000000454a000
2014-04-20 20:08:33.14 spid5s SQL Server has encountered 229 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\MSSQL\Data\tempdb_3.ndf] in database [tempdb] (2). The OS file handle is 0x0000000000000BAC. The offset of the latest long I/O is: 0x00000003972000
2014-04-20 20:09:03.25 spid5s SQL Server has encountered 239 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\MSSQL\Data\tempdb_4.ndf] in database [tempdb] (2). The OS file handle is 0x0000000000000D64. The offset of the latest long I/O is: 0x00000002414000
2014-04-20 20:12:25.91 spid5s SQL Server has encountered 4 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\MSSQL\Data\tempdb.mdf] in database [tempdb] (2). The OS file handle is 0x0000000000000C0C. The offset of the latest long I/O is: 0x000000caad0000
2014-04-20 20:12:25.93 spid5s SQL Server has encountered 7 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\MSSQL\Data\tempdb_5.ndf] in database [tempdb] (2). The OS file handle is 0x0000000000000D60. The offset of the latest long I/O is: 0x00000000f70000
2014-04-20 20:13:26.67 spid5s SQL Server has encountered 2 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\MSSQL\Data\tempdb_8.ndf] in database [tempdb] (2). The OS file handle is 0x0000000000000D70. The offset of the latest long I/O is: 0x0000005c5c0000
2014-04-20 20:13:26.67 spid5s SQL Server has encountered 6 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\MSSQL\Data\tempdb_6.ndf] in database [tempdb] (2). The OS file handle is 0x0000000000000D68. The offset of the latest long I/O is: 0x00000041fa0000
2014-04-20 20:13:26.69 spid5s SQL Server has encountered 3 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\MSSQL\Data\tempdb_7.ndf] in database [tempdb] (2). The OS file handle is 0x0000000000000D6C. The offset of the latest long I/O is: 0x0000003dad0000
2014-04-20 20:13:36.71 spid5s SQL Server has encountered 9 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\MSSQL\Data\tempdb_2.ndf] in database [tempdb] (2). The OS file handle is 0x0000000000000D34. The offset of the latest long I/O is: 0x00000054570000
2014-04-20 20:13:36.73 spid5s SQL Server has encountered 5 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\MSSQL\Data\tempdb_3.ndf] in database [tempdb] (2). The OS file handle is 0x0000000000000BAC. The offset of the latest long I/O is: 0x00000040090000
2014-04-20 20:16:17.68 spid5s SQL Server has encountered 4 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\MSSQL\Data\tempdb_4.ndf] in database [tempdb] (2). The OS file handle is 0x0000000000000D64. The offset of the latest long I/O is: 0x00000038e20000
2014-04-20 20:17:27.83 spid5s SQL Server has encountered 4 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\MSSQL\Data\tempdb.mdf] in database [tempdb] (2). The OS file handle is 0x0000000000000C0C. The offset of the latest long I/O is: 0x00000074ce0000
2014-04-20 20:17:27.84 spid5s SQL Server has encountered 1 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\MSSQL\Data\tempdb_5.ndf] in database [tempdb] (2). The OS file handle is 0x0000000000000D60. The offset of the latest long I/O is: 0x00000036a50000
2014-04-20 20:19:08.07 spid5s SQL Server has encountered 3 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\MSSQL\Data\tempdb_8.ndf] in database [tempdb] (2). The OS file handle is 0x0000000000000D70. The offset of the latest long I/O is: 0x0000005f6f0000
2014-04-20 20:19:08.07 spid5s SQL Server has encountered 3 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\MSSQL\Data\tempdb_7.ndf] in database [tempdb] (2). The OS file handle is 0x0000000000000D6C. The offset of the latest long I/O is: 0x00000040c50000
2014-04-20 20:19:08.07 spid5s SQL Server has encountered 1 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\MSSQL\Data\tempdb_6.ndf] in database [tempdb] (2). The OS file handle is 0x0000000000000D68. The offset of the latest long I/O is: 0x00000045110000
2014-04-20 20:19:08.09 spid5s SQL Server has encountered 4 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\MSSQL\Data\tempdb_2.ndf] in database [tempdb] (2). The OS file handle is 0x0000000000000D34. The offset of the latest long I/O is: 0x00000057430000
2014-04-20 20:20:48.31 spid5s SQL Server has encountered 4 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\MSSQL\Data\tempdb_3.ndf] in database [tempdb] (2). The OS file handle is 0x0000000000000BAC. The offset of the latest long I/O is: 0x0000000245a000
2014-04-20 20:21:28.41 spid5s SQL Server has encountered 4 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\MSSQL\Data\tempdb_4.ndf] in database [tempdb] (2). The OS file handle is 0x0000000000000D64. The offset of the latest long I/O is: 0x0000003a1c0000
2014-04-20 20:23:08.71 spid5s SQL Server has encountered 6 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\MSSQL\Data\tempdb.mdf] in database [tempdb] (2). The OS file handle is 0x0000000000000C0C. The offset of the latest long I/O is: 0x00000075ef0000
2014-04-20 20:25:19.12 spid5s SQL Server has encountered 2 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\MSSQL\Data\tempdb_6.ndf] in database [tempdb] (2). The OS file handle is 0x0000000000000D68. The offset of the latest long I/O is: 0x00000017f80000
2014-04-20 20:25:29.16 spid5s SQL Server has encountered 4 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\MSSQL\Data\tempdb_8.ndf] in database [tempdb] (2). The OS file handle is 0x0000000000000D70. The offset of the latest long I/O is: 0x00000060a10000
2014-04-20 20:25:29.16 spid5s SQL Server has encountered 5 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\MSSQL\Data\tempdb_2.ndf] in database [tempdb] (2). The OS file handle is 0x0000000000000D34. The offset of the latest long I/O is: 0x00000058820000
2014-04-20 20:25:29.17 spid5s SQL Server has encountered 3 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\MSSQL\Data\tempdb_7.ndf] in database [tempdb] (2). The OS file handle is 0x0000000000000D6C. The offset of the latest long I/O is: 0x00000042000000
2014-04-20 20:27:09.51 spid5s SQL Server has encountered 5 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\MSSQL\Data\tempdb_3.ndf] in database [tempdb] (2). The OS file handle is 0x0000000000000BAC. The offset of the latest long I/O is: 0x00000044340000
2014-04-20 20:29:29.97 spid5s SQL Server has encountered 4 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\MSSQL\Data\tempdb.mdf] in database [tempdb] (2). The OS file handle is 0x0000000000000C0C. The offset of the latest long I/O is: 0x000000775d0000
2014-04-20 20:30:20.13 spid5s SQL Server has encountered 2 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\MSSQL\Data\tempdb_4.ndf] in database [tempdb] (2). The OS file handle is 0x0000000000000D64. The offset of the latest long I/O is: 0x000000013c0000
2014-04-20 20:31:10.34 spid5s SQL Server has encountered 1 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\MSSQL\Data\tempdb_5.ndf] in database [tempdb] (2). The OS file handle is 0x0000000000000D60. The offset of the latest long I/O is: 0x0000003b6b0000
2014-04-20 20:31:10.34 spid5s SQL Server has encountered 4 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\MSSQL\Data\tempdb_2.ndf] in database [tempdb] (2). The OS file handle is 0x0000000000000D34. The offset of the latest long I/O is: 0x0000005bc10000
2014-04-20 20:33:20.64 spid5s SQL Server has encountered 3 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\MSSQL\Data\tempdb_6.ndf] in database [tempdb] (2). The OS file handle is 0x0000000000000D68. The offset of the latest long I/O is: 0x000000007d4000
2014-04-20 20:33:30.66 spid5s SQL Server has encountered 5 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\MSSQL\Data\tempdb_8.ndf] in database [tempdb] (2). The OS file handle is 0x0000000000000D70. The offset of the latest long I/O is: 0x00000064c20000
2014-04-20 20:33:30.66 spid5s SQL Server has encountered 5 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\MSSQL\Data\tempdb_7.ndf] in database [tempdb] (2). The OS file handle is 0x0000000000000D6C. The offset of the latest long I/O is: 0x00000046180000
2014-04-20 20:35:20.99 spid5s SQL Server has encountered 4 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\MSSQL\Data\tempdb.mdf] in database [tempdb] (2). The OS file handle is 0x0000000000000C0C. The offset of the latest long I/O is: 0x00000003cbc000
2014-04-20 20:35:21.00 spid5s SQL Server has encountered 3 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\MSSQL\Data\tempdb_3.ndf] in database [tempdb] (2). The OS file handle is 0x0000000000000BAC. The offset of the latest long I/O is: 0x000000488e0000
2014-04-20 20:35:21.00 spid5s SQL Server has encountered 3 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\MSSQL\Data\tempdb_4.ndf] in database [tempdb] (2). The OS file handle is 0x0000000000000D64. The offset of the latest long I/O is: 0x0000003f1a0000
2014-04-20 20:37:31.28 spid5s SQL Server has encountered 3 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\MSSQL\Data\tempdb_2.ndf] in database [tempdb] (2). The OS file handle is 0x0000000000000D34. The offset of the latest long I/O is: 0x0000005d990000
2014-04-20 20:39:21.53 spid5s SQL Server has encountered 5 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\MSSQL\Data\tempdb_6.ndf] in database [tempdb] (2). The OS file handle is 0x0000000000000D68. The offset of the latest long I/O is: 0x0000004b9f0000
2014-04-20 20:39:21.54 spid5s SQL Server has encountered 4 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\MSSQL\Data\tempdb_7.ndf] in database [tempdb] (2). The OS file handle is 0x0000000000000D6C. The offset of the latest long I/O is: 0x000000473d0000
2014-04-20 20:39:21.54 spid5s SQL Server has encountered 3 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\MSSQL\Data\tempdb_8.ndf] in database [tempdb] (2). The OS file handle is 0x0000000000000D70. The offset of the latest long I/O is: 0x00000065e40000
2014-04-20 20:41:31.90 spid5s SQL Server has encountered 4 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\MSSQL\Data\tempdb.mdf] in database [tempdb] (2). The OS file handle is 0x0000000000000C0C. The offset of the latest long I/O is: 0x0000007bbe0000
2014-04-20 20:43:22.26 spid5s SQL Server has encountered 1 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\MSSQL\Data\tempdb_4.ndf] in database [tempdb] (2). The OS file handle is 0x0000000000000D64. The offset of the latest long I/O is: 0x00000040650000
2014-04-20 20:43:22.26 spid5s SQL Server has encountered 6 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\MSSQL\Data\tempdb_2.ndf] in database [tempdb] (2). The OS file handle is 0x0000000000000D34. The offset of the latest long I/O is: 0x0000005e350000
2014-04-20 20:43:22.26 spid5s SQL Server has encountered 2 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\MSSQL\Data\tempdb_3.ndf] in database [tempdb] (2). The OS file handle is 0x0000000000000BAC. The offset of the latest long I/O is: 0x00000049d30000
2014-04-20 20:43:22.26 spid5s SQL Server has encountered 3 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\MSSQL\Data\tempdb_5.ndf] in database [tempdb] (2). The OS file handle is 0x0000000000000D60. The offset of the latest long I/O is: 0x0000003dda0000
2014-04-20 20:44:22.43 spid5s SQL Server has encountered 2 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\MSSQL\Data\tempdb_8.ndf] in database [tempdb] (2). The OS file handle is 0x0000000000000D70. The offset of the latest long I/O is: 0x00000001fe0000
2014-04-20 20:45:22.67 spid5s SQL Server has encountered 2 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\MSSQL\Data\tempdb_7.ndf] in database [tempdb] (2). The OS file handle is 0x0000000000000D6C. The offset of the latest long I/O is: 0x000000074d6000
2014-04-20 20:45:22.71 spid5s SQL Server has encountered 3 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\MSSQL\Data\tempdb_6.ndf] in database [tempdb] (2). The OS file handle is 0x0000000000000D68. The offset of the latest long I/O is: 0x000000b1e60000
2014-04-20 20:47:13.03 spid5s SQL Server has encountered 9 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\MSSQL\Data\tempdb.mdf] in database [tempdb] (2). The OS file handle is 0x0000000000000C0C. The offset of the latest long I/O is: 0x000000042a4000
2014-04-20 20:49:33.65 spid5s SQL Server has encountered 10 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\MSSQL\Data\tempdb_2.ndf] in database [tempdb] (2). The OS file handle is 0x0000000000000D34. The offset of the latest long I/O is: 0x00000061cd0000
2014-04-20 20:49:33.65 spid5s SQL Server has encountered 17 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\MSSQL\Data\tempdb_8.ndf] in database [tempdb] (2). The OS file handle is 0x0000000000000D70. The offset of the latest long I/O is: 0x00000069f50000
2014-04-20 20:49:33.66 spid5s SQL Server has encountered 17 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\MSSQL\Data\tempdb_3.ndf] in database [tempdb] (2). The OS file handle is 0x0000000000000BAC. The offset of the latest long I/O is: 0x0000004d670000
2014-04-20 20:50:23.78 spid5s SQL Server has encountered 14 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\MSSQL\Data\tempdb_5.ndf] in database [tempdb] (2). The OS file handle is 0x0000000000000D60. The offset of the latest long I/O is: 0x00000002794000
2014-04-20 20:50:23.78 spid5s SQL Server has encountered 14 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\MSSQL\Data\tempdb_7.ndf] in database [tempdb] (2). The OS file handle is 0x0000000000000D6C. The offset of the latest long I/O is: 0x000000a5560000
2014-04-20 20:50:23.79 spid5s SQL Server has encountered 7 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\MSSQL\Data\tempdb_6.ndf] in database [tempdb] (2). The OS file handle is 0x0000000000000D68. The offset of the latest long I/O is: 0x00000001e00000
2014-04-20 20:50:43.84 spid5s SQL Server has encountered 9 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\MSSQL\Data\tempdb_4.ndf] in database [tempdb] (2). The OS file handle is 0x0000000000000D64. The offset of the latest long I/O is: 0x00000093390000
2014-04-20 20:54:34.43 spid5s SQL Server has encountered 8 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\MSSQL\Data\tempdb_3.ndf] in database [tempdb] (2). The OS file handle is 0x0000000000000BAC. The offset of the latest long I/O is: 0x0000009cca0000
2014-04-20 20:54:34.43 spid5s SQL Server has encountered 11 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\MSSQL\Data\tempdb.mdf] in database [tempdb] (2). The OS file handle is 0x0000000000000C0C. The offset of the latest long I/O is: 0x000000cf650000
2014-04-20 20:55:24.58 spid5s SQL Server has encountered 7 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\MSSQL\Data\tempdb_7.ndf] in database [tempdb] (2). The OS file handle is 0x0000000000000D6C. The offset of the latest long I/O is: 0x00000002528000
2014-04-20 20:55:24.59 spid5s SQL Server has encountered 6 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\MSSQL\Data\tempdb_8.ndf] in database [tempdb] (2). The OS file handle is 0x0000000000000D70. The offset of the latest long I/O is: 0x0000003c640000
2014-04-20 20:55:24.59 spid5s SQL Server has encountered 5 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\MSSQL\Data\tempdb_6.ndf] in database [tempdb] (2). The OS file handle is 0x0000000000000D68. The offset of the latest long I/O is: 0x000000012ee000
2014-04-20 20:55:24.60 spid5s SQL Server has encountered 5 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\MSSQL\Data\tempdb_2.ndf] in database [tempdb] (2). The OS file handle is 0x0000000000000D34. The offset of the latest long I/O is: 0x000000b0f90000
2014-04-20 20:55:24.62 spid5s SQL Server has encountered 3 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\MSSQL\Data\tempdb_5.ndf] in database [tempdb] (2). The OS file handle is 0x0000000000000D60. The offset of the latest long I/O is: 0x00000042b60000
2014-04-20 20:57:34.93 spid5s SQL Server has encountered 4 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\MSSQL\Data\tempdb_4.ndf] in database [tempdb] (2). The OS file handle is 0x0000000000000D64. The offset of the latest long I/O is: 0x00000045560000




2014-04-20 21:00:25.51 spid5s SQL Server has encountered 2 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\MSSQL\Data\tempdb_5.ndf] in database [tempdb] (2). The OS file handle is 0x0000000000000D60. The offset of the latest long I/O is: 0x00000043f00000
2014-04-20 21:00:25.51 spid5s SQL Server has encountered 3 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\MSSQL\Data\tempdb_8.ndf] in database [tempdb] (2). The OS file handle is 0x0000000000000D70. The offset of the latest long I/O is: 0x000000bd130000
2014-04-20 21:00:25.51 spid5s SQL Server has encountered 7 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\MSSQL\Data\tempdb_6.ndf] in database [tempdb] (2). The OS file handle is 0x0000000000000D68. The offset of the latest long I/O is: 0x00000099e90000
2014-04-20 21:00:25.51 spid5s SQL Server has encountered 3 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\MSSQL\Data\tempdb_7.ndf] in database [tempdb] (2). The OS file handle is 0x0000000000000D6C. The offset of the latest long I/O is: 0x00000095bf0000
2014-04-20 21:00:25.51 spid5s SQL Server has encountered 4 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\MSSQL\Data\tempdb.mdf] in database [tempdb] (2). The OS file handle is 0x0000000000000C0C. The offset of the latest long I/O is: 0x000000042e0000
2014-04-20 21:00:25.51 spid5s SQL Server has encountered 4 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\MSSQL\Data\tempdb_3.ndf] in database [tempdb] (2). The OS file handle is 0x0000000000000BAC. The offset of the latest long I/O is: 0x00000097cd0000
2014-04-20 21:00:25.51 spid5s SQL Server has encountered 4 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\MSSQL\Data\tempdb_2.ndf] in database [tempdb] (2). The OS file handle is 0x0000000000000D34. The offset of the latest long I/O is: 0x000000ac910000




2014-04-20 21:05:26.38 spid5s SQL Server has encountered 29 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\MSSQL\Data\tempdb_3.ndf] in database [tempdb] (2). The OS file handle is 0x0000000000000BAC. The offset of the latest long I/O is: 0x00000002eea000
2014-04-20 21:05:26.39 spid5s SQL Server has encountered 39 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\MSSQL\Data\tempdb.mdf] in database [tempdb] (2). The OS file handle is 0x0000000000000C0C. The offset of the latest long I/O is: 0x00000002382000
2014-04-20 21:05:26.39 spid5s SQL Server has encountered 34 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\MSSQL\Data\tempdb_6.ndf] in database [tempdb] (2). The OS file handle is 0x0000000000000D68. The offset of the latest long I/O is: 0x0000000177c000
2014-04-20 21:05:26.39 spid5s SQL Server has encountered 25 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\MSSQL\Data\tempdb_7.ndf] in database [tempdb] (2). The OS file handle is 0x0000000000000D6C. The offset of the latest long I/O is: 0x00000007f14000
2014-04-20 21:06:10.56 spid5s SQL Server has encountered 33 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\MSSQL\Data\tempdb_2.ndf] in database [tempdb] (2). The OS file handle is 0x0000000000000D34. The offset of the latest long I/O is: 0x00000067300000
2014-04-20 21:06:10.56 spid5s SQL Server has encountered 36 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\MSSQL\Data\tempdb_8.ndf] in database [tempdb] (2). The OS file handle is 0x0000000000000D70. The offset of the latest long I/O is: 0x00000002c18000
2014-04-20 21:06:10.56 spid5s SQL Server has encountered 36 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\MSSQL\Data\tempdb_5.ndf] in database [tempdb] (2). The OS file handle is 0x0000000000000D60. The offset of the latest long I/O is: 0x00000002030000
2014-04-20 21:15:26.13 spid5s SQL Server has encountered 5 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\MSSQL\Data\tempdb_7.ndf] in database [tempdb] (2). The OS file handle is 0x0000000000000D6C. The offset of the latest long I/O is: 0x00000034150000
2014-04-20 21:17:07.33 spid5s SQL Server has encountered 25 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\MSSQL\Data\tempdb_4.ndf] in database [tempdb] (2). The OS file handle is 0x0000000000000D64. The offset of the latest long I/O is: 0x0000000c960000
2014-04-20 21:17:08.16 spid5s SQL Server has encountered 2 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\MSSQL\Data\tempdb.mdf] in database [tempdb] (2). The OS file handle is 0x0000000000000C0C. The offset of the latest long I/O is: 0x00000003ab4000
2014-04-20 21:17:08.16 spid5s SQL Server has encountered 5 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\MSSQL\Data\tempdb_3.ndf] in database [tempdb] (2). The OS file handle is 0x0000000000000BAC. The offset of the latest long I/O is: 0x00000011260000
2014-04-20 21:17:08.16 spid5s SQL Server has encountered 1 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\MSSQL\Data\tempdb_2.ndf] in database [tempdb] (2). The OS file handle is 0x0000000000000D34. The offset of the latest long I/O is: 0x00000067430000
2014-04-20 21:17:08.16 spid5s SQL Server has encountered 1 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\MSSQL\Data\tempdb_7.ndf] in database [tempdb] (2). The OS file handle is 0x0000000000000D6C. The offset of the latest long I/O is: 0x00000002142000
2014-04-20 21:17:08.16 spid5s SQL Server has encountered 2 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\MSSQL\Data\tempdb_5.ndf] in database [tempdb] (2). The OS file handle is 0x0000000000000D60. The offset of the latest long I/O is: 0x000000f8fe0000
2014-04-20 21:17:08.16 spid5s SQL Server has encountered 3 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\MSSQL\Data\tempdb_6.ndf] in database [tempdb] (2). The OS file handle is 0x0000000000000D68. The offset of the latest long I/O is: 0x0000008a180000


2014-04-20 21:19:47.30 spid580 Error: 10982, Severity: 16, State: 1.
2014-04-20 21:19:47.30 spid580 Failed to run resource governor classifier user-defined function. See previous errors in SQL Server error log from session ID 580 for details. Classifier elapsed time: 9 ms.
2014-04-20 21:19:47.32 spid583 Error: 10982, Severity: 16, State: 1.
2014-04-20 21:19:47.32 spid583 Failed to run resource governor classifier user-defined function. See previous errors in SQL Server error log from session ID 583 for details. Classifier elapsed time: 0 ms.
2014-04-20 21:20:08.18 spid5s SQL Server has encountered 4 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\MSSQL\Data\tempdb_8.ndf] in database [tempdb] (2). The OS file handle is 0x0000000000000D70. The offset of the latest long I/O is: 0x00000002c06000

2014-04-20 21:24:22.73 spid569 Error: 10982, Severity: 16, State: 1.
2014-04-20 21:24:22.73 spid569 Failed to run resource governor classifier user-defined function. See previous errors in SQL Server error log from session ID 569 for details. Classifier elapsed time: 0 ms.
2014-04-20 21:25:01.52 Logon Error: 18456, Severity: 14, State: 38.
2014-04-20 21:25:01.52 Logon Login failed for user 'NT AUTHORITY\SYSTEM'. Reason: Failed to open the explicitly specified database. [CLIENT: X.X.X.X]

2014-04-20 21:25:21.92 spid5s SQL Server has encountered 5 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\MSSQL\Data\tempdb_7.ndf] in database [tempdb] (2). The OS file handle is 0x0000000000000D6C. The offset of the latest long I/O is: 0x00000050d20000
2014-04-20 21:25:42.93 spid5s SQL Server has encountered 2 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\MSSQL\Data\tempdb_8.ndf] in database [tempdb] (2). The OS file handle is 0x0000000000000D70. The offset of the latest long I/O is: 0x0000006f840000
2014-04-20 21:26:03.94 spid5s SQL Server has encountered 5 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\MSSQL\Data\tempdb_5.ndf] in database [tempdb] (2). The OS file handle is 0x0000000000000D60. The offset of the latest long I/O is: 0x00000047040000
2014-04-20 21:29:33.00 spid5s SQL Server has encountered 4 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\MSSQL\Data\tempdb_6.ndf] in database [tempdb] (2). The OS file handle is 0x0000000000000D68. The offset of the latest long I/O is: 0x0000000223e000

2014-04-20 21:30:01.90 spid179 Timeout occurred while waiting for latch: class 'ACCESS_METHODS_DATASET_PARENT', id 00000003B6AE0878, type 4, Task 0x000000000A8594C8 : 5, waittime 300, flags 0x1a, owning task 0x000000000A83BB88. Continuing to wait.
2014-04-20 21:30:01.90 spid179 Timeout occurred while waiting for latch: class 'ACCESS_METHODS_DATASET_PARENT', id 00000003B6AE0878, type 4, Task 0x000000000A84E508 : 1, waittime 300, flags 0x1a, owning task 0x000000000A83BB88. Continuing to wait.
2014-04-20 21:30:01.90 spid179 Timeout occurred while waiting for latch: class 'ACCESS_METHODS_DATASET_PARENT', id 00000003B6AE0878, type 4, Task 0x000000000A880988 : 2, waittime 300, flags 0x1a, owning task 0x000000000A83BB88. Continuing to wait.
2014-04-20 21:30:01.90 spid179 Timeout occurred while waiting for latch: class 'ACCESS_METHODS_DATASET_PARENT', id 00000003B6AE0878, type 4, Task 0x000000000A845B88 : 3, waittime 300, flags 0x1a, owning task 0x000000000A83BB88. Continuing to wait.
2014-04-20 21:30:01.90 spid179 Timeout occurred while waiting for latch: class 'ACCESS_METHODS_DATASET_PARENT', id 00000003B6AE0878, type 4, Task 0x000000000A813B88 : 8, waittime 300, flags 0x1a, owning task 0x000000000A83BB88. Continuing to wait.
2014-04-20 21:30:01.90 spid179 Timeout occurred while waiting for latch: class 'ACCESS_METHODS_DATASET_PARENT', id 00000003B6AE0878, type 4, Task 0x000000000A877288 : 6, waittime 300, flags 0x1a, owning task 0x000000000A83BB88. Continuing to wait.
2014-04-20 21:33:53.46 spid179 Timeout occurred while waiting for latch: class 'ACCESS_METHODS_DATASET_PARENT', id 00000003B6AE0878, type 4, Task 0x000000000A895708 : 7, waittime 300, flags 0x1a, owning task 0x000000000A83BB88. Continuing to wait.
2014-04-20 21:35:01.90 spid179 Timeout occurred while waiting for latch: class 'ACCESS_METHODS_DATASET_PARENT', id 00000003B6AE0878, type 4, Task 0x000000000A8594C8 : 5, waittime 600, flags 0x1a, owning task 0x000000000A83BB88. Continuing to wait.
2014-04-20 21:35:01.91 spid179 Timeout occurred while waiting for latch: class 'ACCESS_METHODS_DATASET_PARENT', id 00000003B6AE0878, type 4, Task 0x000000000A877288 : 6, waittime 600, flags 0x1a, owning task 0x000000000A83BB88. Continuing to wait.
2014-04-20 21:35:01.91 spid179 Timeout occurred while waiting for latch: class 'ACCESS_METHODS_DATASET_PARENT', id 00000003B6AE0878, type 4, Task 0x000000000A880988 : 2, waittime 600, flags 0x1a, owning task 0x000000000A83BB88. Continuing to wait.
2014-04-20 21:35:01.91 spid179 Timeout occurred while waiting for latch: class 'ACCESS_METHODS_DATASET_PARENT', id 00000003B6AE0878, type 4, Task 0x000000000A813B88 : 8, waittime 600, flags 0x1a, owning task 0x000000000A83BB88. Continuing to wait.
2014-04-20 21:35:01.91 spid179 Timeout occurred while waiting for latch: class 'ACCESS_METHODS_DATASET_PARENT', id 00000003B6AE0878, type 4, Task 0x000000000A845B88 : 3, waittime 600, flags 0x1a, owning task 0x000000000A83BB88. Continuing to wait.
2014-04-20 21:35:01.91 spid179 Timeout occurred while waiting for latch: class 'ACCESS_METHODS_DATASET_PARENT', id 00000003B6AE0878, type 4, Task 0x000000000A84E508 : 1, waittime 600, flags 0x1a, owning task 0x000000000A83BB88. Continuing to wait.
2014-04-20 21:38:32.77 spid473 Timeout occurred while waiting for latch: class 'ACCESS_METHODS_DATASET_PARENT', id 000000012C822878, type 4, Task 0x0000000005827708 : 5, waittime 600, flags 0x1a, owning task 0x0000000005830748. Continuing to wait.
2014-04-20 21:40:01.91 spid179 Timeout occurred while waiting for latch: class 'ACCESS_METHODS_DATASET_PARENT', id 00000003B6AE0878, type 4, Task 0x000000000A813B88 : 8, waittime 900, flags 0x1a, owning task 0x000000000A83BB88. Continuing to wait.
2014-04-20 22:07:48.64 spid473 Timeout occurred while waiting for latch: class 'ACCESS_METHODS_DATASET_PARENT', id 000000012C822878, type 4, Task 0x000000000588B4C8 : 6, waittime 600, flags 0x1a, owning task 0x0000000005830748. Continuing to wait.

2014-04-20 22:07:48.64 Backup Error: 3041, Severity: 16, State: 1.
2014-04-20 22:07:48.64 Backup BACKUP failed to complete the command BACKUP DATABASE . Check the backup application log for detailed messages.
2014-04-20 22:07:48.65 spid473 Timeout occurred while waiting for latch: class 'ACCESS_METHODS_DATASET_PARENT', id 000000012C822878, type 4, Task 0x0000000005844E08 : 8, waittime 600, flags 0x1a, owning task 0x0000000005830748. Continuing to wait.
2014-04-20 22:07:48.65 spid179 Timeout occurred while waiting for latch: class 'ACCESS_METHODS_DATASET_PARENT', id 00000003B6AE0878, type 4, Task 0x000000000A845B88 : 3, waittime 900, flags 0x1a, owning task 0x000000000A83BB88. Continuing to wait.
2014-04-20 22:07:48.65 spid53 Error: 18056, Severity: 20, State: 29.
2014-04-20 22:07:48.65 spid53 The client was unable to reuse a session with SPID 53, which had been reset for connection pooling. The failure ID is 29. This error may have been caused by an earlier operation failing. Check the error logs for failed operations immediately before this error message.
2014-04-20 22:07:48.65 spid179 Timeout occurred while waiting for latch: class 'ACCESS_METHODS_DATASET_PARENT', id 00000003B6AE0878, type 4, Task 0x000000000A84E508 : 1, waittime 900, flags 0x1a, owning task 0x000000000A83BB88. Continuing to wait.
2014-04-20 22:07:48.65 spid473 Timeout occurred while waiting for latch: class 'ACCESS_METHODS_DATASET_PARENT', id 000000012C822878, type 4, Task 0x0000000005827708 : 5, waittime 900, flags 0x1a, owning task 0x0000000005830748. Continuing to wait.
2014-04-20 22:07:48.65 spid5s SQL Server has encountered 5 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\MSSQL\Data\tempdb_4.ndf] in database [tempdb] (2). The OS file handle is 0x0000000000000D64. The offset of the latest long I/O is: 0x0000000e700000
2014-04-20 22:07:48.65 spid5s SQL Server has encountered 1 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\MSSQL\Data\tempdb_4.ndf] in database [tempdb] (2). The OS file handle is 0x0000000000000D64. The offset of the latest long I/O is: 0x0000000046a000
2014-04-20 22:07:48.66 spid5s SQL Server has encountered 9 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\MSSQL\Data\tempdb_3.ndf] in database [tempdb] (2). The OS file handle is 0x0000000000000BAC. The offset of the latest long I/O is: 0x00000017c42000
2014-04-20 22:07:48.66 spid473 Timeout occurred while waiting for latch: class 'ACCESS_METHODS_DATASET_PARENT', id 000000012C822878, type 4, Task 0x000000000581CBC8 : 1, waittime 600, flags 0x1a, owning task 0x0000000005830748. Continuing to wait.
2014-04-20 22:07:48.66 spid5s SQL Server has encountered 1 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\MSSQL\Data\tempdb_7.ndf] in database [tempdb] (2). The OS file handle is 0x0000000000000D6C. The offset of the latest long I/O is: 0x00000000b3a000
2014-04-20 22:07:48.66 spid179 Timeout occurred while waiting for latch: class 'ACCESS_METHODS_DATASET_PARENT', id 00000003B6AE0878, type 4, Task 0x000000000A880988 : 2, waittime 900, flags 0x1a, owning task 0x000000000A83BB88. Continuing to wait.
2014-04-20 22:07:48.66 spid5s SQL Server has encountered 7 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\MSSQL\Data\tempdb_2.ndf] in database [tempdb] (2). The OS file handle is 0x0000000000000D34. The offset of the latest long I/O is: 0x000000034ae000
2014-04-20 22:07:48.66 spid223 Error: 10982, Severity: 16, State: 1.
2014-04-20 22:07:48.66 spid223 Failed to run resource governor classifier user-defined function. See previous errors in SQL Server error log from session ID 223 for details. Classifier elapsed time: 0 ms.
2014-04-20 22:07:48.66 spid5s SQL Server has encountered 1 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\MSSQL\Data\tempdb_6.ndf] in database [tempdb] (2). The OS file handle is 0x0000000000000D68. The offset of the latest long I/O is: 0x00000039180000
2014-04-20 22:07:48.66 spid217 Error: 10982, Severity: 16, State: 1.
2014-04-20 22:07:48.66 spid217 Failed to run resource governor classifier user-defined function. See previous errors in SQL Server error log from session ID 217 for details. Classifier elapsed time: 0 ms.
2014-04-20 22:07:48.67 spid473 Timeout occurred while waiting for latch: class 'ACCESS_METHODS_DATASET_PARENT', id 000000012C822878, type 4, Task 0x000000000589EBC8 : 4, waittime 600, flags 0x1a, owning task 0x0000000005830748. Continuing to wait.
2014-04-20 22:07:48.67 spid5s SQL Server has encountered 5 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\MSSQL\Data\tempdb.mdf] in database [tempdb] (2). The OS file handle is 0x0000000000000C0C. The offset of the latest long I/O is: 0x00000003456000
2014-04-20 22:07:48.67 spid179 Timeout occurred while waiting for latch: class 'ACCESS_METHODS_DATASET_PARENT', id 00000003B6AE0878, type 4, Task 0x000000000A895708 : 7, waittime 600, flags 0x1a, owning task 0x000000000A83BB88. Continuing to wait.
2014-04-20 22:07:48.67 spid5s SQL Server has encountered 1 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\MSSQL\Data\tempdb_8.ndf] in database [tempdb] (2). The OS file handle is 0x0000000000000D70. The offset of the latest long I/O is: 0x00000001a14000
2014-04-20 22:07:48.67 spid179 Timeout occurred while waiting for latch: class 'ACCESS_METHODS_DATASET_PARENT', id 00000003B6AE0878, type 4, Task 0x000000000A813B88 : 8, waittime 1200, flags 0x1a, owning task 0x000000000A83BB88. Continuing to wait.
2014-04-20 22:07:48.67 spid179 Timeout occurred while waiting for latch: class 'ACCESS_METHODS_DATASET_PARENT', id 00000003B6AE0878, type 4, Task 0x000000000A8594C8 : 5, waittime 900, flags 0x1a, owning task 0x000000000A83BB88. Continuing to wait.
2014-04-20 22:07:48.67 spid473 Timeout occurred while waiting for latch: class 'ACCESS_METHODS_DATASET_PARENT', id 000000012C822878, type 4, Task 0x0000000005880988 : 2, waittime 600, flags 0x1a, owning task 0x0000000005830748. Continuing to wait.
2014-04-20 22:07:48.67 spid465 Error: 10982, Severity: 16, State: 1.
2014-04-20 22:07:48.67 spid465 Failed to run resource governor classifier user-defined function. See previous errors in SQL Server error log from session ID 465 for details. Classifier elapsed time: 0 ms.
2014-04-20 22:07:48.67 spid473 Timeout occurred while waiting for latch: class 'ACCESS_METHODS_DATASET_PARENT', id 000000012C822878, type 4, Task 0x0000000005894E08 : 3, waittime 300, flags 0x1a, owning task 0x0000000005830748. Continuing to wait.
2014-04-20 22:07:48.67 spid179 Timeout occurred while waiting for latch: class 'ACCESS_METHODS_DATASET_PARENT', id 00000003B6AE0878, type 4, Task 0x000000000A877288 : 6, waittime 900, flags 0x1a, owning task 0x000000000A83BB88. Continuing to wait.
2014-04-20 22:07:48.68 spid5s SQL Server has encountered 1 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [T:\MSSQL\Data\tempdb_5.ndf] in database [tempdb] (2). The OS file handle is 0x0000000000000D60. The offset of the latest long I/O is: 0x000000016e0000
2014-04-20 22:07:48.73 Logon Error: 18456, Severity: 14, State: 40.
2014-04-20 22:07:48.73 Logon Login failed for user ''. Reason: Failed to open the database specified in the login properties. [CLIENT: X.X.X.X]
2014-04-20 22:10:48.66 Logon Error: 18456, Severity: 14, State: 40.
2014-04-20 22:10:48.66 Logon Login failed for user ''. Reason: Failed to open the database specified in the login properties. [CLIENT: X.X.X.X]
2014-04-20 22:12:48.67 spid179 Timeout occurred while waiting for latch: class 'ACCESS_METHODS_DATASET_PARENT', id 00000003B6AE0878, type 4, Task 0x000000000A880988 : 2, waittime 300, flags 0x1a, owning task 0x000000000A877288. Continuing to wait.
2014-04-20 22:16:58.71 spid5s LazyWriter: warning, no free buffers found.
2014-04-20 22:16:58.72 spid5s
Memory Manager KB
---------------------------------------- ----------
VM Reserved 67527736
VM Committed 905548
Locked Pages Allocated 54434560
Reserved Memory 1024
Reserved Memory In Use 0
2014-04-20 22:16:58.72 spid5s
Memory node Id = 0 KB
---------------------------------------- ----------
VM Reserved 48192
VM Committed 47760
Locked Pages Allocated 0
MultiPage Allocator 11984
SinglePage Allocator 7310784
2014-04-20 22:16:58.72 spid5s
Memory node Id = 1 KB
---------------------------------------- ----------
VM Reserved 67475896
VM Committed 854248
Locked Pages Allocated 54434560
MultiPage Allocator 351712
SinglePage Allocator 7310784
2014-04-20 22:16:58.72 spid5s
Memory node Id = 64 KB
---------------------------------------- ----------
VM Reserved 2560
VM Committed 2504
Locked Pages Allocated 0
MultiPage Allocator 2416
SinglePage Allocator 7310784
2014-04-20 22:16:58.75 spid5s
MEMORYCLERK_SQLGENERAL (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 17424
MultiPage Allocator 11128
2014-04-20 22:16:58.75 spid5s
MEMORYCLERK_SQLGENERAL (node 1) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 184
MultiPage Allocator 16
2014-04-20 22:16:58.75 spid5s
MEMORYCLERK_SQLGENERAL (Total) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 17608
MultiPage Allocator 11144
2014-04-20 22:16:58.75 spid5s
MEMORYCLERK_SQLBUFFERPOOL (node 0) KB
---------------------------------------- ----------
VM Reserved 66666496
VM Committed 65536
Locked Pages Allocated 54434560
SM Reserved 0
SM Committed 0
SinglePage Allocator 0
MultiPage Allocator 1936
2014-04-20 22:16:58.75 spid5s
MEMORYCLERK_SQLQUERYEXEC (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 1480
MultiPage Allocator 904
2014-04-20 22:16:58.75 spid5s
MEMORYCLERK_SQLQUERYEXEC (node 1) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 656
MultiPage Allocator 1352
2014-04-20 22:16:58.75 spid5s
MEMORYCLERK_SQLQUERYEXEC (Total) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 2136
MultiPage Allocator 2256
2014-04-20 22:16:58.75 spid5s
MEMORYCLERK_SQLOPTIMIZER (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 2464
MultiPage Allocator 976
2014-04-20 22:16:58.75 spid5s
MEMORYCLERK_SQLOPTIMIZER (node 1) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 400
MultiPage Allocator 48
2014-04-20 22:16:58.75 spid5s
MEMORYCLERK_SQLOPTIMIZER (Total) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 2864
MultiPage Allocator 1024
2014-04-20 22:16:58.75 spid5s
MEMORYCLERK_SQLUTILITIES (node 0) KB
---------------------------------------- ----------
VM Reserved 120
VM Committed 120
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 160
MultiPage Allocator 0
2014-04-20 22:16:58.75 spid5s
MEMORYCLERK_SQLSTORENG (node 0) KB
---------------------------------------- ----------
VM Reserved 31744
VM Committed 31744
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 19296
MultiPage Allocator 1600
2014-04-20 22:16:58.75 spid5s
MEMORYCLERK_SQLSTORENG (node 1) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 9496
MultiPage Allocator 4056
2014-04-20 22:16:58.75 spid5s
MEMORYCLERK_SQLSTORENG (Total) KB
---------------------------------------- ----------
VM Reserved 31744
VM Committed 31744
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 28792
MultiPage Allocator 5656
2014-04-20 22:16:58.75 spid5s
MEMORYCLERK_SQLCONNECTIONPOOL (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 6624
MultiPage Allocator 40
2014-04-20 22:16:58.75 spid5s
MEMORYCLERK_SQLCONNECTIONPOOL (node 1) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 5624
MultiPage Allocator 32
2014-04-20 22:16:58.75 spid5s
MEMORYCLERK_SQLCONNECTIONPOOL (Total) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 12248
MultiPage Allocator 72
2014-04-20 22:16:58.75 spid5s
MEMORYCLERK_SQLCLR (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 8
MultiPage Allocator 0
2014-04-20 22:16:58.75 spid5s
MEMORYCLERK_SQLSERVICEBROKER (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 192
MultiPage Allocator 544
2014-04-20 22:16:58.75 spid5s
MEMORYCLERK_SQLHTTP (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 8
MultiPage Allocator 0
2014-04-20 22:16:58.75 spid5s
MEMORYCLERK_SNI (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 2160
MultiPage Allocator 16
2014-04-20 22:16:58.75 spid5s
MEMORYCLERK_SNI (node 1) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 2128
MultiPage Allocator 64
2014-04-20 22:16:58.75 spid5s
MEMORYCLERK_SNI (node 64) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 0
MultiPage Allocator 16
2014-04-20 22:16:58.75 spid5s
MEMORYCLERK_SNI (Total) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 4288
MultiPage Allocator 96
2014-04-20 22:16:58.75 spid5s
MEMORYCLERK_FULLTEXT (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 24
MultiPage Allocator 0
2014-04-20 22:16:58.75 spid5s
MEMORYCLERK_SQLXP (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 16
MultiPage Allocator 0
2014-04-20 22:16:58.75 spid5s
MEMORYCLERK_BHF (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 432
MultiPage Allocator 0
2014-04-20 22:16:58.75 spid5s
MEMORYCLERK_BHF (node 1) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 592
MultiPage Allocator 0
2014-04-20 22:16:58.75 spid5s
MEMORYCLERK_BHF (Total) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 1024
MultiPage Allocator 0
2014-04-20 22:16:58.75 spid5s
MEMORYCLERK_SQLQERESERVATIONS (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 3189848
MultiPage Allocator 0
2014-04-20 22:16:58.75 spid5s
MEMORYCLERK_XE_BUFFER (node 0) KB
---------------------------------------- ----------
VM Reserved 5632
VM Committed 5632
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 0
MultiPage Allocator 0
2014-04-20 22:16:58.75 spid5s
MEMORYCLERK_XE_BUFFER (node 1) KB
---------------------------------------- ----------
VM Reserved 2816
VM Committed 2816
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 0
MultiPage Allocator 0
2014-04-20 22:16:58.75 spid5s
MEMORYCLERK_XE_BUFFER (Total) KB
---------------------------------------- ----------
VM Reserved 8448
VM Committed 8448
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 0
MultiPage Allocator 0
2014-04-20 22:16:58.75 spid5s
MEMORYCLERK_HOST (node 1) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 128
MultiPage Allocator 64
2014-04-20 22:16:58.75 spid5s
MEMORYCLERK_SOSNODE (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 78704
MultiPage Allocator 16192
2014-04-20 22:16:58.75 spid5s
MEMORYCLERK_SOSNODE (node 1) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 75136
MultiPage Allocator 4624
2014-04-20 22:16:58.75 spid5s
MEMORYCLERK_SOSNODE (node 64) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 8
MultiPage Allocator 2336
2014-04-20 22:16:58.75 spid5s
MEMORYCLERK_SOSNODE (Total) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 153848
MultiPage Allocator 23152
2014-04-20 22:16:58.75 spid5s
MEMORYCLERK_FULLTEXT_SHMEM (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 768
SM Committed 768
SinglePage Allocator 0
MultiPage Allocator 0
2014-04-20 22:16:58.75 spid5s
MEMORYCLERK_SQLSERVICEBROKERTRANSPORT (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 48
MultiPage Allocator 0
2014-04-20 22:16:58.75 spid5s
MEMORYCLERK_XE (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 3936
MultiPage Allocator 1880
2014-04-20 22:16:58.76 spid5s
CACHESTORE_OBJCP (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 520024
MultiPage Allocator 57896
2014-04-20 22:16:58.76 spid5s
CACHESTORE_SQLCP (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 6120312
MultiPage Allocator 214328
2014-04-20 22:16:58.76 spid5s
CACHESTORE_PHDR (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 50880
MultiPage Allocator 56
2014-04-20 22:16:58.76 spid5s
CACHESTORE_XPROC (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 248
MultiPage Allocator 0
2014-04-20 22:16:58.76 spid5s
CACHESTORE_TEMPTABLES (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 88
MultiPage Allocator 0
2014-04-20 22:16:58.76 spid5s
CACHESTORE_NOTIF (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 16
MultiPage Allocator 0
2014-04-20 22:16:58.76 spid5s
CACHESTORE_VIEWDEFINITIONS (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 16
MultiPage Allocator 0
2014-04-20 22:16:58.76 spid5s
CACHESTORE_XMLDBTYPE (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 8
MultiPage Allocator 0
2014-04-20 22:16:58.76 spid5s
CACHESTORE_XMLDBELEMENT (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 8
MultiPage Allocator 0
2014-04-20 22:16:58.76 spid5s
CACHESTORE_XMLDBATTRIBUTE (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 8
MultiPage Allocator 0
2014-04-20 22:16:58.76 spid5s
CACHESTORE_STACKFRAMES (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 0
MultiPage Allocator 8
2014-04-20 22:16:58.76 spid5s
CACHESTORE_STACKFRAMES (node 1) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 0
MultiPage Allocator 8
2014-04-20 22:16:58.76 spid5s
CACHESTORE_STACKFRAMES (node 64) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 0
MultiPage Allocator 8
2014-04-20 22:16:58.76 spid5s
CACHESTORE_STACKFRAMES (Total) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 0
MultiPage Allocator 24
2014-04-20 22:16:58.76 spid5s
CACHESTORE_BROKERTBLACS (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 104
MultiPage Allocator 0
2014-04-20 22:16:58.76 spid5s
CACHESTORE_BROKERTBLACS (node 1) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 384
MultiPage Allocator 0
2014-04-20 22:16:58.76 spid5s
CACHESTORE_BROKERTBLACS (Total) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 488
MultiPage Allocator 0
2014-04-20 22:16:58.76 spid5s
CACHESTORE_BROKERKEK (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 8
MultiPage Allocator 0
2014-04-20 22:16:58.76 spid5s
CACHESTORE_BROKERDSH (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 8
MultiPage Allocator 0
2014-04-20 22:16:58.76 spid5s
CACHESTORE_BROKERUSERCERTLOOKUP (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 8
MultiPage Allocator 0
2014-04-20 22:16:58.76 spid5s
CACHESTORE_BROKERRSB (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 16
MultiPage Allocator 0
2014-04-20 22:16:58.76 spid5s
CACHESTORE_BROKERREADONLY (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 88
MultiPage Allocator 0
2014-04-20 22:16:58.76 spid5s
CACHESTORE_BROKERTO (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 8
MultiPage Allocator 0
2014-04-20 22:16:58.76 spid5s
CACHESTORE_EVENTS (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 16
MultiPage Allocator 0
2014-04-20 22:16:58.76 spid5s
CACHESTORE_SYSTEMROWSET (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 3864
MultiPage Allocator 0
2014-04-20 22:16:58.76 spid5s
CACHESTORE_SYSTEMROWSET (node 1) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 1048
MultiPage Allocator 0
2014-04-20 22:16:58.76 spid5s
CACHESTORE_SYSTEMROWSET (Total) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 4912
MultiPage Allocator 0
2014-04-20 22:16:58.76 spid5s
CACHESTORE_CONVPRI (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 96
MultiPage Allocator 0
2014-04-20 22:16:58.76 spid5s
CACHESTORE_CONVPRI (node 1) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 16
MultiPage Allocator 0
2014-04-20 22:16:58.76 spid5s
CACHESTORE_CONVPRI (Total) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 112
MultiPage Allocator 0
2014-04-20 22:16:58.76 spid5s
CACHESTORE_FULLTEXTSTOPLIST (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 32
MultiPage Allocator 0
2014-04-20 22:16:58.76 spid5s
USERSTORE_SCHEMAMGR (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 157152
MultiPage Allocator 18616
2014-04-20 22:16:58.76 spid5s
USERSTORE_DBMETADATA (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 79256
MultiPage Allocator 0
2014-04-20 22:16:58.76 spid5s
USERSTORE_DBMETADATA (node 1) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 256
MultiPage Allocator 0
2014-04-20 22:16:58.76 spid5s
USERSTORE_DBMETADATA (Total) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 79512
MultiPage Allocator 0
2014-04-20 22:16:58.76 spid5s
USERSTORE_TOKENPERM (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 28576
MultiPage Allocator 24656
2014-04-20 22:16:58.76 spid5s
USERSTORE_TOKENPERM (node 1) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 7192
MultiPage Allocator 0
2014-04-20 22:16:58.76 spid5s
USERSTORE_TOKENPERM (Total) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 35768
MultiPage Allocator 24656
2014-04-20 22:16:58.76 spid5s
USERSTORE_OBJPERM (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 9712
MultiPage Allocator 32
2014-04-20 22:16:58.76 spid5s
USERSTORE_OBJPERM (node 1) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 528
MultiPage Allocator 0
2014-04-20 22:16:58.76 spid5s
USERSTORE_OBJPERM (Total) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 10240
MultiPage Allocator 32
2014-04-20 22:16:58.76 spid5s
USERSTORE_SXC (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 1824
MultiPage Allocator 0
2014-04-20 22:16:58.76 spid5s
USERSTORE_SXC (node 1) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 1616
MultiPage Allocator 0
2014-04-20 22:16:58.76 spid5s
USERSTORE_SXC (node 64) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 8
MultiPage Allocator 0
2014-04-20 22:16:58.76 spid5s
USERSTORE_SXC (Total) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 3448
MultiPage Allocator 0
2014-04-20 22:16:58.76 spid5s
OBJECTSTORE_LBSS (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 256
MultiPage Allocator 560
2014-04-20 22:16:58.76 spid5s
OBJECTSTORE_LBSS (node 1) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 256
MultiPage Allocator 560
2014-04-20 22:16:58.76 spid5s
OBJECTSTORE_LBSS (Total) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 512
MultiPage Allocator 1120
2014-04-20 22:16:58.76 spid5s
OBJECTSTORE_SNI_PACKET (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 23944
MultiPage Allocator 344
2014-04-20 22:16:58.76 spid5s
OBJECTSTORE_SNI_PACKET (node 1) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 23584
MultiPage Allocator 344
2014-04-20 22:16:58.76 spid5s
OBJECTSTORE_SNI_PACKET (node 64) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 0
MultiPage Allocator 56
2014-04-20 22:16:58.76 spid5s
OBJECTSTORE_SNI_PACKET (Total) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 47528
MultiPage Allocator 744
2014-04-20 22:16:58.76 spid5s
OBJECTSTORE_SERVICE_BROKER (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 464
MultiPage Allocator 0
2014-04-20 22:16:58.76 spid5s
OBJECTSTORE_LOCK_MANAGER (node 0) KB
---------------------------------------- ----------
VM Reserved 264192
VM Committed 264192
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 85032
MultiPage Allocator 0
2014-04-20 22:16:58.76 spid5s
OBJECTSTORE_LOCK_MANAGER (node 1) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 31984
MultiPage Allocator 0
2014-04-20 22:16:58.76 spid5s
OBJECTSTORE_LOCK_MANAGER (node 64) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 24
MultiPage Allocator 0
2014-04-20 22:16:58.76 spid5s
OBJECTSTORE_LOCK_MANAGER (Total) KB
---------------------------------------- ----------
VM Reserved 264192
VM Committed 264192
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 117040
MultiPage Allocator 0
2014-04-20 22:16:58.76 spid5s
OBJECTSTORE_SECAUDIT_EVENT_BUFFER (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
SinglePage Allocator 16
MultiPage Allocator 0
2014-04-20 22:17:00.75 spid5s
Buffer Pool Value
---------------------------------------- ----------
Committed 6696960
Target 6696960
Database 5487027
Dirty 37685
In IO 0
Latched 31
Free 0
Stolen 1209933
Reserved 102681
Visible 6696960
Stolen Potential 5049498
Limiting Factor 17
Last OOM Factor 0
Last OS Error 0
Page Life Expectancy 39914
2014-04-20 22:17:00.75 spid5s
Process/System Counts Value
---------------------------------------- ----------
Available Physical Memory 858996736
Available Virtual Memory 8725950836736
Available Paging File 67312414720
Working Set 823902208
Percent of Committed Memory in WS 100
Page Faults 315534734
System physical memory high 1
System physical memory low 0
Process physical memory low 0
Process virtual memory low 0
2014-04-20 22:17:00.79 spid5s
Procedure Cache Value
---------------------------------------- ----------
TotalProcs 60797
TotalPages 870468
InUsePages 3666
2014-04-20 22:17:00.79 spid5s
Global Memory Objects Pages
---------------------------------------- ----------
Resource 2227
Locks 14630
XDES 1153
SETLS 32
SE Dataset Allocators 64
SubpDesc Allocators 36
SE SchemaManager 8016
SE Column Metadata Cache 13954
SQLCache 8098
Replication 2
ServerGlobal 52
XP Global 2
SortTables 2
2014-04-20 22:17:00.79 spid5s
Query Memory Objects (internal) Value
---------------------------------------- ----------
Grants 0
Waiting 0
Available 3918340
Current Max 3918340
Future Max 3918340
Physical Max 5019730
Next Request 0
Waiting For 0
Cost 0
Timeout 0
Wait Time 0
2014-04-20 22:17:00.79 spid5s
Small Query Memory Objects (internal) Value
---------------------------------------- ----------
Grants 0
Waiting 0
Available 12800
Current Max 12800
Future Max 12800
2014-04-20 22:17:00.79 spid5s
Query Memory Objects (default) Value
---------------------------------------- ----------
Grants 66
Waiting 0
Available 4620999
Current Max 5019730
Future Max 5019730
Physical Max 5019730
Next Request 0
Waiting For 0
Cost 0
Timeout 0
Wait Time 0
2014-04-20 22:17:00.79 spid5s
Small Query Memory Objects (default) Value
---------------------------------------- ----------
Grants 0
Waiting 0
Available 12800
Current Max 12800
Future Max 12800
2014-04-20 22:17:00.79 spid5s
Optimization Queue (internal) Value
---------------------------------------- ----------
Overall Memory 43974918144
Target Memory 34383806464
Last Notification 1
Timeout 6
Early Termination Factor 5
2014-04-20 22:17:00.79 spid5s
Small Gateway (internal) Value
---------------------------------------- ----------
Configured Units 128
Available Units 128
Acquires 0
Waiters 0
Threshold Factor 380000
Threshold 380000
2014-04-20 22:17:00.79 spid5s
Medium Gateway (internal) Value
---------------------------------------- ----------
Configured Units 32
Available Units 32
Acquires 0
Waiters 0
Threshold Factor 12
Threshold -1
2014-04-20 22:17:00.79 spid5s
Big Gateway (internal) Value
---------------------------------------- ----------
Configured Units 1
Available Units 1
Acquires 0
Waiters 0
Threshold Factor 8
Threshold -1
2014-04-20 22:17:00.79 spid5s
Optimization Queue (default) Value
---------------------------------------- ----------
Overall Memory 43974918144
Target Memory 34493251584
Last Notification 1
Timeout 6
Early Termination Factor 5
2014-04-20 22:17:00.79 spid5s
Small Gateway (default) Value
---------------------------------------- ----------
Configured Units 128
Available Units 127
Acquires 1
Waiters 0
Threshold Factor 380000
Threshold 380000
2014-04-20 22:17:00.79 spid5s
Medium Gateway (default) Value
---------------------------------------- ----------
Configured Units 32
Available Units 32
Acquires 0
Waiters 0
Threshold Factor 12
Threshold 2874437632
2014-04-20 22:17:00.79 spid5s
Big Gateway (default) Value
---------------------------------------- ----------
Configured Units 1
Available Units 1
Acquires 0
Waiters 0
Threshold Factor 8
Threshold -1
2014-04-20 22:17:00.79 spid5s
Memory Pool Manager Pages
---------------------------------------- ----------
Reserved Current 398731
Reserved Limit 5448155
2014-04-20 22:17:00.79 spid5s
Memory Pool (internal) Pages
---------------------------------------- ----------
Allocations 13689
Predicted 13689
Private Target 0
Private Limit 0
Total Target 6362112
Total Limit 6362112
OOM Count 0
2014-04-20 22:17:00.79 spid5s
MEMORYBROKER_FOR_CACHE (internal) Pages
---------------------------------------- ----------
Allocations 9670
Rate 0
Target Allocations 4202893
Future Allocations 0
Overall 5368032
Last Notification 1
2014-04-20 22:17:00.79 spid5s
MEMORYBROKER_FOR_STEAL (internal) Pages
---------------------------------------- ----------
Allocations 4019
Rate 0
Target Allocations 4197242
Future Allocations 0
Overall 5368032
Last Notification 1
2014-04-20 22:17:00.79 spid5s
MEMORYBROKER_FOR_RESERVE (internal) Pages
---------------------------------------- ----------
Allocations 0
Rate 0
Target Allocations 4193223
Future Allocations 0
Overall 5368032
Last Notification 1
2014-04-20 22:17:00.79 spid5s
Memory Pool (default) Pages
---------------------------------------- ----------
Allocations 1298999
Predicted 2155200
Private Target 0
Private Limit 0
Total Target 6362112
Total Limit 6362112
OOM Count 0
2014-04-20 22:17:00.80 spid5s
MEMORYBROKER_FOR_CACHE (default) Pages
---------------------------------------- ----------
Allocations 882889
Rate 0
Target Allocations 5076112
Future Allocations 0
Overall 5368032
Last Notification 1
2014-04-20 22:17:00.80 spid5s
MEMORYBROKER_FOR_STEAL (default) Pages
---------------------------------------- ----------
Allocations 17379
Rate 0
Target Allocations 4210602
Future Allocations 0
Overall 5368032
Last Notification 1
2014-04-20 22:17:00.80 spid5s
MEMORYBROKER_FOR_RESERVE (default) Pages
---------------------------------------- ----------
Allocations 398731
Rate 0
Target Allocations 5368032
Future Allocations 1254932
Overall 5368032
Last Notification 1
2014-04-20 22:18:07.79 Server Using 'dbghelp.dll' version '4.0.5'
2014-04-20 22:18:07.84 Server **Dump thread - spid = 0, EC = 0x0000000000000000
2014-04-20 22:18:07.84 Server ***Stack Dump being sent to E:\MSSQL10.MSSQLSERVER\MSSQL\LOG\SQLDump0004.txt
2014-04-20 22:18:07.84 Server * *******************************************************************************
2014-04-20 22:18:07.84 Server *
2014-04-20 22:18:07.84 Server * BEGIN STACK DUMP:
2014-04-20 22:18:07.84 Server * 04/20/14 22:18:07 spid 8492
2014-04-20 22:18:07.84 Server *
2014-04-20 22:18:07.84 Server * Non-yielding IOCP Listener
2014-04-20 22:18:07.84 Server *
2014-04-20 22:18:07.84 Server * *******************************************************************************
2014-04-20 22:18:07.84 Server * -------------------------------------------------------------------------------
2014-04-20 22:18:07.84 Server * Short Stack Dump
2014-04-20 22:18:07.90 Server Stack Signature for the dump is 0x000000000000028D
2014-04-20 22:18:14.84 Server External dump process return code 0x20000001.
External dump process returned no errors.
Post #1563751
Posted Tuesday, April 22, 2014 5:38 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Yesterday @ 4:54 PM
Points: 42,434, Visits: 35,488
Nice error log. And???

Perhaps some background, some details, a question, maybe a please or thank you?



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1563788
Posted Tuesday, April 22, 2014 6:22 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, July 18, 2014 6:10 AM
Points: 10, Visits: 228
Sorry about that. Was in a rush.


SQL Server 2008 R2 Enterprise Edition SP2
32 processors
MaxDOP = 8
Cost threshold of parallelism = 5
Max Server memory: 52320
2 node active passive cluster

I want to know whether its a problem with parallelism or IO issue or memory starvation during the time of the incident and how to avoid this in future.

Thanks,
San


Post #1563805
Posted Tuesday, April 22, 2014 6:58 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Yesterday @ 4:54 PM
Points: 42,434, Visits: 35,488
I get the rush, but please remember we're all volunteers here.

With just part of the error log, really hard to answer, but the stack dump is a hint
Non-yielding IOCP Listener

IOCP being IO-related, so looks like the problem may be in that area.

If it happens again it may be worth calling product support and opening a support case.



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1563829
Posted Tuesday, April 22, 2014 7:02 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 8:41 AM
Points: 15,516, Visits: 27,892
I'd say you have a critical I/O issue, but it looks like there are other things at play in there as well. The I/O issues start at 0200 and run throughout. The other issues don't start until later according to the timestamps. They may or may not be related, but I'd start with one at a time. Something is up with your I/O subsystem to get that many errors.

----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1563831
Posted Tuesday, April 22, 2014 7:13 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, July 18, 2014 6:10 AM
Points: 10, Visits: 228
Thanks Gail & Grant for the reply. I've been asked to raise a case with Microsoft to identify the root cause.

Thanks,
San
Post #1563837
Posted Wednesday, April 23, 2014 5:13 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Friday, July 18, 2014 11:32 AM
Points: 709, Visits: 1,410
Have you looked at your storage? Seems many symptoms are pointing there. Are you using a SAN? If so I would get with your SAN admins and have them tell you what they see on their side.

Joie Andrew
"Since 1982"
Post #1564204
Posted Wednesday, April 23, 2014 5:24 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 8:08 AM
Points: 6,162, Visits: 13,305
are you using shared storage?

in one scenario previously, i had a set of LUNs presented to server A and it turned out they shared storage pools with another server B. Whenever the admin ran parallel backups or restores of the huge databases on server B, server A used to have similar problems to what you're seeing, in fact in some cases the LUNs would disappear and the SQL instance would go offline.


-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1564209
Posted Wednesday, April 23, 2014 6:12 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 2:56 AM
Points: 2,603, Visits: 2,061
All tempdb files are on T: drive and guess it is on cluster using SAN. Hence it will not distribute the load of I/O as LUNs are of same group. Looks like issue is with I/O. Get help of your storage team to verify.

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
Post #1564218
Posted Wednesday, April 23, 2014 6:50 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Yesterday @ 4:54 PM
Points: 42,434, Visits: 35,488
Perry Whittle (4/23/2014)
in one scenario previously, i had a set of LUNs presented to server A and it turned out they shared storage pools with another server B. Whenever the admin ran parallel backups or restores of the huge databases on server B, server A used to have similar problems to what you're seeing, in fact in some cases the LUNs would disappear and the SQL instance would go offline.


I've seen a similar thing, the LUNs were dedicated but the fiber switch was shared with a data warehouse. One day the data warehouse ran a complete reload of all data and our production server keeled over and died.



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1564235
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse