TheBugSlayer
Programmer
On our SQL Server 2005 SP2 Standard Edition we are having memory-related issues. Below are some of the error messages from the log, containing 'memory'. I have read a few articles so far but have not figured a definite solution. Under pressure we had to restart the server yesterday to buy me some time...The errors are self-explanatory. What is the best way to solve the issue?
MCP SQL Server 2000, MCTS SQL Server 2005, MCTS SQL Server 2008 (DBD, DBA)
I appreciate any help.SQL Server Error Log said:LogDate ProcessInfo Text
2013-03-25 17:42:12.060 Server Set AWE Enabled to 1 in the configuration parameters to allow use of more memory.
1
2013-01-02 19:09:09.460 Server Set AWE Enabled to 1 in the configuration parameters to allow use of more memory.
2013-02-22 10:06:47.760 spid1s A significant part of sql server process memory has been paged out. This may result in a performance degradation. Duration: 0 seconds. Working set (KB): 4312, committed (KB): 1728008, memory utilization: 0%.
2013-02-25 08:14:53.230 spid1s A significant part of sql server process memory has been paged out. This may result in a performance degradation. Duration: 0 seconds. Working set (KB): 5060, committed (KB): 1726880, memory utilization: 0%.
2013-02-25 11:38:19.010 spid1s A significant part of sql server process memory has been paged out. This may result in a performance degradation. Duration: 0 seconds. Working set (KB): 6108, committed (KB): 1728840, memory utilization: 0%.
2013-03-25 16:31:54.560 spid1s A significant part of sql server process memory has been paged out. This may result in a performance degradation. Duration: 0 seconds. Working set (KB): 6760, committed (KB): 1744480, memory utilization: 0%.
2013-03-25 16:34:47.870 Server Resource Monitor (0x32a0) Worker 0x03D5C0E8 appears to be non-yielding on Node 0. Memory freed: 4624 KB. Approx CPU Used: kernel 0 ms, user 46 ms, Interval: 60000.
2013-03-25 16:35:47.900 Server Resource Monitor (0x32a0) Worker 0x03D5C0E8 appears to be non-yielding on Node 0. Memory freed: 14104 KB. Approx CPU Used: kernel 46 ms, user 78 ms, Interval: 174017.
2013-03-25 16:36:48.010 Server Resource Monitor (0x32a0) Worker 0x03D5C0E8 appears to be non-yielding on Node 0. Memory freed: 23800 KB. Approx CPU Used: kernel 109 ms, user 93 ms, Interval: 234143.
2013-03-25 16:37:48.010 Server Resource Monitor (0x32a0) Worker 0x03D5C0E8 appears to be non-yielding on Node 0. Memory freed: 35760 KB. Approx CPU Used: kernel 140 ms, user 93 ms, Interval: 294144.
2013-03-25 16:38:48.020 Server Resource Monitor (0x32a0) Worker 0x03D5C0E8 appears to be non-yielding on Node 0. Memory freed: 46536 KB. Approx CPU Used: kernel 187 ms, user 109 ms, Interval: 354145.
2013-03-25 16:39:48.240 Server Resource Monitor (0x32a0) Worker 0x03D5C0E8 appears to be non-yielding on Node 0. Memory freed: 57392 KB. Approx CPU Used: kernel 203 ms, user 187 ms, Interval: 414145.
2013-03-25 16:41:13.250 Server Resource Monitor (0x32a0) Worker 0x03D5C0E8 appears to be non-yielding on Node 0. Memory freed: 77928 KB. Approx CPU Used: kernel 62 ms, user 0 ms, Interval: 60000.
2013-03-25 16:42:13.250 Server Resource Monitor (0x32a0) Worker 0x03D5C0E8 appears to be non-yielding on Node 0. Memory freed: 87176 KB. Approx CPU Used: kernel 78 ms, user 46 ms, Interval: 120017.
2013-03-25 16:43:13.270 Server Resource Monitor (0x32a0) Worker 0x03D5C0E8 appears to be non-yielding on Node 0. Memory freed: 94784 KB. Approx CPU Used: kernel 109 ms, user 62 ms, Interval: 180017.
2013-03-25 16:45:13.260 Server Resource Monitor (0x32a0) Worker 0x03D5C0E8 appears to be non-yielding on Node 0. Memory freed: 118744 KB. Approx CPU Used: kernel 46 ms, user 31 ms, Interval: 60000.
2013-03-25 16:46:13.270 Server Resource Monitor (0x32a0) Worker 0x03D5C0E8 appears to be non-yielding on Node 0. Memory freed: 128880 KB. Approx CPU Used: kernel 78 ms, user 46 ms, Interval: 120001.
2013-03-25 16:47:13.260 Server Resource Monitor (0x32a0) Worker 0x03D5C0E8 appears to be non-yielding on Node 0. Memory freed: 136704 KB. Approx CPU Used: kernel 109 ms, user 62 ms, Interval: 180002.
2013-03-25 16:48:13.260 Server Resource Monitor (0x32a0) Worker 0x03D5C0E8 appears to be non-yielding on Node 0. Memory freed: 142424 KB. Approx CPU Used: kernel 109 ms, user 62 ms, Interval: 240003.
2013-03-25 16:49:13.270 Server Resource Monitor (0x32a0) Worker 0x03D5C0E8 appears to be non-yielding on Node 0. Memory freed: 149168 KB. Approx CPU Used: kernel 156 ms, user 78 ms, Interval: 300003.
2013-03-25 16:50:13.260 Server Resource Monitor (0x32a0) Worker 0x03D5C0E8 appears to be non-yielding on Node 0. Memory freed: 156488 KB. Approx CPU Used: kernel 156 ms, user 78 ms, Interval: 360004.
2013-03-25 16:51:13.270 Server Resource Monitor (0x32a0) Worker 0x03D5C0E8 appears to be non-yielding on Node 0. Memory freed: 163016 KB. Approx CPU Used: kernel 171 ms, user 78 ms, Interval: 420005.
2013-03-25 16:52:13.270 Server Resource Monitor (0x32a0) Worker 0x03D5C0E8 appears to be non-yielding on Node 0. Memory freed: 168368 KB. Approx CPU Used: kernel 187 ms, user 78 ms, Interval: 480006.
2013-03-25 16:53:13.270 Server Resource Monitor (0x32a0) Worker 0x03D5C0E8 appears to be non-yielding on Node 0. Memory freed: 175208 KB. Approx CPU Used: kernel 250 ms, user 109 ms, Interval: 540006.
2013-03-25 16:54:13.290 Server Resource Monitor (0x32a0) Worker 0x03D5C0E8 appears to be non-yielding on Node 0. Memory freed: 179768 KB. Approx CPU Used: kernel 265 ms, user 109 ms, Interval: 600007.
2013-03-25 16:55:13.290 Server Resource Monitor (0x32a0) Worker 0x03D5C0E8 appears to be non-yielding on Node 0. Memory freed: 183680 KB. Approx CPU Used: kernel 281 ms, user 109 ms, Interval: 660024.
2013-03-25 16:56:13.290 Server Resource Monitor (0x32a0) Worker 0x03D5C0E8 appears to be non-yielding on Node 0. Memory freed: 190560 KB. Approx CPU Used: kernel 281 ms, user 125 ms, Interval: 720024.
2013-03-25 16:57:13.300 Server Resource Monitor (0x32a0) Worker 0x03D5C0E8 appears to be non-yielding on Node 0. Memory freed: 194712 KB. Approx CPU Used: kernel 296 ms, user 125 ms, Interval: 780025.
2013-03-25 16:58:13.290 Server Resource Monitor (0x32a0) Worker 0x03D5C0E8 appears to be non-yielding on Node 0. Memory freed: 199728 KB. Approx CPU Used: kernel 312 ms, user 156 ms, Interval: 840026.
2013-03-25 16:59:13.290 Server Resource Monitor (0x32a0) Worker 0x03D5C0E8 appears to be non-yielding on Node 0. Memory freed: 204904 KB. Approx CPU Used: kernel 328 ms, user 187 ms, Interval: 900027.
2013-03-25 17:00:13.300 Server Resource Monitor (0x32a0) Worker 0x03D5C0E8 appears to be non-yielding on Node 0. Memory freed: 215368 KB. Approx CPU Used: kernel 343 ms, user 187 ms, Interval: 960027.
2013-03-25 17:01:13.290 Server Resource Monitor (0x32a0) Worker 0x03D5C0E8 appears to be non-yielding on Node 0. Memory freed: 224144 KB. Approx CPU Used: kernel 375 ms, user 203 ms, Interval: 1020028.
2013-03-25 17:02:13.300 Server Resource Monitor (0x32a0) Worker 0x03D5C0E8 appears to be non-yielding on Node 0. Memory freed: 230368 KB. Approx CPU Used: kernel 390 ms, user 203 ms, Interval: 1080029.
2013-03-25 17:03:13.370 Server Resource Monitor (0x32a0) Worker 0x03D5C0E8 appears to be non-yielding on Node 0. Memory freed: 234968 KB. Approx CPU Used: kernel 390 ms, user 203 ms, Interval: 1140030.
2013-03-25 17:04:13.370 Server Resource Monitor (0x32a0) Worker 0x03D5C0E8 appears to be non-yielding on Node 0. Memory freed: 240392 KB. Approx CPU Used: kernel 421 ms, user 203 ms, Interval: 1200109.
2013-03-25 17:05:13.370 Server Resource Monitor (0x32a0) Worker 0x03D5C0E8 appears to be non-yielding on Node 0. Memory freed: 243640 KB. Approx CPU Used: kernel 468 ms, user 203 ms, Interval: 1260109.
2013-03-25 17:06:13.370 Server Resource Monitor (0x32a0) Worker 0x03D5C0E8 appears to be non-yielding on Node 0. Memory freed: 246920 KB. Approx CPU Used: kernel 500 ms, user 218 ms, Interval: 1320110.
2013-03-25 17:07:13.370 Server Resource Monitor (0x32a0) Worker 0x03D5C0E8 appears to be non-yielding on Node 0. Memory freed: 252120 KB. Approx CPU Used: kernel 515 ms, user 234 ms, Interval: 1380111.
2013-03-25 17:08:13.380 Server Resource Monitor (0x32a0) Worker 0x03D5C0E8 appears to be non-yielding on Node 0. Memory freed: 257888 KB. Approx CPU Used: kernel 515 ms, user 250 ms, Interval: 1440112.
2013-03-25 17:09:13.380 Server Resource Monitor (0x32a0) Worker 0x03D5C0E8 appears to be non-yielding on Node 0. Memory freed: 262616 KB. Approx CPU Used: kernel 562 ms, user 250 ms, Interval: 1500112.
2013-03-25 17:10:13.380 Server Resource Monitor (0x32a0) Worker 0x03D5C0E8 appears to be non-yielding on Node 0. Memory freed: 268536 KB. Approx CPU Used: kernel 593 ms, user 281 ms, Interval: 1560113.
2013-03-25 17:11:13.370 Server Resource Monitor (0x32a0) Worker 0x03D5C0E8 appears to be non-yielding on Node 0. Memory freed: 275512 KB. Approx CPU Used: kernel 625 ms, user 281 ms, Interval: 1620114.
2013-03-25 17:12:13.370 Server Resource Monitor (0x32a0) Worker 0x03D5C0E8 appears to be non-yielding on Node 0. Memory freed: 288136 KB. Approx CPU Used: kernel 656 ms, user 296 ms, Interval: 1680115.
2013-03-25 17:16:03.380 Server Resource Monitor (0x32a0) Worker 0x03D5C0E8 appears to be non-yielding on Node 0. Memory freed: 371952 KB. Approx CPU Used: kernel 0 ms, user 15 ms, Interval: 60000.
2013-03-25 17:17:03.380 Server Resource Monitor (0x32a0) Worker 0x03D5C0E8 appears to be non-yielding on Node 0. Memory freed: 379424 KB. Approx CPU Used: kernel 31 ms, user 31 ms, Interval: 120001.
2013-03-25 17:18:13.380 Server Resource Monitor (0x32a0) Worker 0x03D5C0E8 appears to be non-yielding on Node 0. Memory freed: 11336 KB. Approx CPU Used: kernel 31 ms, user 31 ms, Interval: 60000.
2013-03-25 17:18:22.050 spid167 There is insufficient system memory to run this query.
2013-03-25 17:18:22.050 spid51 There is insufficient system memory to run this query.
2013-03-25 17:18:22.050 spid131 There is insufficient system memory to run this query.
2013-03-25 17:18:22.050 spid244 There is insufficient system memory to run this query.
2013-03-25 17:18:22.050 spid103 There is insufficient system memory to run this query.
2013-03-25 17:18:22.050 spid281 There is insufficient system memory to run this query.
2013-03-25 17:18:22.050 spid120 There is insufficient system memory to run this query.
2013-03-25 17:18:22.050 spid53 There is insufficient system memory to run this query.
2013-03-25 17:18:22.060 spid96 There is insufficient system memory to run this query.
2013-03-25 17:18:22.070 spid222 There is insufficient system memory to run this query.
2013-03-25 17:18:22.070 spid205 There is insufficient system memory to run this query.
2013-03-25 17:18:22.070 spid158 There is insufficient system memory to run this query.
2013-03-25 17:18:22.070 spid190 There is insufficient system memory to run this query.
2013-03-25 17:18:22.100 spid316 Memory Manager VM Reserved = 1760136 KB VM Committed = 1756568 KB AWE Allocated = 0 KB Reserved Memory = 1024 KB Reserved Memory In Use = 0 KB
2013-03-25 17:18:22.100 spid316 Memory node Id = 0 VM Reserved = 1755976 KB VM Committed = 1752560 KB AWE Allocated = 0 KB SinglePage Allocator = 1507680 KB MultiPage Allocator = 66288 KB
2013-03-25 17:18:22.100 spid316 MEMORYCLERK_SQLGENERAL (Total) VM Reserved = 0 KB VM Committed = 0 KB AWE Allocated = 0 KB SM Reserved = 0 KB SM Committed = 0 KB SinglePage Allocator = 17584 KB MultiPage Allocator = 4600 KB
2013-03-25 17:18:22.100 spid316 MEMORYCLERK_SQLBUFFERPOOL (Total) VM Reserved = 1654624 KB VM Committed = 1654624 KB AWE Allocated = 0 KB SM Reserved = 0 KB SM Committed = 0 KB SinglePage Allocator = 0 KB MultiPage Allocator = 400 KB
2013-03-25 17:18:22.100 spid316 MEMORYCLERK_SQLQUERYEXEC (Total) VM Reserved = 0 KB VM Committed = 0 KB AWE Allocated = 0 KB SM Reserved = 0 KB SM Committed = 0 KB SinglePage Allocator = 1368 KB MultiPage Allocator = 0 KB
2013-03-25 17:18:22.100 spid316 MEMORYCLERK_SQLOPTIMIZER (Total) VM Reserved = 0 KB VM Committed = 0 KB AWE Allocated = 0 KB SM Reserved = 0 KB SM Committed = 0 KB SinglePage Allocator = 5008 KB MultiPage Allocator = 72 KB
2013-03-25 17:18:22.100 spid316 MEMORYCLERK_SQLUTILITIES (Total) VM Reserved = 360 KB VM Committed = 360 KB AWE Allocated = 0 KB SM Reserved = 0 KB SM Committed = 0 KB SinglePage Allocator = 1120 KB MultiPage Allocator = 0 KB
2013-03-25 17:18:22.100 spid316 MEMORYCLERK_SQLSTORENG (Total) VM Reserved = 20928 KB VM Committed = 20928 KB AWE Allocated = 0 KB SM Reserved = 0 KB SM Committed = 0 KB SinglePage Allocator = 12992 KB MultiPage Allocator = 12440 KB
2013-03-25 17:18:22.100 spid316 MEMORYCLERK_SQLCONNECTIONPOOL (Total) VM Reserved = 0 KB VM Committed = 0 KB AWE Allocated = 0 KB SM Reserved = 0 KB SM Committed = 0 KB SinglePage Allocator = 3744 KB MultiPage Allocator = 0 KB
2013-03-25 17:18:22.100 spid316 MEMORYCLERK_SQLCLR (Total) VM Reserved = 0 KB VM Committed = 0 KB AWE Allocated = 0 KB SM Reserved = 0 KB SM Committed = 0 KB SinglePage Allocator = 8 KB MultiPage Allocator = 0 KB
2013-03-25 17:18:22.100 spid316 MEMORYCLERK_SQLSERVICEBROKER (Total) VM Reserved = 0 KB VM Committed = 0 KB AWE Allocated = 0 KB SM Reserved = 0 KB SM Committed = 0 KB SinglePage Allocator = 264 KB MultiPage Allocator = 192 KB
2013-03-25 17:18:22.100 spid316 MEMORYCLERK_SQLHTTP (Total) VM Reserved = 0 KB VM Committed = 0 KB AWE Allocated = 0 KB SM Reserved = 0 KB SM Committed = 0 KB SinglePage Allocator = 8 KB MultiPage Allocator = 0 KB
2013-03-25 17:18:22.100 spid316 MEMORYCLERK_SNI (Total) VM Reserved = 0 KB VM Committed = 0 KB AWE Allocated = 0 KB SM Reserved = 0 KB SM Committed = 0 KB SinglePage Allocator = 512 KB MultiPage Allocator = 16 KB
2013-03-25 17:18:22.100 spid316 MEMORYCLERK_FULLTEXT (Total) VM Reserved = 0 KB VM Committed = 0 KB AWE Allocated = 0 KB SM Reserved = 0 KB SM Committed = 0 KB SinglePage Allocator = 56 KB MultiPage Allocator = 0 KB
2013-03-25 17:18:22.100 spid316 MEMORYCLERK_SQLXP (Total) VM Reserved = 0 KB VM Committed = 0 KB AWE Allocated = 0 KB SM Reserved = 0 KB SM Committed = 0 KB SinglePage Allocator = 16 KB MultiPage Allocator = 0 KB
2013-03-25 17:18:22.100 spid316 MEMORYCLERK_BHF (Total) VM Reserved = 0 KB VM Committed = 0 KB AWE Allocated = 0 KB SM Reserved = 0 KB SM Committed = 0 KB SinglePage Allocator = 240 KB MultiPage Allocator = 0 KB
2013-03-25 17:18:22.100 spid316 MEMORYCLERK_SQLQERESERVATIONS (Total) VM Reserved = 0 KB VM Committed = 0 KB AWE Allocated = 0 KB SM Reserved = 0 KB SM Committed = 0 KB SinglePage Allocator = 35896 KB MultiPage Allocator = 0 KB
2013-03-25 17:18:22.100 spid316 MEMORYCLERK_HOST (Total) VM Reserved = 0 KB VM Committed = 0 KB AWE Allocated = 0 KB SM Reserved = 0 KB SM Committed = 0 KB SinglePage Allocator = 72 KB MultiPage Allocator = 64 KB
2013-03-25 17:18:22.100 spid316 MEMORYCLERK_SOSNODE (Total) VM Reserved = 0 KB VM Committed = 0 KB AWE Allocated = 0 KB SM Reserved = 0 KB SM Committed = 0 KB SinglePage Allocator = 32256 KB MultiPage Allocator = 6736 KB
2013-03-25 17:18:22.100 spid316 MEMORYCLERK_FULLTEXT_SHMEM (Total) VM Reserved = 0 KB VM Committed = 0 KB AWE Allocated = 0 KB SM Reserved = 256 KB SM Committed = 256 KB SinglePage Allocator = 0 KB MultiPage Allocator = 0 KB
2013-03-25 17:18:22.100 spid316 MEMORYCLERK_SQLSERVICEBROKERTRANSPORT (Total) VM Reserved = 0 KB VM Committed = 0 KB AWE Allocated = 0 KB SM Reserved = 0 KB SM Committed = 0 KB SinglePage Allocator = 24 KB MultiPage Allocator = 0 KB
2013-03-25 17:18:22.140 spid316 Process physical/virtual memory pressure: 1/0 System physical memory pressure: 0
2013-03-25 17:18:22.150 spid212 Memory Manager VM Reserved = 1760136 KB VM Committed = 1756568 KB AWE Allocated = 0 KB Reserved Memory = 1024 KB Reserved Memory In Use = 0 KB
2013-03-25 17:18:22.150 spid212 Memory node Id = 0 VM Reserved = 1755976 KB VM Committed = 1752560 KB AWE Allocated = 0 KB SinglePage Allocator = 1507672 KB MultiPage Allocator = 66288 KB
2013-03-25 17:18:22.150 spid212 MEMORYCLERK_SQLGENERAL (Total) VM Reserved = 0 KB VM Committed = 0 KB AWE Allocated = 0 KB SM Reserved = 0 KB SM Committed = 0 KB SinglePage Allocator = 17584 KB MultiPage Allocator = 4600 KB
2013-03-25 17:18:22.150 spid212 MEMORYCLERK_SQLBUFFERPOOL (Total) VM Reserved = 1654624 KB VM Committed = 1654624 KB AWE Allocated = 0 KB SM Reserved = 0 KB SM Committed = 0 KB SinglePage Allocator = 0 KB MultiPage Allocator = 400 KB
2013-03-25 17:18:22.150 spid212 MEMORYCLERK_SQLQUERYEXEC (Total) VM Reserved = 0 KB VM Committed = 0 KB AWE Allocated = 0 KB SM Reserved = 0 KB SM Committed = 0 KB SinglePage Allocator = 1368 KB MultiPage Allocator = 0 KB
2013-03-25 17:18:22.150 spid212 MEMORYCLERK_SQLOPTIMIZER (Total) VM Reserved = 0 KB VM Committed = 0 KB AWE Allocated = 0 KB SM Reserved = 0 KB SM Committed = 0 KB SinglePage Allocator = 5016 KB MultiPage Allocator = 72 KB
2013-03-25 17:18:22.150 spid212 MEMORYCLERK_SQLUTILITIES (Total) VM Reserved = 360 KB VM Committed = 360 KB AWE Allocated = 0 KB SM Reserved = 0 KB SM Committed = 0 KB SinglePage Allocator = 1120 KB MultiPage Allocator = 0 KB
2013-03-25 17:18:22.150 spid212 MEMORYCLERK_SQLSTORENG (Total) VM Reserved = 20928 KB VM Committed = 20928 KB AWE Allocated = 0 KB SM Reserved = 0 KB SM Committed = 0 KB SinglePage Allocator = 12992 KB MultiPage Allocator = 12440 KB
2013-03-25 17:18:22.150 spid212 MEMORYCLERK_SQLCONNECTIONPOOL (Total) VM Reserved = 0 KB VM Committed = 0 KB AWE Allocated = 0 KB SM Reserved = 0 KB SM Committed = 0 KB SinglePage Allocator = 3744 KB MultiPage Allocator = 0 KB
2013-03-25 17:18:22.150 spid212 MEMORYCLERK_SQLCLR (Total) VM Reserved = 0 KB VM Committed = 0 KB AWE Allocated = 0 KB SM Reserved = 0 KB SM Committed = 0 KB SinglePage Allocator = 8 KB MultiPage Allocator = 0 KB
2013-03-25 17:18:22.150 spid212 MEMORYCLERK_SQLSERVICEBROKER (Total) VM Reserved = 0 KB VM Committed = 0 KB AWE Allocated = 0 KB SM Reserved = 0 KB SM Committed = 0 KB SinglePage Allocator = 264 KB MultiPage Allocator = 192 KB
2013-03-25 17:18:22.150 spid212 MEMORYCLERK_SQLHTTP (Total) VM Reserved = 0 KB VM Committed = 0 KB AWE Allocated = 0 KB SM Reserved = 0 KB SM Committed = 0 KB SinglePage Allocator = 8 KB MultiPage Allocator = 0 KB
2013-03-25 17:18:22.150 spid212 MEMORYCLERK_SNI (Total) VM Reserved = 0 KB VM Committed = 0 KB AWE Allocated = 0 KB SM Reserved = 0 KB SM Committed = 0 KB SinglePage Allocator = 512 KB MultiPage Allocator = 16 KB
2013-03-25 17:18:22.150 spid212 MEMORYCLERK_FULLTEXT (Total) VM Reserved = 0 KB VM Committed = 0 KB AWE Allocated = 0 KB SM Reserved = 0 KB SM Committed = 0 KB SinglePage Allocator = 56 KB MultiPage Allocator = 0 KB
2013-03-25 17:18:22.150 spid212 MEMORYCLERK_SQLXP (Total) VM Reserved = 0 KB VM Committed = 0 KB AWE Allocated = 0 KB SM Reserved = 0 KB SM Committed = 0 KB SinglePage Allocator = 16 KB MultiPage Allocator = 0 KB
2013-03-25 17:18:22.150 spid212 MEMORYCLERK_BHF (Total) VM Reserved = 0 KB VM Committed = 0 KB AWE Allocated = 0 KB SM Reserved = 0 KB SM Committed = 0 KB SinglePage Allocator = 216 KB MultiPage Allocator = 0 KB
2013-03-25 17:18:22.150 spid212 MEMORYCLERK_SQLQERESERVATIONS (Total) VM Reserved = 0 KB VM Committed = 0 KB AWE Allocated = 0 KB SM Reserved = 0 KB SM Committed = 0 KB SinglePage Allocator = 35896 KB MultiPage Allocator = 0 KB
2013-03-25 17:18:22.150 spid212 MEMORYCLERK_HOST (Total) VM Reserved = 0 KB VM Committed = 0 KB AWE Allocated = 0 KB SM Reserved = 0 KB SM Committed = 0 KB SinglePage Allocator = 72 KB MultiPage Allocator = 64 KB
2013-03-25 17:18:22.150 spid212 MEMORYCLERK_SOSNODE (Total) VM Reserved = 0 KB VM Committed = 0 KB AWE Allocated = 0 KB SM Reserved = 0 KB SM Committed = 0 KB SinglePage Allocator = 32256 KB MultiPage Allocator = 6736 KB
2013-03-25 17:18:22.150 spid212 MEMORYCLERK_FULLTEXT_SHMEM (Total) VM Reserved = 0 KB VM Committed = 0 KB AWE Allocated = 0 KB SM Reserved = 256 KB SM Committed = 256 KB SinglePage Allocator = 0 KB MultiPage Allocator = 0 KB
2013-03-25 17:18:22.150 spid212 MEMORYCLERK_SQLSERVICEBROKERTRANSPORT (Total) VM Reserved = 0 KB VM Committed = 0 KB AWE Allocated = 0 KB SM Reserved = 0 KB SM Committed = 0 KB SinglePage Allocator = 24 KB MultiPage Allocator = 0 KB
2013-03-25 17:18:22.150 spid212 Process physical/virtual memory pressure: 1/0 System physical memory pressure: 0
2013-03-25 17:18:22.320 spid316 Global Memory Objects: Resource= 957 Locks= 382 SE Schema Mgr= 2121 SQLCache= 1126 Replication= 2 ServerGlobal= 28 XPGlobal= 2 Xact= 158 SETLS= 4 DatasetMemObjs= 8 SubpDescPmos= 4 SortTables= 1523
2013-03-25 17:18:22.320 spid212 Global Memory Objects: Resource= 957 Locks= 382 SE Schema Mgr= 2121 SQLCache= 1126 Replication= 2 ServerGlobal= 28 XPGlobal= 2 Xact= 158 SETLS= 4 DatasetMemObjs= 8 SubpDescPmos= 4 SortTables= 1523
2013-03-25 17:18:22.320 spid316 Query Memory Objects: Grants=1 Waiting=0 Maximum=8975 Available=4488 Limit=8975
2013-03-25 17:18:22.320 spid212 Query Memory Objects: Grants=1 Waiting=0 Maximum=8975 Available=4488 Limit=8975
2013-03-25 17:18:22.320 spid316 Query Memory Objects: Next Request=0 Waiting For=0 Cost=0 Timeout=0 Wait Time=0 Last Target=9615
2013-03-25 17:18:22.320 spid212 Query Memory Objects: Next Request=0 Waiting For=0 Cost=0 Timeout=0 Wait Time=0 Last Target=9615
2013-03-25 17:18:22.320 spid316 Small Query Memory Objects: Grants=0 Waiting=0 Maximum=640 Available=640 Limit=640
2013-03-25 17:18:22.320 spid212 Small Query Memory Objects: Grants=0 Waiting=0 Maximum=640 Available=640 Limit=640
2013-03-25 17:18:22.320 spid316 Optimization Queue Overall Memory = 1344798720 Target Memory = 84049920 Last Notification = STABLE Timeout = 6 Early Termination Factor = 5
2013-03-25 17:18:22.320 spid212 Optimization Queue Overall Memory = 1344798720 Target Memory = 84049920 Last Notification = STABLE Timeout = 6 Early Termination Factor = 5
2013-03-25 17:18:22.320 spid316 MEMORYBROKER_FOR_CACHE Allocations = 179060 Rate = 75 Target Allocations = 130637 Future Allocations = 0 Last Notification = SHRINK
2013-03-25 17:18:22.320 spid212 MEMORYBROKER_FOR_CACHE Allocations = 179060 Rate = 75 Target Allocations = 130637 Future Allocations = 0 Last Notification = SHRINK
2013-03-25 17:18:22.320 spid316 MEMORYBROKER_FOR_STEAL Allocations = 9414 Rate = 2 Target Allocations = 10260 Future Allocations = 0 Last Notification = STABLE
2013-03-25 17:18:22.320 spid212 MEMORYBROKER_FOR_STEAL Allocations = 9414 Rate = 2 Target Allocations = 10260 Future Allocations = 0 Last Notification = STABLE
2013-03-25 17:18:22.320 spid316 MEMORYBROKER_FOR_RESERVE Allocations = 5511 Rate = -915 Target Allocations = 10260 Future Allocations = 36551 Last Notification = STABLE
2013-03-25 17:18:22.320 spid212 MEMORYBROKER_FOR_RESERVE Allocations = 5511 Rate = -915 Target Allocations = 10260 Future Allocations = 36551 Last Notification = STABLE
2013-03-25 17:18:22.320 spid212 There is insufficient system memory to run this query.
2013-03-25 17:18:22.320 spid316 There is insufficient system memory to run this query.
2013-03-25 17:18:44.220 spid73 There is insufficient system memory to run this query.
2013-03-25 17:18:44.230 spid138 There is insufficient system memory to run this query.
2013-03-25 17:18:44.220 spid154 There is insufficient system memory to run this query.
2013-03-25 17:18:51.230 spid73 There is insufficient system memory to run this query.
2013-03-25 17:18:51.230 spid222 There is insufficient system memory to run this query.
2013-03-25 17:18:51.230 spid53 There is insufficient system memory to run this query.
2013-03-25 17:18:51.230 spid108 There is insufficient system memory to run this query.
2013-03-25 17:18:51.230 spid186 There is insufficient system memory to run this query.
2013-03-25 17:18:51.230 spid106 There is insufficient system memory to run this query.
2013-03-25 17:18:51.230 spid57 There is insufficient system memory to run this query.
2013-03-25 17:18:51.230 spid223 There is insufficient system memory to run this query.
2013-03-25 17:18:51.230 spid147 There is insufficient system memory to run this query.
2013-03-25 17:18:51.230 spid53 There is insufficient system memory to run this query.
2013-03-25 17:18:51.230 spid245 There is insufficient system memory to run this query.
2013-03-25 17:18:51.230 spid61 There is insufficient system memory to run this query.
2013-03-25 17:18:51.230 spid70 There is insufficient system memory to run this query.
2013-03-25 17:18:51.250 spid53 There is insufficient system memory to run this query.
2013-03-25 17:19:04.200 spid191 There is insufficient system memory to run this query.
2013-03-25 17:19:04.200 spid82 There is insufficient system memory to run this query.
2013-03-25 17:19:04.200 spid154 There is insufficient system memory to run this query.
2013-03-25 17:19:04.200 spid135 There is insufficient system memory to run this query.
2013-03-25 17:19:04.200 spid205 There is insufficient system memory to run this query.
2013-03-25 17:19:04.200 spid57 There is insufficient system memory to run this query.
2013-03-25 17:19:04.200 spid316 There is insufficient system memory to run this query.
2013-03-25 17:19:04.200 spid139 There is insufficient system memory to run this query.
2013-03-25 17:19:04.200 spid186 There is insufficient system memory to run this query.
2013-03-25 17:19:04.200 spid108 There is insufficient system memory to run this query.
2013-03-25 17:19:04.200 spid115 There is insufficient system memory to run this query.
2013-03-25 17:19:04.200 spid51 There is insufficient system memory to run this query.
2013-03-25 17:19:04.200 spid159 There is insufficient system memory to run this query.
2013-03-25 17:19:04.200 spid62 There is insufficient system memory to run this query.
2013-03-25 17:19:04.210 spid175 There is insufficient system memory to run this query.
2013-03-25 17:19:04.210 spid212 There is insufficient system memory to run this query.
2013-03-25 17:19:04.250 spid82 There is insufficient system memory to run this query.
2013-03-25 17:19:04.250 spid79 There is insufficient system memory to run this query.
2013-03-25 17:19:04.250 spid154 There is insufficient system memory to run this query.
2013-03-25 17:19:04.250 spid154 There is insufficient system memory to run this query.
2013-03-25 17:19:04.250 spid154 There is insufficient system memory to run this query.
2013-03-25 17:19:04.320 spid115 There is insufficient system memory to run this query.
2013-03-25 17:19:04.340 spid252 There is insufficient system memory to run this query.
2013-03-25 17:19:04.340 spid250 There is insufficient system memory to run this query.
2013-03-25 17:19:04.340 spid193 There is insufficient system memory to run this query.
2013-03-25 17:19:04.340 spid178 There is insufficient system memory to run this query.
2013-03-25 17:19:04.340 spid174 There is insufficient system memory to run this query.
2013-03-25 17:19:04.340 spid226 There is insufficient system memory to run this query.
2013-03-25 17:19:04.340 spid271 There is insufficient system memory to run this query.
2013-03-25 17:19:04.340 spid109 There is insufficient system memory to run this query.
2013-03-25 17:19:04.340 spid115 There is insufficient system memory to run this query.
2013-03-25 17:19:04.340 spid115 There is insufficient system memory to run this query.
2013-03-25 17:19:04.350 spid194 There is insufficient system memory to run this query.
2013-03-25 17:19:04.370 spid178 There is insufficient system memory to run this query.
2013-03-25 17:19:04.660 spid228 There is insufficient system memory to run this query.
2013-03-25 17:19:04.660 spid261 There is insufficient system memory to run this query.
2013-03-25 17:19:04.660 spid263 There is insufficient system memory to run this query.
2013-03-25 17:19:21.430 spid240 There is insufficient system memory to run this query.
2013-03-25 17:19:21.430 spid80 There is insufficient system memory to run this query.
2013-03-25 17:19:21.430 spid191 There is insufficient system memory to run this query.
2013-03-25 17:19:21.430 spid53 There is insufficient system memory to run this query.
2013-03-25 17:19:21.430 spid119 There is insufficient system memory to run this query.
2013-03-25 17:19:21.430 spid53 There is insufficient system memory to run this query.
2013-03-25 17:19:21.430 spid145 There is insufficient system memory to run this query.
2013-03-25 17:19:21.430 spid53 There is insufficient system memory to run this query.
2013-03-25 17:19:21.430 spid53 There is insufficient system memory to run this query.
2013-03-25 17:19:21.480 spid70 There is insufficient system memory to run this query.
2013-03-25 17:19:21.430 spid92 There is insufficient system memory to run this query.
2013-03-25 17:19:36.200 spid124 There is insufficient system memory to run this query.
2013-03-25 17:19:36.200 spid222 There is insufficient system memory to run this query.
2013-03-25 17:19:36.200 spid151 Memory Manager VM Reserved = 1761016 KB VM Committed = 1757424 KB AWE Allocated = 0 KB Reserved Memory = 1024 KB Reserved Memory In Use = 0 KB
2013-03-25 17:19:36.200 spid151 Memory node Id = 0 VM Reserved = 1756856 KB VM Committed = 1753416 KB AWE Allocated = 0 KB SinglePage Allocator = 1556488 KB MultiPage Allocator = 66912 KB
2013-03-25 17:19:36.200 spid151 MEMORYCLERK_SQLGENERAL (Total) VM Reserved = 0 KB VM Committed = 0 KB AWE Allocated = 0 KB SM Reserved = 0 KB SM Committed = 0 KB SinglePage Allocator = 17880 KB MultiPage Allocator = 4600 KB
2013-03-25 17:19:36.200 spid151 MEMORYCLERK_SQLBUFFERPOOL (Total) VM Reserved = 1654624 KB VM Committed = 1654624 KB AWE Allocated = 0 KB SM Reserved = 0 KB SM Committed = 0 KB SinglePage Allocator = 0 KB MultiPage Allocator = 400 KB
2013-03-25 17:19:36.200 spid151 MEMORYCLERK_SQLQUERYEXEC (Total) VM Reserved = 0 KB VM Committed = 0 KB AWE Allocated = 0 KB SM Reserved = 0 KB SM Committed = 0 KB SinglePage Allocator = 744 KB MultiPage Allocator = 104 KB
2013-03-25 17:19:36.200 spid151 MEMORYCLERK_SQLOPTIMIZER (Total) VM Reserved = 0 KB VM Committed = 0 KB AWE Allocated = 0 KB SM Reserved = 0 KB SM Committed = 0 KB SinglePage Allocator = 5032 KB MultiPage Allocator = 112 KB
2013-03-25 17:19:36.200 spid151 MEMORYCLERK_SQLUTILITIES (Total) VM Reserved = 600 KB VM Committed = 600 KB AWE Allocated = 0 KB SM Reserved = 0 KB SM Committed = 0 KB SinglePage Allocator = 1120 KB MultiPage Allocator = 0 KB
2013-03-25 17:19:36.200 spid151 MEMORYCLERK_SQLSTORENG (Total) VM Reserved = 20928 KB VM Committed = 20928 KB AWE Allocated = 0 KB SM Reserved = 0 KB SM Committed = 0 KB SinglePage Allocator = 12992 KB MultiPage Allocator = 12440 KB
2013-03-25 17:19:36.200 spid151 MEMORYCLERK_SQLCONNECTIONPOOL (Total) VM Reserved = 0 KB VM Committed = 0 KB AWE Allocated = 0 KB SM Reserved = 0 KB SM Committed = 0 KB SinglePage Allocator = 3760 KB MultiPage Allocator = 0 KB
2013-03-25 17:19:36.200 spid151 MEMORYCLERK_SQLCLR (Total) VM Reserved = 0 KB VM Committed = 0 KB AWE Allocated = 0 KB SM Reserved = 0 KB SM Committed = 0 KB SinglePage Allocator = 8 KB MultiPage Allocator = 0 KB
2013-03-25 17:19:36.200 spid151 MEMORYCLERK_SQLSERVICEBROKER (Total) VM Reserved = 0 KB VM Committed = 0 KB AWE Allocated = 0 KB SM Reserved = 0 KB SM Committed = 0 KB SinglePage Allocator = 264 KB MultiPage Allocator = 192 KB
2013-03-25 17:19:36.200 spid151 MEMORYCLERK_SQLHTTP (Total) VM Reserved = 0 KB VM Committed = 0 KB AWE Allocated = 0 KB SM Reserved = 0 KB SM Committed = 0 KB SinglePage Allocator = 8 KB MultiPage Allocator = 0 KB
2013-03-25 17:19:36.200 spid151 MEMORYCLERK_SNI (Total) VM Reserved = 0 KB VM Committed = 0 KB AWE Allocated = 0 KB SM Reserved = 0 KB SM Committed = 0 KB SinglePage Allocator = 512 KB MultiPage Allocator = 16 KB
2013-03-25 17:19:36.200 spid151 MEMORYCLERK_FULLTEXT (Total) VM Reserved = 0 KB VM Committed = 0 KB AWE Allocated = 0 KB SM Reserved = 0 KB SM Committed = 0 KB SinglePage Allocator = 56 KB MultiPage Allocator = 0 KB
2013-03-25 17:19:36.200 spid151 MEMORYCLERK_SQLXP (Total) VM Reserved = 0 KB VM Committed = 0 KB AWE Allocated = 0 KB SM Reserved = 0 KB SM Committed = 0 KB SinglePage Allocator = 16 KB MultiPage Allocator = 0 KB
2013-03-25 17:19:36.200 spid151 MEMORYCLERK_BHF (Total) VM Reserved = 0 KB VM Committed = 0 KB AWE Allocated = 0 KB SM Reserved = 0 KB SM Committed = 0 KB SinglePage Allocator = 168 KB MultiPage Allocator = 0 KB
2013-03-25 17:19:36.200 spid151 MEMORYCLERK_SQLQERESERVATIONS (Total) VM Reserved = 0 KB VM Committed = 0 KB AWE Allocated = 0 KB SM Reserved = 0 KB SM Committed = 0 KB SinglePage Allocator = 12288 KB MultiPage Allocator = 0 KB
2013-03-25 17:19:36.200 spid151 MEMORYCLERK_HOST (Total) VM Reserved = 0 KB VM Committed = 0 KB AWE Allocated = 0 KB SM Reserved = 0 KB SM Committed = 0 KB SinglePage Allocator = 72 KB MultiPage Allocator = 64 KB
2013-03-25 17:19:36.200 spid151 MEMORYCLERK_SOSNODE (Total) VM Reserved = 0 KB VM Committed = 0 KB AWE Allocated = 0 KB SM Reserved = 0 KB SM Committed = 0 KB SinglePage Allocator = 32376 KB MultiPage Allocator = 6768 KB
2013-03-25 17:19:36.200 spid151 MEMORYCLERK_FULLTEXT_SHMEM (Total) VM Reserved = 0 KB VM Committed = 0 KB AWE Allocated = 0 KB SM Reserved = 256 KB SM Committed = 256 KB SinglePage Allocator = 0 KB MultiPage Allocator = 0 KB
2013-03-25 17:19:36.200 spid151 MEMORYCLERK_SQLSERVICEBROKERTRANSPORT (Total) VM Reserved = 0 KB VM Committed = 0 KB AWE Allocated = 0 KB SM Reserved = 0 KB SM Committed = 0 KB SinglePage Allocator = 24 KB MultiPage Allocator = 0 KB
2013-03-25 17:19:36.210 spid151 Process physical/virtual memory pressure: 1/0 System physical memory pressure: 0
2013-03-25 17:19:36.210 spid151 Global Memory Objects: Resource= 957 Locks= 382 SE Schema Mgr= 2167 SQLCache= 1163 Replication= 2 ServerGlobal= 28 XPGlobal= 2 Xact= 158 SETLS= 4 DatasetMemObjs= 8 SubpDescPmos= 4 SortTables= 1523
2013-03-25 17:19:36.210 spid151 Query Memory Objects: Grants=3 Waiting=0 Maximum=8975 Available=7439 Limit=8975
2013-03-25 17:19:36.210 spid151 Query Memory Objects: Next Request=0 Waiting For=0 Cost=0 Timeout=0 Wait Time=0 Last Target=9615
2013-03-25 17:19:36.210 spid151 Small Query Memory Objects: Grants=0 Waiting=0 Maximum=640 Available=640 Limit=640
2013-03-25 17:19:36.210 spid151 Optimization Queue Overall Memory = 1344798720 Target Memory = 84049920 Last Notification = STABLE Timeout = 6 Early Termination Factor = 5
2013-03-25 17:19:36.210 spid151 MEMORYBROKER_FOR_CACHE Allocations = 185163 Rate = -58 Target Allocations = 131515 Future Allocations = 0 Last Notification = SHRINK
2013-03-25 17:19:36.210 spid151 MEMORYBROKER_FOR_STEAL Allocations = 9394 Rate = 2 Target Allocations = 10260 Future Allocations = 0 Last Notification = STABLE
2013-03-25 17:19:36.210 spid151 MEMORYBROKER_FOR_RESERVE Allocations = 1536 Rate = 508 Target Allocations = 10260 Future Allocations = 36551 Last Notification = STABLE
2013-03-25 17:19:36.210 spid151 There is insufficient system memory to run this query.
2013-03-25 17:19:36.210 spid194 There is insufficient system memory to run this query.
2013-03-25 17:19:36.220 spid151 There is insufficient system memory to run this query.
2013-03-25 17:19:36.220 spid82 There is insufficient system memory to run this query.
2013-03-25 17:19:36.220 spid240 There is insufficient system memory to run this query.
2013-03-25 17:19:36.220 spid53 There is insufficient system memory to run this query.
2013-03-25 17:19:36.220 spid179 There is insufficient system memory to run this query.
2013-03-25 17:19:36.220 spid80 There is insufficient system memory to run this query.
2013-03-25 17:19:36.220 spid335 There is insufficient system memory to run this query.
2013-03-25 17:19:36.220 spid167 There is insufficient system memory to run this query.
2013-03-25 17:19:36.220 spid191 There is insufficient system memory to run this query.
2013-03-25 17:19:36.220 spid53 There is insufficient system memory to run this query.
2013-03-25 17:19:36.220 spid151 There is insufficient system memory to run this query.
2013-03-25 17:19:36.220 spid53 There is insufficient system memory to run this query.
2013-03-25 17:19:36.220 spid53 There is insufficient system memory to run this query.
2013-03-25 17:19:36.230 spid151 There is insufficient system memory to run this query.
2013-03-25 17:19:36.210 spid175 There is insufficient system memory to run this query.
2013-03-25 17:19:36.340 spid147 There is insufficient system memory to run this query.
2013-03-25 17:19:36.340 spid159 There is insufficient system memory to run this query.
2013-03-25 17:19:36.340 spid51 There is insufficient system memory to run this query.
2013-03-25 17:19:36.340 spid245 There is insufficient system memory to run this query.
2013-03-25 17:19:41.790 spid290 There is insufficient system memory to run this query.
2013-03-25 17:19:41.790 spid222 There is insufficient system memory to run this query.
2013-03-25 17:19:41.790 spid124 There is insufficient system memory to run this query.
2013-03-25 17:19:41.790 spid194 There is insufficient system memory to run this query.
2013-03-25 17:19:41.800 spid139 There is insufficient system memory to run this query.
2013-03-25 17:19:41.800 spid82 There is insufficient system memory to run this query.
2013-03-25 17:19:41.800 spid53 There is insufficient system memory to run this query.
2013-03-25 17:19:41.800 spid167 There is insufficient system memory to run this query.
2013-03-25 17:19:41.800 spid179 There is insufficient system memory to run this query.
2013-03-25 17:19:41.800 spid191 There is insufficient system memory to run this query.
2013-03-25 17:19:41.800 spid248 There is insufficient system memory to run this query.
2013-03-25 17:19:41.800 spid240 There is insufficient system memory to run this query.
2013-03-25 17:19:41.800 spid119 There is insufficient system memory to run this query.
2013-03-25 17:19:41.800 spid53 There is insufficient system memory to run this query.
2013-03-25 17:19:41.850 spid85 There is insufficient system memory to run this query.
2013-03-25 17:19:41.860 spid252 There is insufficient system memory to run this query.
2013-03-25 17:19:41.860 spid175 There is insufficient system memory to run this query.
2013-03-25 17:19:41.860 spid245 There is insufficient system memory to run this query.
2013-03-25 17:19:41.860 spid147 There is insufficient system memory to run this query.
2013-03-25 17:19:41.860 spid117 There is insufficient system memory to run this query.
2013-03-25 17:19:41.860 spid181 There is insufficient system memory to run this query.
2013-03-25 17:19:41.860 spid179 There is insufficient system memory to run this query.
2013-03-25 17:19:41.860 spid290 There is insufficient system memory to run this query.
2013-03-25 17:19:41.860 spid179 There is insufficient system memory to run this query.
2013-03-25 17:19:41.860 spid119 There is insufficient system memory to run this query.
2013-03-25 17:19:41.870 spid65 There is insufficient system memory to run this query.
2013-03-25 17:19:41.870 spid119 There is insufficient system memory to run this query.
2013-03-25 17:19:41.870 spid119 There is insufficient system memory to run this query.
2013-03-25 17:19:41.870 spid119 There is insufficient system memory to run this query.
2013-03-25 17:19:41.880 spid119 There is insufficient system memory to run this query.
2013-03-25 17:19:41.880 spid119 There is insufficient system memory to run this query.
2013-03-25 17:19:41.880 spid119 There is insufficient system memory to run this query.
2013-03-25 17:19:41.890 spid119 There is insufficient system memory to run this query.
2013-03-25 17:19:41.890 spid119 There is insufficient system memory to run this query.
2013-03-25 17:19:41.900 spid119 There is insufficient system memory to run this query.
2013-03-25 17:19:41.900 spid119 There is insufficient system memory to run this query.
2013-03-25 17:19:41.910 spid119 There is insufficient system memory to run this query.
2013-03-25 17:19:41.910 spid119 There is insufficient system memory to run this query.
2013-03-25 17:19:41.920 spid119 There is insufficient system memory to run this query.
2013-03-25 17:19:41.920 spid119 There is insufficient system memory to run this query.
2013-03-25 17:19:41.930 spid119 There is insufficient system memory to run this query.
2013-03-25 17:19:41.930 spid119 There is insufficient system memory to run this query.
2013-03-25 17:19:41.930 spid119 There is insufficient system memory to run this query.
2013-03-25 17:19:41.930 spid119 There is insufficient system memory to run this query.
2013-03-25 17:19:41.990 spid144 There is insufficient system memory to run this query.
2013-03-25 17:19:42.230 spid148 There is insufficient system memory to run this query.
2013-03-25 17:19:42.230 spid57 There is insufficient system memory to run this query.
2013-03-25 17:19:42.240 spid97 There is insufficient system memory to run this query.
2013-03-25 17:19:42.240 spid62 There is insufficient system memory to run this query.
2013-03-25 17:19:42.240 spid359 There is insufficient system memory to run this query.
2013-03-25 17:19:42.240 spid91 There is insufficient system memory to run this query.
2013-03-25 17:19:42.240 spid115 There is insufficient system memory to run this query.
2013-03-25 17:19:55.700 Server Resource Monitor (0x32a0) Worker 0x03D5C0E8 appears to be non-yielding on Node 0. Memory freed: 33832 KB. Approx CPU Used: kernel 93 ms, user 46 ms, Interval: 60000.
2013-03-25 17:23:10.700 Server Resource Monitor (0x32a0) Worker 0x03D5C0E8 appears to be non-yielding on Node 0. Memory freed: 17784 KB. Approx CPU Used: kernel 15 ms, user 15 ms, Interval: 60000.
2013-03-25 17:25:45.710 Server Resource Monitor (0x32a0) Worker 0x03D5C0E8 appears to be non-yielding on Node 0. Memory freed: 223800 KB. Approx CPU Used: kernel 46 ms, user 31 ms, Interval: 60000.
MCP SQL Server 2000, MCTS SQL Server 2005, MCTS SQL Server 2008 (DBD, DBA)