SQL Server 2008 R2 in hung state. Need help in analyzing the log.

  • 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.

  • Nice error log. And???

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

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    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
  • 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

  • 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, MVP, M.Sc (Comp Sci)
    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
  • 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

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • Thanks Gail & Grant for the reply. I've been asked to raise a case with Microsoft to identify the root cause.

    Thanks,

    San

  • 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"

  • 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" 😉

  • 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."

  • 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, MVP, M.Sc (Comp Sci)
    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

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply