Home Dashboard Directory Help
Search

There is insufficient system memory to run this query by Yaniv Harpaz


Status: 

Closed
 as Not Reproducible Help for as Not Reproducible


9
1
Sign in
to vote
Type: Bug
ID: 279027
Opened: 5/30/2007 1:30:57 AM
Access Restriction: Public
8
Workaround(s)
view
17
User(s) can reproduce this bug

Description

We came across an error once we tried a new version of our product.
The database server has 4GB RAM, 100 databases (50mb size).
It has SQL 2005 - SP1
with 50 - 100 connections open at the same time.

We found this KB - http://support.microsoft.com/kb/243588
but we still don't know what went wrong on the server.
We got these errors on the log:

spid64     Error: 701, Severity: 17, State: 123.
spid64     There is insufficient system memory to run this query.
spid227     Error: 701, Severity: 17, State: 65.
spid227     There is insufficient system memory to run this query.
spid175     Error: 701, Severity: 17, State: 135.
spid175     There is insufficient system memory to run this query.
spid166     Error: 701, Severity: 17, State: 123.
spid166     There is insufficient system memory to run this query.
spid67     Error: 701, Severity: 17, State: 135.
spid67     There is insufficient system memory to run this query.
spid189     Error: 701, Severity: 17, State: 135.
spid189     There is insufficient system memory to run this query.
spid134     Error: 701, Severity: 17, State: 130.
spid134     There is insufficient system memory to run this query.
spid124     Error: 701, Severity: 17, State: 130.

It start without using the AWE/3GB option.
We tried it in order to solve it, but it didn't help.
Details
Sign in to post a comment.
Posted by WWWWWW on 2/16/2010 at 12:37 AM
one time after restarting of the server, sql server started, all the databases
on this server started - except one. One database could not start.
In error log when this database tried to start i saw that message:

2010-02-14 10:07:39.48 spid18s     Clearing tempdb database.
2010-02-14 10:07:45.89 spid17s     Starting up database 'msdb'.
2010-02-14 10:07:45.89 spid29s     Starting up database 'XX'.
2010-02-14 10:07:45.89 spid27s     Starting up database 'zzz'.
2010-02-14 10:07:45.89 spid33s     Starting up database 'x3'.
2010-02-14 10:07:45.90 spid34s     Starting up database 'x6'.
2010-02-14 10:07:45.90 spid31s     Starting up database 'x_X'.
2010-02-14 10:07:45.90 spid26s     Starting up database 'xnal'.
2010-02-14 10:07:45.90 spid22s     Starting up database 'xs'.
2010-02-14 10:07:45.90 spid28s     Starting up database 'xx1'.
2010-02-14 10:07:45.92 spid25s     Starting up database 'xDb'.
2010-02-14 10:07:45.92 spid30s     Starting up database 'x_1'.
2010-02-14 10:07:45.92 spid23s     Starting up database 'x1'.
2010-02-14 10:07:45.92 spid21s     Starting up database 'TaxCopy'.
2010-02-14 10:07:45.92 spid32s     Starting up database 'x_2'.
2010-02-14 10:07:46.07 spid24s    
Memory Manager                                 KB
---------------------------------------- ----------
VM Reserved                                33189868
VM Committed                                 163136
Locked Pages Allocated                            0
Reserved Memory                                1024
Reserved Memory In Use                            0
2010-02-14 10:07:46.07 spid24s    
Memory node Id = 0                             KB
---------------------------------------- ----------
VM Reserved                                 10816
VM Committed                                 10576
Locked Pages Allocated                            0
MultiPage Allocator                            9072
SinglePage Allocator                         15968
2010-02-14 10:07:46.07 spid24s    
Memory node Id = 1                             KB
---------------------------------------- ----------
VM Reserved                                33175404
VM Committed                                 149020
Locked Pages Allocated                            0
MultiPage Allocator                         24216
SinglePage Allocator                         15968
2010-02-14 10:07:46.07 spid24s    
Memory node Id = 64                             KB
---------------------------------------- ----------
VM Reserved                                    2560
VM Committed                                 2504
Locked Pages Allocated                            0
MultiPage Allocator                            2416
SinglePage Allocator                         15968
2010-02-14 10:07:46.07 spid24s    
MEMORYCLERK_SQLGENERAL (node 0)                 KB
---------------------------------------- ----------
VM Reserved                                     0
VM Committed                                     0
Locked Pages Allocated                            0
SM Reserved                                     0
SM Committed                                     0
SinglePage Allocator                         1920
MultiPage Allocator                            3400
2010-02-14 10:07:46.07 spid24s    
MEMORYCLERK_SQLGENERAL (node 1)                 KB
---------------------------------------- ----------
VM Reserved                                     0
VM Committed                                     0
Locked Pages Allocated                            0
SM Reserved                                     0
SM Committed                                     0
SinglePage Allocator                             8
MultiPage Allocator                             0
2010-02-14 10:07:46.07 spid24s    
MEMORYCLERK_SQLGENERAL (Total)                 KB
---------------------------------------- ----------
VM Reserved                                     0
VM Committed                                     0
Locked Pages Allocated                            0
SM Reserved                                     0
SM Committed                                     0
SinglePage Allocator                         1928
MultiPage Allocator                            3400
2010-02-14 10:07:46.07 spid24s    
MEMORYCLERK_SQLBUFFERPOOL (node 0)             KB
---------------------------------------- ----------
VM Reserved                                33079296
VM Committed                                 55120
Locked Pages Allocated                            0
SM Reserved                                     0
SM Committed                                     0
SinglePage Allocator                             0
MultiPage Allocator                             648
2010-02-14 10:07:46.07 spid24s    
MEMORYCLERK_SQLQUERYEXEC (node 0)                KB
---------------------------------------- ----------
VM Reserved                                     0
VM Committed                                     0
Locked Pages Allocated                            0
SM Reserved                                     0
SM Committed                                     0
SinglePage Allocator                            160
MultiPage Allocator                             0
2010-02-14 10:07:46.07 spid24s    
MEMORYCLERK_SQLOPTIMIZER (node 0)                KB
---------------------------------------- ----------
VM Reserved                                     0
VM Committed                                     0
Locked Pages Allocated                            0
SM Reserved                                     0
SM Committed                                     0
SinglePage Allocator                             96
MultiPage Allocator                             944
2010-02-14 10:07:46.07 spid24s    
MEMORYCLERK_SQLUTILITIES (node 0)                KB
---------------------------------------- ----------
VM Reserved                                     360
VM Committed                                    360
Locked Pages Allocated                            0
SM Reserved                                     0
SM Committed                                     0
SinglePage Allocator                             88
MultiPage Allocator                             0
2010-02-14 10:07:46.07 spid24s    
MEMORYCLERK_SQLSTORENG (node 0)                 KB
---------------------------------------- ----------
VM Reserved                                     512
VM Committed                                    512
Locked Pages Allocated                            0
SM Reserved                                     0
SM Committed                                     0
SinglePage Allocator                         1216
MultiPage Allocator                             824
2010-02-14 10:07:46.07 spid24s    
MEMORYCLERK_SQLSTORENG (node 1)                 KB
---------------------------------------- ----------
VM Reserved                                     0
VM Committed                                     0
Locked Pages Allocated                            0
SM Reserved                                     0
SM Committed                                     0
SinglePage Allocator                             48
MultiPage Allocator                            3456
2010-02-14 10:07:46.07 spid24s    
MEMORYCLERK_SQLSTORENG (Total)                 KB
---------------------------------------- ----------
VM Reserved                                     512
VM Committed                                    512
Locked Pages Allocated                            0
SM Reserved                                     0
SM Committed                                     0
SinglePage Allocator                         1264
MultiPage Allocator                            4280
2010-02-14 10:07:46.07 spid24s    
MEMORYCLERK_SQLCONNECTIONPOOL (node 0)         KB
---------------------------------------- ----------
VM Reserved                                     0
VM Committed                                     0
Locked Pages Allocated                            0
SM Reserved                                     0
SM Committed                                     0
SinglePage Allocator                            424
MultiPage Allocator                             0
2010-02-14 10:07:46.07 spid24s    
MEMORYCLERK_SQLCONNECTIONPOOL (node 1)         KB
---------------------------------------- ----------
VM Reserved                                     0
VM Committed                                     0
Locked Pages Allocated                            0
SM Reserved                                     0
SM Committed                                     0
SinglePage Allocator                            184
MultiPage Allocator                             0
2010-02-14 10:07:46.07 spid24s    
MEMORYCLERK_SQLCONNECTIONPOOL (Total)            KB
---------------------------------------- ----------
VM Reserved                                     0
VM Committed                                     0
Locked Pages Allocated                            0
SM Reserved                                     0
SM Committed                                     0
SinglePage Allocator                            608
MultiPage Allocator                             0
2010-02-14 10:07:46.07 spid24s    
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
2010-02-14 10:07:46.07 spid24s    
MEMORYCLERK_SQLSERVICEBROKER (node 0)            KB
---------------------------------------- ----------
VM Reserved                                     0
VM Committed                                     0
Locked Pages Allocated                            0
SM Reserved                                     0
SM Committed                                     0
SinglePage Allocator                            136
MultiPage Allocator                             544
2010-02-14 10:07:46.07 spid24s    
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
2010-02-14 10:07:46.07 spid24s    
MEMORYCLERK_SNI (node 0)                         KB
---------------------------------------- ----------
VM Reserved                                     0
VM Committed                                     0
Locked Pages Allocated                            0
SM Reserved                                     0
SM Committed                                     0
SinglePage Allocator                             0
MultiPage Allocator                             80
2010-02-14 10:07:46.07 spid24s    
MEMORYCLERK_SNI (node 1)                         KB
---------------------------------------- ----------
VM Reserved                                     0
VM Committed                                     0
Locked Pages Allocated                            0
SM Reserved                                     0
SM Committed                                     0
SinglePage Allocator                             8
MultiPage Allocator                             48
2010-02-14 10:07:46.07 spid24s    
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
2010-02-14 10:07:46.07 spid24s    
MEMORYCLERK_SNI (Total)                         KB
---------------------------------------- ----------
VM Reserved                                     0
VM Committed                                     0
Locked Pages Allocated                            0
SM Reserved                                     0
SM Committed                                     0
SinglePage Allocator                             8
MultiPage Allocator                             144
2010-02-14 10:07:46.11 spid24s    
MEMORYCLERK_FULLTEXT (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
2010-02-14 10:07:46.11 spid24s    
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
2010-02-14 10:07:46.11 spid24s    
MEMORYCLERK_XE_BUFFER (node 0)                 KB
---------------------------------------- ----------
VM Reserved                                    2816
VM Committed                                 2816
Locked Pages Allocated                            0
SM Reserved                                     0
SM Committed                                     0
SinglePage Allocator                             0
MultiPage Allocator                             0
2010-02-14 10:07:46.11 spid24s    
MEMORYCLERK_XE_BUFFER (node 1)                 KB
---------------------------------------- ----------
VM Reserved                                    1408
VM Committed                                 1408
Locked Pages Allocated                            0
SM Reserved                                     0
SM Committed                                     0
SinglePage Allocator                             0
MultiPage Allocator                             0
2010-02-14 10:07:46.11 spid24s    
MEMORYCLERK_XE_BUFFER (Total)                    KB
---------------------------------------- ----------
VM Reserved                                    4224
VM Committed                                 4224
Locked Pages Allocated                            0
SM Reserved                                     0
SM Committed                                     0
SinglePage Allocator                             0
MultiPage Allocator                             0
2010-02-14 10:07:46.11 spid24s    
MEMORYCLERK_SOSNODE (node 0)                     KB
---------------------------------------- ----------
VM Reserved                                     0
VM Committed                                     0
Locked Pages Allocated                            0
SM Reserved                                     0
SM Committed                                     0
SinglePage Allocator                         1920
MultiPage Allocator                         15928
2010-02-14 10:07:46.11 spid24s    
MEMORYCLERK_SOSNODE (node 1)                     KB
---------------------------------------- ----------
VM Reserved                                     0
VM Committed                                     0
Locked Pages Allocated                            0
SM Reserved                                     0
SM Committed                                     0
SinglePage Allocator                         1344
MultiPage Allocator                            4624
2010-02-14 10:07:46.11 spid24s    
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
2010-02-14 10:07:46.11 spid24s    
MEMORYCLERK_SOSNODE (Total)                     KB
---------------------------------------- ----------
VM Reserved                                     0
VM Committed                                     0
Locked Pages Allocated                            0
SM Reserved                                     0
SM Committed                                     0
SinglePage Allocator                         3272
MultiPage Allocator                         22888
2010-02-14 10:07:46.11 spid24s    
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
2010-02-14 10:07:46.11 spid24s    
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
2010-02-14 10:07:46.11 spid24s    
MEMORYCLERK_FSAGENT (node 0)                     KB
---------------------------------------- ----------
VM Reserved                                     0
VM Committed                                     0
Locked Pages Allocated                            0
SM Reserved                                     0
SM Committed                                     0
SinglePage Allocator                             8
MultiPage Allocator                             16
2010-02-14 10:07:46.11 spid24s    
MEMORYCLERK_XE (node 0)                         KB
---------------------------------------- ----------
VM Reserved                                     0
VM Committed                                     0
Locked Pages Allocated                            0
SM Reserved                                     0
SM Committed                                     0
SinglePage Allocator                             48
MultiPage Allocator                             168
2010-02-14 10:07:46.11 spid7s     Recovery is writing a checkpoint in database 'AggDb' (6). This is an informational message only. No user action is required.
2010-02-14 10:07:46.11 spid24s    
CACHESTORE_OBJCP (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
2010-02-14 10:07:46.11 spid24s    
CACHESTORE_SQLCP (node 0)                        KB
---------------------------------------- ----------
VM Reserved                                     0
VM Committed                                     0
Locked Pages Allocated                            0
SM Reserved                                     0
SM Committed                                     0
SinglePage Allocator                            264
MultiPage Allocator                            1568
2010-02-14 10:07:46.11 spid24s    
CACHESTORE_PHDR (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
2010-02-14 10:07:46.11 spid24s    
CACHESTORE_XPROC (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
2010-02-14 10:07:46.11 spid24s    
CACHESTORE_TEMPTABLES (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
2010-02-14 10:07:46.12 spid24s    
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
2010-02-14 10:07:46.12 spid24s    
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
2010-02-14 10:07:46.12 spid24s    
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
2010-02-14 10:07:46.12 spid24s    
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
2010-02-14 10:07:46.12 spid24s    
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
2010-02-14 10:07:46.12 spid24s    
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
2010-02-14 10:07:46.12 spid24s    
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
2010-02-14 10:07:46.12 spid24s    
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
2010-02-14 10:07:46.12 spid24s    
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
2010-02-14 10:07:46.12 spid24s    
CACHESTORE_BROKERTBLACS (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
2010-02-14 10:07:46.12 spid24s    
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
2010-02-14 10:07:46.12 spid24s    
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
2010-02-14 10:07:46.12 spid24s    
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
2010-02-14 10:07:46.12 spid24s    
CACHESTORE_BROKERRSB (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
2010-02-14 10:07:46.12 spid24s    
CACHESTORE_BROKERREADONLY (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
2010-02-14 10:07:46.12 spid24s    
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
2010-02-14 10:07:46.12 spid24s    
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
2010-02-14 10:07:46.12 spid24s    
CACHESTORE_SYSTEMROWSET (node 0)                 KB
---------------------------------------- ----------
VM Reserved                                     0
VM Committed                                     0
Locked Pages Allocated                            0
SM Reserved                                     0
SM Committed                                     0
SinglePage Allocator                            296
MultiPage Allocator                             0
2010-02-14 10:07:46.12 spid24s    
CACHESTORE_CONVPRI (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
2010-02-14 10:07:46.12 spid24s    
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
2010-02-14 10:07:46.12 spid24s    
USERSTORE_SCHEMAMGR (node 0)                     KB
---------------------------------------- ----------
VM Reserved                                     0
VM Committed                                     0
Locked Pages Allocated                            0
SM Reserved                                     0
SM Committed                                     0
SinglePage Allocator                            160
MultiPage Allocator                             0
2010-02-14 10:07:46.12 spid24s    
USERSTORE_DBMETADATA (node 0)                    KB
---------------------------------------- ----------
VM Reserved                                     0
VM Committed                                     0
Locked Pages Allocated                            0
SM Reserved                                     0
SM Committed                                     0
SinglePage Allocator                            288
MultiPage Allocator                             0
2010-02-14 10:07:46.12 spid24s    
USERSTORE_TOKENPERM (node 0)                     KB
---------------------------------------- ----------
VM Reserved                                     0
VM Committed                                     0
Locked Pages Allocated                            0
SM Reserved                                     0
SM Committed                                     0
SinglePage Allocator                            360
MultiPage Allocator                             0
2010-02-14 10:07:46.12 spid24s    
USERSTORE_TOKENPERM (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
2010-02-14 10:07:46.12 spid24s    
USERSTORE_TOKENPERM (Total)                     KB
---------------------------------------- ----------
VM Reserved                                     0
VM Committed                                     0
Locked Pages Allocated                            0
SM Reserved                                     0
SM Committed                                     0
SinglePage Allocator                            376
MultiPage Allocator                             0
2010-02-14 10:07:46.12 spid24s    
USERSTORE_OBJPERM (node 0)                     KB
---------------------------------------- ----------
VM Reserved                                     0
VM Committed                                     0
Locked Pages Allocated                            0
SM Reserved                                     0
SM Committed                                     0
SinglePage Allocator                         4728
MultiPage Allocator                             0
2010-02-14 10:07:46.12 spid24s    
USERSTORE_SXC (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
2010-02-14 10:07:46.12 spid24s    
USERSTORE_SXC (node 1)                         KB
---------------------------------------- ----------
VM Reserved                                     0
VM Committed                                     0
Locked Pages Allocated                            0
SM Reserved                                     0
SM Committed                                     0
SinglePage Allocator                             8
MultiPage Allocator                             0
2010-02-14 10:07:46.12 spid24s    
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
2010-02-14 10:07:46.12 spid24s    
USERSTORE_SXC (Total)                            KB
---------------------------------------- ----------
VM Reserved                                     0
VM Committed                                     0
Locked Pages Allocated                            0
SM Reserved                                     0
SM Committed                                     0
SinglePage Allocator                             24
MultiPage Allocator                             0
2010-02-14 10:07:46.12 spid24s    
OBJECTSTORE_LBSS (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
2010-02-14 10:07:46.12 spid24s    
OBJECTSTORE_SNI_PACKET (node 0)                 KB
---------------------------------------- ----------
VM Reserved                                     0
VM Committed                                     0
Locked Pages Allocated                            0
SM Reserved                                     0
SM Committed                                     0
SinglePage Allocator                             96
MultiPage Allocator                             56
2010-02-14 10:07:46.12 spid24s    
OBJECTSTORE_SNI_PACKET (node 1)                 KB
---------------------------------------- ----------
VM Reserved                                     0
VM Committed                                     0
Locked Pages Allocated                            0
SM Reserved                                     0
SM Committed                                     0
SinglePage Allocator                            112
MultiPage Allocator                             56
2010-02-14 10:07:46.12 spid24s    
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
2010-02-14 10:07:46.12 spid24s    
OBJECTSTORE_SNI_PACKET (Total)                 KB
---------------------------------------- ----------
VM Reserved                                     0
VM Committed                                     0
Locked Pages Allocated                            0
SM Reserved                                     0
SM Committed                                     0
SinglePage Allocator                            208
MultiPage Allocator                             168
2010-02-14 10:07:46.12 spid24s    
OBJECTSTORE_SERVICE_BROKER (node 0)             KB
---------------------------------------- ----------
VM Reserved                                     0
VM Committed                                     0
Locked Pages Allocated                            0
SM Reserved                                     0
SM Committed                                     0
SinglePage Allocator                            424
MultiPage Allocator                             0
2010-02-14 10:07:46.12 spid24s    
OBJECTSTORE_LOCK_MANAGER (node 0)                KB
---------------------------------------- ----------
VM Reserved                                 65540
VM Committed                                 65540
Locked Pages Allocated                            0
SM Reserved                                     0
SM Committed                                     0
SinglePage Allocator                            648
MultiPage Allocator                             0
2010-02-14 10:07:46.12 spid24s    
OBJECTSTORE_LOCK_MANAGER (node 1)                KB
---------------------------------------- ----------
VM Reserved                                     0
VM Committed                                     0
Locked Pages Allocated                            0
SM Reserved                                     0
SM Committed                                     0
SinglePage Allocator                            648
MultiPage Allocator                             0
2010-02-14 10:07:46.12 spid24s    
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
2010-02-14 10:07:46.12 spid24s    
OBJECTSTORE_LOCK_MANAGER (Total)                 KB
---------------------------------------- ----------
VM Reserved                                 65540
VM Committed                                 65540
Locked Pages Allocated                            0
SM Reserved                                     0
SM Committed                                     0
SinglePage Allocator                         1320
MultiPage Allocator                             0
2010-02-14 10:07:46.12 spid24s    
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
2010-02-14 10:07:46.12 spid24s    
Buffer Pool                                 Value
---------------------------------------- ----------
Committed                                     2609
Target                                     3145728
Database                                        275
Dirty                                             2
In IO                                             1
Latched                                         11
Free                                            308
Stolen                                         2026
Reserved                                         0
Visible                                     3145728
Stolen Potential                            2986415
Limiting Factor                                 17
Last OOM Factor                                 20
Page Life Expectancy                             0
2010-02-14 10:07:46.12 spid24s    
Process/System Counts                         Value
---------------------------------------- ----------
Available Physical Memory                32307503104
Available Virtual Memory                 8761677901824
Available Paging File                    35804221440
Working Set                             105086976
Percent of Committed Memory in WS                62
Page Faults                                 27749
System physical memory high                     1
System physical memory low                        0
Process physical memory low                     0
Process virtual memory low                        0
2010-02-14 10:07:46.12 spid24s    
Procedure Cache                             Value
---------------------------------------- ----------
TotalProcs                                        0
TotalPages                                     233
InUsePages                                        0
2010-02-14 10:07:46.12 spid24s    
Global Memory Objects                         Pages
---------------------------------------- ----------
Resource                                        292
Locks                                         165
XDES                                             65
SETLS                                            24
SE Dataset Allocators                            48
SubpDesc Allocators                             24
SE SchemaManager                                 18
SE Column Metadata Cache                         1
SQLCache                                         0
Replication                                     2
ServerGlobal                                     50
XP Global                                         2
SortTables                                        2
2010-02-14 10:07:46.14 spid24s    
Query Memory Objects (internal)             Value
---------------------------------------- ----------
Grants                                            0
Waiting                                         0
Available                                 2351095
Current Max                                 2351095
Future Max                                 2351095
Physical Max                                2351095
Next Request                                     0
Waiting For                                     0
Cost                                             0
Timeout                                         0
Wait Time                                         0
2010-02-14 10:07:46.14 spid24s    
Small Query Memory Objects (internal)         Value
---------------------------------------- ----------
Grants                                            0
Waiting                                         0
Available                                     12800
Current Max                                 12800
Future Max                                    12800
2010-02-14 10:07:46.14 spid24s    
Query Memory Objects (default)                Value
---------------------------------------- ----------
Grants                                            0
Waiting                                         0
Available                                 2351095
Current Max                                 2351095
Future Max                                 2351095
Physical Max                                2351095
Next Request                                     0
Waiting For                                     0
Cost                                             0
Timeout                                         0
Wait Time                                         0
2010-02-14 10:07:46.14 spid24s    
Small Query Memory Objects (default)         Value
---------------------------------------- ----------
Grants                                            0
Waiting                                         0
Available                                     12800
Current Max                                 12800
Future Max                                    12800
2010-02-14 10:07:46.14 spid24s    
Optimization Queue (internal)                 Value
---------------------------------------- ----------
Overall Memory                         20656103424
Target Memory                            20656103424
Last Notification                                 1
Timeout                                         6
Early Termination Factor                         5
2010-02-14 10:07:46.14 spid24s    
Small Gateway (internal)                     Value
---------------------------------------- ----------
Configured Units                                 96
Available Units                                 96
Acquires                                         0
Waiters                                         0
Threshold Factor                             380000
Threshold                                    380000
2010-02-14 10:07:46.14 spid24s    
Medium Gateway (internal)                     Value
---------------------------------------- ----------
Configured Units                                 24
Available Units                                 24
Acquires                                         0
Waiters                                         0
Threshold Factor                                 12
Threshold                                        -1
2010-02-14 10:07:46.14 spid24s    
Big Gateway (internal)                        Value
---------------------------------------- ----------
Configured Units                                 1
Available Units                                 1
Acquires                                         0
Waiters                                         0
Threshold Factor                                 8
Threshold                                        -1
2010-02-14 10:07:46.14 spid24s    
Optimization Queue (default)                 Value
---------------------------------------- ----------
Overall Memory                         20656103424
Target Memory                            20656103424
Last Notification                                 1
Timeout                                         6
Early Termination Factor                         5
2010-02-14 10:07:46.14 spid24s    
Small Gateway (default)                     Value
---------------------------------------- ----------
Configured Units                                 96
Available Units                                 96
Acquires                                         0
Waiters                                         0
Threshold Factor                             380000
Threshold                                    380000
2010-02-14 10:07:46.14 spid24s    
Medium Gateway (default)                     Value
---------------------------------------- ----------
Configured Units                                 24
Available Units                                 24
Acquires                                         0
Waiters                                         0
Threshold Factor                                 12
Threshold                                        -1
2010-02-14 10:07:46.14 spid24s    
Big Gateway (default)                         Value
---------------------------------------- ----------
Configured Units                                 1
Available Units                                 1
Acquires                                         0
Waiters                                         0
Threshold Factor                                 8
Threshold                                        -1
2010-02-14 10:07:46.14 spid24s    
Memory Pool Manager                         Pages
---------------------------------------- ----------
Reserved Current                                 0
Reserved Limit                             2986478
2010-02-14 10:07:46.14 spid24s    
Memory Pool (internal)                        Pages
---------------------------------------- ----------
Allocations                                    1963
Predicted                                     7982
Private Target                                    0
Private Limit                                     0
Total Target                                2988441
Total Limit                                 2988441
OOM Count                                         0
2010-02-14 10:07:46.14 spid24s    
MEMORYBROKER_FOR_CACHE (internal)             Pages
---------------------------------------- ----------
Allocations                                    1027
Rate                                         5146
Target Allocations                         2521497
Future Allocations                                0
Overall                                     2521497
Last Notification                                 1
2010-02-14 10:07:46.14 spid24s    
MEMORYBROKER_FOR_STEAL (internal)             Pages
---------------------------------------- ----------
Allocations                                     936
Rate                                            873
Target Allocations                         2521497
Future Allocations                                0
Overall                                     2521497
Last Notification                                 1
2010-02-14 10:07:46.14 spid24s    
MEMORYBROKER_FOR_RESERVE (internal)         Pages
---------------------------------------- ----------
Allocations                                     0
Rate                                             0
Target Allocations                         2521497
Future Allocations                                0
Overall                                     2521497
Last Notification                                 1
2010-02-14 10:07:46.14 spid24s    
Memory Pool (default)                         Pages
---------------------------------------- ----------
Allocations                                     0
Predicted                                     450
Private Target                                    0
Private Limit                                     0
Total Target                                2988441
Total Limit                                 2988441
OOM Count                                         0
2010-02-14 10:07:46.14 spid24s    
MEMORYBROKER_FOR_CACHE (default)             Pages
---------------------------------------- ----------
Allocations                                     0
Rate                                             0
Target Allocations                         2521497
Future Allocations                                0
Overall                                     2521497
Last Notification                                 1
2010-02-14 10:07:46.14 spid24s    
MEMORYBROKER_FOR_STEAL (default)             Pages
---------------------------------------- ----------
Allocations                                     0
Rate                                             0
Target Allocations                         2521497
Future Allocations                                0
Overall                                     2521497
Last Notification                                 1
2010-02-14 10:07:46.14 spid24s    
MEMORYBROKER_FOR_RESERVE (default)            Pages
---------------------------------------- ----------
Allocations                                     0
Rate                                             0
Target Allocations                         2521497
Future Allocations                         587773
Overall                                     2521497
Last Notification                                 1
2010-02-14 10:07:46.14 spid24s     Failed allocate pages: FAIL_PAGE_ALLOCATION 1
2010-02-14 10:07:46.14 spid24s    
Memory Manager                                 KB
---------------------------------------- ----------
VM Reserved                                33190188
VM Committed                                 164448
Locked Pages Allocated                            0
Reserved Memory                                1024
Reserved Memory In Use                            0
2010-02-14 10:07:46.14 spid24s    
Memory node Id = 0                             KB
---------------------------------------- ----------
VM Reserved                                 10816
VM Committed                                 10576
Locked Pages Allocated                            0
MultiPage Allocator                            9008
SinglePage Allocator                         16216
2010-02-14 10:07:46.14 spid24s    
Memory node Id = 1                             KB
---------------------------------------- ----------
VM Reserved                                33175724
VM Committed                                 150332
Locked Pages Allocated                            0
MultiPage Allocator                         24216
SinglePage Allocator                         16216
2010-02-14 10:07:46.14 spid24s    
Memory node Id = 64                             KB
---------------------------------------- ----------
VM Reserved                                    2560
VM Committed                                 2504
Locked Pages Allocated                            0
MultiPage Allocator                            2416
SinglePage Allocator                         16216
2010-02-14 10:07:46.14 spid24s    
MEMORYCLERK_SQLGENERAL (node 0)                 KB
---------------------------------------- ----------
VM Reserved                                     0
VM Committed                                     0
Locked Pages Allocated                            0
SM Reserved                                     0
SM Committed                                     0
SinglePage Allocator                         1920
MultiPage Allocator                            3440
2010-02-14 10:07:46.14 spid24s    
MEMORYCLERK_SQLGENERAL (node 1)                 KB
---------------------------------------- ----------
VM Reserved                                     0
VM Committed                                     0
Locked Pages Allocated                            0
SM Reserved                                     0
SM Committed                                     0
SinglePage Allocator                             8
MultiPage Allocator                             0
2010-02-14 10:07:46.14 spid24s    
MEMORYCLERK_SQLGENERAL (Total)                 KB
---------------------------------------- ----------
VM Reserved                                     0
VM Committed                                     0
Locked Pages Allocated                            0
SM Reserved                                     0
SM Committed                                     0
SinglePage Allocator                         1928
MultiPage Allocator                            3440
2010-02-14 10:07:46.14 spid24s    
MEMORYCLERK_SQLBUFFERPOOL (node 0)             KB
---------------------------------------- ----------
VM Reserved                                33079296
VM Committed                                 55152
Locked Pages Allocated                            0
SM Reserved                                     0
SM Committed                                     0
SinglePage Allocator                             0
MultiPage Allocator                             648
2010-02-14 10:07:46.14 spid24s    
MEMORYCLERK_SQLQUERYEXEC (node 0)                KB
---------------------------------------- ----------
VM Reserved                                     0
VM Committed                                     0
Locked Pages Allocated                            0
SM Reserved                                     0
SM Committed                                     0
SinglePage Allocator                            160
MultiPage Allocator                             0
2010-02-14 10:07:46.14 spid24s    
MEMORYCLERK_SQLOPTIMIZER (node 0)                KB
---------------------------------------- ----------
VM Reserved                                     0
VM Committed                                     0
Locked Pages Allocated                            0
SM Reserved                                     0
SM Committed                                     0
SinglePage Allocator                             96
MultiPage Allocator                             944
2010-02-14 10:07:46.14 spid24s    
MEMORYCLERK_SQLUTILITIES (node 0)                KB
---------------------------------------- ----------
VM Reserved                                     360
VM Committed                                    360
Locked Pages Allocated                            0
SM Reserved                                     0
SM Committed                                     0
SinglePage Allocator                            120
MultiPage Allocator                             0
2010-02-14 10:07:46.14 spid24s    
MEMORYCLERK_SQLSTORENG (node 0)                 KB
---------------------------------------- ----------
VM Reserved                                     768
VM Committed                                    768
Locked Pages Allocated                            0
SM Reserved                                     0
SM Committed                                     0
SinglePage Allocator                         1240
MultiPage Allocator                             784
2010-02-14 10:07:46.14 spid24s    
MEMORYCLERK_SQLSTORENG (node 1)                 KB
---------------------------------------- ----------
VM Reserved                                     0
VM Committed                                     0
Locked Pages Allocated                            0
SM Reserved                                     0
SM Committed                                     0
SinglePage Allocator                             48
MultiPage Allocator                            3456
2010-02-14 10:07:46.14 spid24s    
MEMORYCLERK_SQLSTORENG (Total)                 KB
---------------------------------------- ----------
VM Reserved                                     768
VM Committed                                    768
Locked Pages Allocated                            0
SM Reserved                                     0
SM Committed                                     0
SinglePage Allocator                         1288
MultiPage Allocator                            4240
2010-02-14 10:07:46.14 spid24s    
MEMORYCLERK_SQLCONNECTIONPOOL (node 0)         KB
---------------------------------------- ----------
VM Reserved                                     0
VM Committed                                     0
Locked Pages Allocated                            0
SM Reserved                                     0
SM Committed                                     0
SinglePage Allocator                            440
MultiPage Allocator                             0
2010-02-14 10:07:46.14 spid24s    
MEMORYCLERK_SQLCONNECTIONPOOL (node 1)         KB
---------------------------------------- ----------
VM Reserved                                     0
VM Committed                                     0
Locked Pages Allocated                            0
SM Reserved                                     0
SM Committed                                     0
SinglePage Allocator                            184
MultiPage Allocator                             0
2010-02-14 10:07:46.14 spid24s    
MEMORYCLERK_SQLCONNECTIONPOOL (Total)            KB
---------------------------------------- ----------
VM Reserved                                     0
VM Committed                                     0
Locked Pages Allocated                            0
SM Reserved                                     0
SM Committed                                     0
SinglePage Allocator                            624
MultiPage Allocator                             0
2010-02-14 10:07:46.14 spid24s    
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
2010-02-14 10:07:46.14 spid24s    
MEMORYCLERK_SQLSERVICEBROKER (node 0)            KB
---------------------------------------- ----------
VM Reserved                                     0
VM Committed                                     0
Locked Pages Allocated                            0
SM Reserved                                     0
SM Committed                                     0
SinglePage Allocator                            136
MultiPage Allocator                             544
2010-02-14 10:07:46.14 spid24s    
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
2010-02-14 10:07:46.14 spid24s    
MEMORYCLERK_SNI (node 0)                         KB
---------------------------------------- ----------
VM Reserved                                     0
VM Committed                                     0
Locked Pages Allocated                            0
SM Reserved                                     0
SM Committed                                     0
SinglePage Allocator                             0
MultiPage Allocator                             80
2010-02-14 10:07:46.14 spid24s    
MEMORYCLERK_SNI (node 1)                         KB
---------------------------------------- ----------
VM Reserved                                     0
VM Committed                                     0
Locked Pages Allocated                            0
SM Reserved                                     0
SM Committed                                     0
SinglePage Allocator                             8
MultiPage Allocator                             48
2010-02-14 10:07:46.14 spid24s    
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
2010-02-14 10:07:46.14 spid24s    
MEMORYCLERK_SNI (Total)                         KB
---------------------------------------- ----------
VM Reserved                                     0
VM Committed                                     0
Locked Pages Allocated                            0
SM Reserved                                     0
SM Committed                                     0
SinglePage Allocator                             8
MultiPage Allocator                             144
2010-02-14 10:07:46.14 spid24s    
MEMORYCLERK_FULLTEXT (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
2010-02-14 10:07:46.14 spid24s    
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
2010-02-14 10:07:46.14 spid24s    
MEMORYCLERK_XE_BUFFER (node 0)                 KB
---------------------------------------- ----------
VM Reserved                                    2816
VM Committed                                 2816
Locked Pages Allocated                            0
SM Reserved                                     0
SM Committed                                     0
SinglePage Allocator                             0
MultiPage Allocator                             0
2010-02-14 10:07:46.14 spid24s    
MEMORYCLERK_XE_BUFFER (node 1)                 KB
---------------------------------------- ----------
VM Reserved                                    1408
VM Committed                                 1408
Locked Pages Allocated                            0
SM Reserved                                     0
SM Committed                                     0
SinglePage Allocator                             0
MultiPage Allocator                             0
2010-02-14 10:07:46.14 spid24s    
MEMORYCLERK_XE_BUFFER (Total)                    KB
---------------------------------------- ----------
VM Reserved                                    4224
VM Committed                                 4224
Locked Pages Allocated                            0
SM Reserved                                     0
SM Committed                                     0
SinglePage Allocator                             0
MultiPage Allocator                             0
2010-02-14 10:07:46.14 spid24s    
MEMORYCLERK_SOSNODE (node 0)                     KB
---------------------------------------- ----------
VM Reserved                                     0
VM Committed                                     0
Locked Pages Allocated                            0
SM Reserved                                     0
SM Committed                                     0
SinglePage Allocator                         1936
MultiPage Allocator                         15960
2010-02-14 10:07:46.14 spid24s    
MEMORYCLERK_SOSNODE (node 1)                     KB
---------------------------------------- ----------
VM Reserved                                     0
VM Committed                                     0
Locked Pages Allocated                            0
SM Reserved                                     0
SM Committed                                     0
SinglePage Allocator                         1344
MultiPage Allocator                            4624
2010-02-14 10:07:46.14 spid24s    
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
2010-02-14 10:07:46.14 spid24s    
MEMORYCLERK_SOSNODE (Total)                     KB
---------------------------------------- ----------
VM Reserved                                     0
VM Committed                                     0
Locked Pages Allocated                            0
SM Reserved                                     0
SM Committed                                     0
SinglePage Allocator                         3288
MultiPage Allocator                         22920
2010-02-14 10:07:46.14 spid24s    
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
2010-02-14 10:07:46.14 spid24s    
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
2010-02-14 10:07:46.14 spid24s    
MEMORYCLERK_FSAGENT (node 0)                     KB
---------------------------------------- ----------
VM Reserved                                     0
VM Committed                                     0
Locked Pages Allocated                            0
SM Reserved                                     0
SM Committed                                     0
SinglePage Allocator                             8
MultiPage Allocator                             16
2010-02-14 10:07:46.14 spid24s    
MEMORYCLERK_XE (node 0)                         KB
---------------------------------------- ----------
VM Reserved                                     0
VM Committed                                     0
Locked Pages Allocated                            0
SM Reserved                                     0
SM Committed                                     0
SinglePage Allocator                             48
MultiPage Allocator                             168
2010-02-14 10:07:46.14 spid24s    
CACHESTORE_OBJCP (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
2010-02-14 10:07:46.14 spid24s    
CACHESTORE_SQLCP (node 0)                        KB
---------------------------------------- ----------
VM Reserved                                     0
VM Committed                                     0
Locked Pages Allocated                            0
SM Reserved                                     0
SM Committed                                     0
SinglePage Allocator                            264
MultiPage Allocator                            1568
2010-02-14 10:07:46.14 spid24s    
CACHESTORE_PHDR (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
2010-02-14 10:07:46.14 spid24s    
CACHESTORE_XPROC (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
2010-02-14 10:07:46.14 spid24s    
CACHESTORE_TEMPTABLES (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
2010-02-14 10:07:46.14 spid24s    
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
2010-02-14 10:07:46.14 spid24s    
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
2010-02-14 10:07:46.14 spid24s    
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
2010-02-14 10:07:46.14 spid24s    
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
2010-02-14 10:07:46.14 spid24s    
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
2010-02-14 10:07:46.14 spid24s    
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
2010-02-14 10:07:46.14 spid24s    
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
2010-02-14 10:07:46.14 spid24s    
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
2010-02-14 10:07:46.14 spid24s    
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
2010-02-14 10:07:46.14 spid24s    
CACHESTORE_BROKERTBLACS (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
2010-02-14 10:07:46.14 spid24s    
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
2010-02-14 10:07:46.14 spid24s    
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
2010-02-14 10:07:46.14 spid24s    
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
2010-02-14 10:07:46.14 spid24s    
CACHESTORE_BROKERRSB (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
2010-02-14 10:07:46.14 spid24s    
CACHESTORE_BROKERREADONLY (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
2010-02-14 10:07:46.14 spid24s    
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
2010-02-14 10:07:46.14 spid24s    
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
2010-02-14 10:07:46.14 spid24s    
CACHESTORE_SYSTEMROWSET (node 0)                 KB
---------------------------------------- ----------
VM Reserved                                     0
VM Committed                                     0
Locked Pages Allocated                            0
SM Reserved                                     0
SM Committed                                     0
SinglePage Allocator                            304
MultiPage Allocator                             0
2010-02-14 10:07:46.14 spid24s    
CACHESTORE_CONVPRI (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
2010-02-14 10:07:46.14 spid24s    
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
2010-02-14 10:07:46.14 spid24s    
USERSTORE_SCHEMAMGR (node 0)                     KB
---------------------------------------- ----------
VM Reserved                                     0
VM Committed                                     0
Locked Pages Allocated                            0
SM Reserved                                     0
SM Committed                                     0
SinglePage Allocator                            160
MultiPage Allocator                             0
2010-02-14 10:07:46.14 spid24s    
USERSTORE_DBMETADATA (node 0)                    KB
---------------------------------------- ----------
VM Reserved                                     0
VM Committed                                     0
Locked Pages Allocated                            0
SM Reserved                                     0
SM Committed                                     0
SinglePage Allocator                            304
MultiPage Allocator                             0
2010-02-14 10:07:46.14 spid24s    
USERSTORE_TOKENPERM (node 0)                     KB
---------------------------------------- ----------
VM Reserved                                     0
VM Committed                                     0
Locked Pages Allocated                            0
SM Reserved                                     0
SM Committed                                     0
SinglePage Allocator                            368
MultiPage Allocator                             0
2010-02-14 10:07:46.14 spid24s    
USERSTORE_TOKENPERM (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
2010-02-14 10:07:46.14 spid24s    
USERSTORE_TOKENPERM (Total)                     KB
---------------------------------------- ----------
VM Reserved                                     0
VM Committed                                     0
Locked Pages Allocated                            0
SM Reserved                                     0
SM Committed                                     0
SinglePage Allocator                            384
MultiPage Allocator                             0
2010-02-14 10:07:46.14 spid24s    
USERSTORE_OBJPERM (node 0)                     KB
---------------------------------------- ----------
VM Reserved                                     0
VM Committed                                     0
Locked Pages Allocated                            0
SM Reserved                                     0
SM Committed                                     0
SinglePage Allocator                         4728
MultiPage Allocator                             0
2010-02-14 10:07:46.14 spid24s    
USERSTORE_SXC (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
2010-02-14 10:07:46.14 spid24s    
USERSTORE_SXC (node 1)                         KB
---------------------------------------- ----------
VM Reserved                                     0
VM Committed                                     0
Locked Pages Allocated                            0
SM Reserved                                     0
SM Committed                                     0
SinglePage Allocator                             8
MultiPage Allocator                             0
2010-02-14 10:07:46.14 spid24s    
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
2010-02-14 10:07:46.14 spid24s    
USERSTORE_SXC (Total)                            KB
---------------------------------------- ----------
VM Reserved                                     0
VM Committed                                     0
Locked Pages Allocated                            0
SM Reserved                                     0
SM Committed                                     0
SinglePage Allocator                             24
MultiPage Allocator                             0
2010-02-14 10:07:46.14 spid24s    
OBJECTSTORE_LBSS (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
2010-02-14 10:07:46.14 spid24s    
OBJECTSTORE_SNI_PACKET (node 0)                 KB
---------------------------------------- ----------
VM Reserved                                     0
VM Committed                                     0
Locked Pages Allocated                            0
SM Reserved                                     0
SM Committed                                     0
SinglePage Allocator                             96
MultiPage Allocator                             56
2010-02-14 10:07:46.14 spid24s    
OBJECTSTORE_SNI_PACKET (node 1)                 KB
---------------------------------------- ----------
VM Reserved                                     0
VM Committed                                     0
Locked Pages Allocated                            0
SM Reserved                                     0
SM Committed                                     0
SinglePage Allocator                            112
MultiPage Allocator                             56
2010-02-14 10:07:46.14 spid24s    
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
2010-02-14 10:07:46.14 spid24s    
OBJECTSTORE_SNI_PACKET (Total)                 KB
---------------------------------------- ----------
VM Reserved                                     0
VM Committed                                     0
Locked Pages Allocated                            0
SM Reserved                                     0
SM Committed                                     0
SinglePage Allocator                            208
MultiPage Allocator                             168
2010-02-14 10:07:46.14 spid24s    
OBJECTSTORE_SERVICE_BROKER (node 0)             KB
---------------------------------------- ----------
VM Reserved                                     0
VM Committed                                     0
Locked Pages Allocated                            0
SM Reserved                                     0
SM Committed                                     0
SinglePage Allocator                            424
MultiPage Allocator                             0
2010-02-14 10:07:46.14 spid24s    
OBJECTSTORE_LOCK_MANAGER (node 0)                KB
---------------------------------------- ----------
VM Reserved                                 65540
VM Committed                                 65540
Locked Pages Allocated                            0
SM Reserved                                     0
SM Committed                                     0
SinglePage Allocator                            648
MultiPage Allocator                             0
2010-02-14 10:07:46.14 spid24s    
OBJECTSTORE_LOCK_MANAGER (node 1)                KB
---------------------------------------- ----------
VM Reserved                                     0
VM Committed                                     0
Locked Pages Allocated                            0
SM Reserved                                     0
SM Committed                                     0
SinglePage Allocator                            648
MultiPage Allocator                             0
2010-02-14 10:07:46.14 spid24s    
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
2010-02-14 10:07:46.14 spid24s    
OBJECTSTORE_LOCK_MANAGER (Total)                 KB
---------------------------------------- ----------
VM Reserved                                 65540
VM Committed                                 65540
Locked Pages Allocated                            0
SM Reserved                                     0
SM Committed                                     0
SinglePage Allocator                         1320
MultiPage Allocator                             0
2010-02-14 10:07:46.14 spid24s    
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
2010-02-14 10:07:46.14 spid35s     Starting up database 'XX_X2'.
2010-02-14 10:07:46.14 spid24s    
Buffer Pool                                 Value
---------------------------------------- ----------
Committed                                     2609
Target                                     3145728
Database                                        278
Dirty                                             1
In IO                                             1
Latched                                         10
Free                                            269
Stolen                                         2062
Reserved                                         0
Visible                                     3145728
Stolen Potential                            2986380
Limiting Factor                                 17
Last OOM Factor                                 20
Page Life Expectancy                             0
2010-02-14 10:07:46.14 spid24s    
Process/System Counts                         Value
---------------------------------------- ----------
Available Physical Memory                32307183616
Available Virtual Memory                 8761675739136
Available Paging File                    35802009600
Working Set                             105324544
Percent of Committed Memory in WS                62
Page Faults                                 27824
System physical memory high                     1
System physical memory low                        0
Process physical memory low                     0
Process virtual memory low                        0
2010-02-14 10:07:46.14 spid24s    
Procedure Cache                             Value
---------------------------------------- ----------
TotalProcs                                        0
TotalPages                                     233
InUsePages                                        0
2010-02-14 10:07:46.14 spid24s    
Global Memory Objects                         Pages
---------------------------------------- ----------
Resource                                        292
Locks                                         165
XDES                                             65
SETLS                                            24
SE Dataset Allocators                            48
SubpDesc Allocators                             24
SE SchemaManager                                 18
SE Column Metadata Cache                         1
SQLCache                                         0
Replication                                     2
ServerGlobal                                     50
XP Global                                         2
SortTables                                        2
2010-02-14 10:07:46.14 spid24s    
Query Memory Objects (internal)             Value
---------------------------------------- ----------
Grants                                            0
Waiting                                         0
Available                                 2351095
Current Max                                 2351095
Future Max                                 2351095
Physical Max                                2351095
Next Request                                     0
Waiting For                                     0
Cost                                             0
Timeout                                         0
Wait Time                                         0
2010-02-14 10:07:46.14 spid24s    
Small Query Memory Objects (internal)         Value
---------------------------------------- ----------
Grants                                            0
Waiting                                         0
Available                                     12800
Current Max                                 12800
Future Max                                    12800
2010-02-14 10:07:46.14 spid24s    
Query Memory Objects (default)                Value
---------------------------------------- ----------
Grants                                            0
Waiting                                         0
Available                                 2351095
Current Max                                 2351095
Future Max                                 2351095
Physical Max                                2351095
Next Request                                     0
Waiting For                                     0
Cost                                             0
Timeout                                         0
Wait Time                                         0
2010-02-14 10:07:46.14 spid24s    
Small Query Memory Objects (default)         Value
---------------------------------------- ----------
Grants                                            0
Waiting                                         0
Available                                     12800
Current Max                                 12800
Future Max                                    12800
2010-02-14 10:07:46.14 spid24s    
Optimization Queue (internal)                 Value
---------------------------------------- ----------
Overall Memory                         20656103424
Target Memory                            20656103424
Last Notification                                 1
Timeout                                         6
Early Termination Factor                         5
2010-02-14 10:07:46.14 spid24s    
Small Gateway (internal)                     Value
---------------------------------------- ----------
Configured Units                                 96
Available Units                                 96
Acquires                                         0
Waiters                                         0
Threshold Factor                             380000
Threshold                                    380000
2010-02-14 10:07:46.14 spid24s    
Medium Gateway (internal)                     Value
---------------------------------------- ----------
Configured Units                                 24
Available Units                                 24
Acquires                                         0
Waiters                                         0
Threshold Factor                                 12
Threshold                                        -1
2010-02-14 10:07:46.14 spid24s    
Big Gateway (internal)                        Value
---------------------------------------- ----------
Configured Units                                 1
Available Units                                 1
Acquires                                         0
Waiters                                         0
Threshold Factor                                 8
Threshold                                        -1
2010-02-14 10:07:46.14 spid24s    
Optimization Queue (default)                 Value
---------------------------------------- ----------
Overall Memory                         20656103424
Target Memory                            20656103424
Last Notification                                 1
Timeout                                         6
Early Termination Factor                         5
2010-02-14 10:07:46.14 spid24s    
Small Gateway (default)                     Value
---------------------------------------- ----------
Configured Units                                 96
Available Units                                 96
Acquires                                         0
Waiters                                         0
Threshold Factor                             380000
Threshold                                    380000
2010-02-14 10:07:46.14 spid24s    
Medium Gateway (default)                     Value
---------------------------------------- ----------
Configured Units                                 24
Available Units                                 24
Acquires                                         0
Waiters                                         0
Threshold Factor                                 12
Threshold                                        -1
2010-02-14 10:07:46.14 spid24s    
Big Gateway (default)                         Value
---------------------------------------- ----------
Configured Units                                 1
Available Units                                 1
Acquires                                         0
Waiters                                         0
Threshold Factor                                 8
Threshold                                        -1
2010-02-14 10:07:46.14 spid24s    
Memory Pool Manager                         Pages
---------------------------------------- ----------
Reserved Current                                 0
Reserved Limit                             2986478
2010-02-14 10:07:46.14 spid24s    
Memory Pool (internal)                        Pages
---------------------------------------- ----------
Allocations                                    1963
Predicted                                     7982
Private Target                                    0
Private Limit                                     0
Total Target                                2988441
Total Limit                                 2988441
OOM Count                                         0
2010-02-14 10:07:46.14 spid24s    
MEMORYBROKER_FOR_CACHE (internal)             Pages
---------------------------------------- ----------
Allocations                                    1027
Rate                                         5146
Target Allocations                         2521497
Future Allocations                                0
Overall                                     2521497
Last Notification                                 1
2010-02-14 10:07:46.14 spid24s    
MEMORYBROKER_FOR_STEAL (internal)             Pages
---------------------------------------- ----------
Allocations                                     936
Rate                                            873
Target Allocations                         2521497
Future Allocations                                0
Overall                                     2521497
Last Notification                                 1
2010-02-14 10:07:46.14 spid24s    
MEMORYBROKER_FOR_RESERVE (internal)         Pages
---------------------------------------- ----------
Allocations                                     0
Rate                                             0
Target Allocations                         2521497
Future Allocations                                0
Overall                                     2521497
Last Notification                                 1
2010-02-14 10:07:46.14 spid24s    
Memory Pool (default)                         Pages
---------------------------------------- ----------
Allocations                                     0
Predicted                                     450
Private Target                                    0
Private Limit                                     0
Total Target                                2988441
Total Limit                                 2988441
OOM Count                                         0
2010-02-14 10:07:46.14 spid24s    
MEMORYBROKER_FOR_CACHE (default)             Pages
---------------------------------------- ----------
Allocations                                     0
Rate                                             0
Target Allocations                         2521497
Future Allocations                                0
Overall                                     2521497
Last Notification                                 1
2010-02-14 10:07:46.14 spid24s    
MEMORYBROKER_FOR_STEAL (default)             Pages
---------------------------------------- ----------
Allocations                                     0
Rate                                             0
Target Allocations                         2521497
Future Allocations                                0
Overall                                     2521497
Last Notification                                 1
2010-02-14 10:07:46.14 spid24s    
MEMORYBROKER_FOR_RESERVE (default)            Pages
---------------------------------------- ----------
Allocations                                     0
Rate                                             0
Target Allocations                         2521497
Future Allocations                         587773
Overall                                     2521497
Last Notification                                 1
2010-02-14 10:07:46.18 spid24s     Error: 701, Severity: 17, State: 57.
2010-02-14 10:07:46.18 spid24s     There is insufficient system memory in resource pool 'internal' to run this query.
2010-02-14 10:07:46.39 spid18s     Starting up database 'tempdb'.


After that in errorlog there were constantly messages

2010-02-14 10:08:57.42 spid54     Error: 913, Severity: 16, State: 4.
2010-02-14 10:08:57.42 spid54     Could not find database ID 5. Database may not be activated yet or may be in transition. Reissue the query once the database is available. If you do not think this error is due to a database that is transitioning its state and this error continues to occur, contact your primary support provider. Please have available for review the Microsoft SQL Server error log and any additional information relevant to the circumstances when the error occurred.
2010-02-14 10:08:57.62 spid52     Error: 913, Severity: 16, State: 4.
2010-02-14 10:08:57.62 spid52     Could not find database ID 5. Database may not be activated yet or may be in transition. Reissue the query once the database is available. If you do not think this error is due to a database that is transitioning its state and this error continues to occur, contact your primary support provider. Please have available for review the Microsoft SQL Server error log and any additional information relevant to the circumstances when the error occurred.
2010-02-14 10:08:58.37 spid62     Error: 913, Severity: 16, State: 4.
2010-02-14 10:08:58.37 spid62     Could not find database ID 5. Database may not be activated yet or may be in transition. Reissue the query once the database is available. If you do not think this error is due to a database that is transitioning its state and this error continues to occur, contact your primary support provider. Please have available for review the Microsoft SQL Server error log and any additional information relevant to the circumstances when the error occurred.
2010-02-14 10:08:58.43 spid51     Error: 913, Severity: 16, State: 4.
2010-02-14 10:08:58.43 spid51     Could not find database ID 5. Database may not be activated yet or may be in transition. Reissue the query once the database is available. If you do not think this error is due to a database that is transitioning its state and this error continues to occur, contact your primary support provider. Please have available for review the Microsoft SQL Server error log and any additional information relevant to the circumstances when the error occurred.
2010-02-14 10:08:58.67 spid55     Error: 913, Severity: 16, State: 4.
2010-02-14 10:08:58.67 spid55     Could not find database ID 5. Database may not be activated yet or may be in transition. Reissue the query once the database is available. If you do not think this error is due to a database that is transitioning its state and this error continues to occur, contact your primary support provider. Please have available for review the Microsoft SQL Server error log and any additional information relevant to the circumstances when the error occurred.
2010-02-14 10:08:59.36 spid58     Error: 913, Severity: 16, State: 4.
2010-02-14 10:08:59.36 spid58     Could not find database ID 5. Database may not be activated yet or may be in transition. Reissue the query once the database is available. If you do not think this error is due to a database that is transitioning its state and this error continues to occur, contact your primary support provider. Please have available for review the Microsoft SQL Server error log and any additional information relevant to the circumstances when the error occurred.
2010-02-14 10:08:59.43 spid54     Error: 913, Severity: 16, State: 4.
2010-02-14 10:08:59.43 spid54     Could not find database ID 5. Database may not be activated yet or may be in transition. Reissue the query once the database is available. If you do not think this error is due to a database that is transitioning its state and this error continues to occur, contact your primary support provider. Please have available for review the Microsoft SQL Server error log and any additional information relevant to the circumstances when the error occurred.
2010-02-14 10:08:59.70 spid52     Error: 913, Severity: 16, State: 4.
2010-02-14 10:08:59.70 spid52     Could not find database ID 5. Database may not be activated yet or may be in transition. Reissue the query once the database is available. If you do not think this error is due to a database that is transitioning its state and this error continues to occur, contact your primary support provider. Please have available for review the Microsoft SQL Server error log and any additional information relevant to the circumstances when the error occurred.
2010-02-14 10:09:00.34 spid62     Error: 913, Severity: 16, State: 4.
2010-02-


sql server version
Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (X64) Jul 9 2008 14:17:44 Copyright (c) 1988-2008 Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 5.2 <X64> (Build 3790: Service Pack 2)


There is 32 Gb RAM on this server.
Memory settings for the sql server -
Minimum server memory - 0
Maximum server memory - 24576 MB
Minimum memory per query - 1024 KB
After restarting sql server service database started up successfuly.
Do you can understand why this happened?
Posted by Microsoft on 8/12/2008 at 7:40 PM
This error is somewhat generic, and only indicates that some action failed due to overall memory usage on the system. In order to determine what was using that memory a complete errorlog containing detailed information about the system state is needed.

Thanks,
Jerome Halmans
SQLOS
Posted by VincentYo on 2/26/2008 at 11:49 AM
I know this thread is nearly a year old with no response, but I am getting similar errors, so I figured I'd post them:
02/26/2008 13:00:16,spid105,Unknown,There is insufficient system memory to run this query.
02/26/2008 13:00:16,spid105,Unknown,Error: 701<c/> Severity: 17<c/> State: 193.
02/26/2008 13:00:16,spid81,Unknown,There is insufficient system memory to run this query.
02/26/2008 13:00:16,spid81,Unknown,Error: 701<c/> Severity: 17<c/> State: 130.
02/26/2008 13:00:16,spid92,Unknown,There is insufficient system memory to run this query.
02/26/2008 13:00:16,spid92,Unknown,Error: 701<c/> Severity: 17<c/> State: 130.
02/26/2008 13:00:16,spid90,Unknown,There is insufficient system memory to run this query.
02/26/2008 13:00:16,spid90,Unknown,Error: 701<c/> Severity: 17<c/> State: 130.
02/26/2008 13:00:16,Server,Unknown,Failed allocate pages: FAIL_PAGE_ALLOCATION 1
Posted by Microsoft on 8/1/2007 at 12:01 PM
The errorlog should have the memory status output (quite a long one) right after this entry:
2007-05-29 14:03:41.010 spid75 Failed allocate pages:
FAIL_PAGE_ALLOCATION 1

Could you please post it? Please make sure you get the complete output. It ends with something similar to this:

2007-07-30 20:09:05.81 spid104    
MEMORYBROKER_FOR_RESERVE                Pages
---------------------------------------- ----------
Allocations                                    1097
Rate                                         -9894
Target Allocations                         150257
Future Allocations                                0
Overall                                     150257
Last Notification                                 1
Posted by Unregistered User on 5/30/2007 at 6:11 AM
The first rows in the SQL Server log that indicated the beginning of the problem are:
05/30/2007 13:40:10,spid155,Unknown,Error: 701<c/> Severity: 17<c/> State: 135.
05/30/2007 13:40:10,spid323,Unknown,There is insufficient system memory to run this query.
05/30/2007 13:40:10,spid323,Unknown,Error: 701<c/> Severity: 17<c/> State: 123.
05/30/2007 13:40:10,spid113,Unknown,There is insufficient system memory to run this query.
05/30/2007 13:40:10,spid113,Unknown,Error: 701<c/> Severity: 17<c/> State: 135.
05/30/2007 13:40:10,spid295,Unknown,There is insufficient system memory to run this query.
05/30/2007 13:40:10,spid295,Unknown,Error: 701<c/> Severity: 17<c/> State: 135.
05/30/2007 13:40:10,spid225,Unknown,Failed allocate pages: FAIL_PAGE_ALLOCATION 1
Posted by Unregistered User on 5/30/2007 at 5:30 AM
The first rows in the SQL Server log that indicated the beginning of the problem are:
05/30/2007 13:40:10,spid155,Unknown,Error: 701<c/> Severity: 17<c/> State: 135.
05/30/2007 13:40:10,spid323,Unknown,There is insufficient system memory to run this query.
05/30/2007 13:40:10,spid323,Unknown,Error: 701<c/> Severity: 17<c/> State: 123.
05/30/2007 13:40:10,spid113,Unknown,There is insufficient system memory to run this query.
05/30/2007 13:40:10,spid113,Unknown,Error: 701<c/> Severity: 17<c/> State: 135.
05/30/2007 13:40:10,spid295,Unknown,There is insufficient system memory to run this query.
05/30/2007 13:40:10,spid295,Unknown,Error: 701<c/> Severity: 17<c/> State: 135.
05/30/2007 13:40:10,spid225,Unknown,Failed allocate pages: FAIL_PAGE_ALLOCATION 1
Posted by Yaniv Harpaz on 5/30/2007 at 1:33 AM
more than one person encountered this problem.
check out my post and comments:
http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?&query=There+is+insufficient+system+memory+to+run+this+query&lang=en&cr=US&guid=&sloc=en-us&dg=microsoft.public.sqlserver.server&p=1&tid=69d5aa7f-d1f3-4b1a-874e-6a4be180e4d4

and maybe also this:
http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?&guid=&sloc=en-us&dg=microsoft.public.sqlserver.server&p=1&tid=b83d454e-1bb7-4138-977b-112bbf256bb3

Sign in to post a workaround.
Posted by Daniel Susca on 5/18/2009 at 11:18 AM
Hi,

I´m have the same issue run a query from Management Studio. Anyone have some idea how to solve this problem. In my case, works fine after reboot the server but I am not comfortable whit this situation.

Error: 701, Severity: 17, State: 123.
There is insufficient system memory to run this query.
Posted by DwainPattillo on 10/24/2008 at 1:09 PM
CAUSE
This problem occurs because SQL Server 2005 does not release the memory that is allocated to the variable that holds the output parameter value.

RESOLUTION
Cumulative update information
The fix for this issue was first released in Cumulative Update 2. For more information about how to obtain this cumulative update package for SQL Server 2005 Service Pack 2, review the article in the Microsoft Knowledge Base: 936305
Posted by Grices on 4/9/2008 at 4:39 AM
I had this error. Server would be ok for 1/2 hour but then error again.
First thing I found was that the SQL server Max memory available was some very high number 2,000,000+, I changed this to 6000 meg. This stopped the service from crashing but I still got the error. I then found that I needed to Flush all the execution plans because they were using loads of memory. I used "dbcc freeproccache" to do this. I no longer get the errors (so far). I also plan to rebuild all the stats and indexes at the weekend so they take the reduced memory into account.
Posted by BurtDakarax on 3/13/2008 at 6:19 AM
Stop and Re Start the Service - Works for a while
Posted by VincentYo on 2/26/2008 at 12:14 PM
Use MySQL
Posted by rmax1 on 7/12/2007 at 8:46 AM
Because we have a large number of databases and indexes, we attempted adding the -g (specifically -g392) startup parameter. Made no difference, we still see the errors.
Posted by ThomBeaux1 on 7/5/2007 at 1:54 PM
sdfisjd
Posted by MD TRONIC on 6/25/2007 at 11:21 PM
There is insufficient system memory to run this query.