May 1, 2012 at 9:59 am
Hello,
We can't get to databases on my server.
we re boot it the server and it runs fine now,but I would like to know what happend and to prevent from not happenning again.
I checked sql logs and after my system integrity job ran problems starting,because my integrity job for user databases didn't ran and no failed error too.
Thank you
Here is error messages:
2012-04-29 17:17:16.24 spid4s
MEMORYCLERK_SOSNODE (node 0)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 6856 KB
MultiPage Allocator = 12712 KB
2012-04-29 17:17:16.24 spid4s
MEMORYCLERK_SOSNODE (node 1)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 6672 KB
MultiPage Allocator = 6176 KB
2012-04-29 17:17:16.24 spid4s
MEMORYCLERK_SOSNODE (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 13528 KB
MultiPage Allocator = 18888 KB
2012-04-29 17:17:16.24 spid4s
MEMORYCLERK_SQLSERVICEBROKERTRANSPORT (node 0)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 48 KB
MultiPage Allocator = 0 KB
2012-04-29 17:17:16.24 spid4s
MEMORYCLERK_SQLSERVICEBROKERTRANSPORT (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 48 KB
MultiPage Allocator = 0 KB
2012-04-29 17:17:16.25 spid4s
CACHESTORE_OBJCP (node 0)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 38888 KB
MultiPage Allocator = 824 KB
2012-04-29 17:17:16.25 spid4s
CACHESTORE_OBJCP (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 38888 KB
MultiPage Allocator = 824 KB
2012-04-29 17:17:16.25 spid4s
CACHESTORE_SQLCP (node 0)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 1820400 KB
MultiPage Allocator = 1264 KB
2012-04-29 17:17:16.25 spid4s
CACHESTORE_SQLCP (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 1820400 KB
MultiPage Allocator = 1264 KB
2012-04-29 17:17:16.25 spid4s
CACHESTORE_PHDR (node 0)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 11560 KB
MultiPage Allocator = 16 KB
2012-04-29 17:17:16.25 spid4s
CACHESTORE_PHDR (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 11560 KB
MultiPage Allocator = 16 KB
2012-04-29 17:17:16.25 spid4s
CACHESTORE_XPROC (node 0)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 152 KB
MultiPage Allocator = 0 KB
2012-04-29 17:17:16.25 spid4s
CACHESTORE_XPROC (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 152 KB
MultiPage Allocator = 0 KB
2012-04-29 17:17:16.25 spid4s
CACHESTORE_TEMPTABLES (node 0)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 32 KB
MultiPage Allocator = 0 KB
2012-04-29 17:17:16.25 spid4s
CACHESTORE_TEMPTABLES (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 32 KB
MultiPage Allocator = 0 KB
2012-04-29 17:17:16.25 spid4s
CACHESTORE_NOTIF (node 0)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 16 KB
MultiPage Allocator = 0 KB
2012-04-29 17:17:16.25 spid4s
CACHESTORE_NOTIF (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 16 KB
MultiPage Allocator = 0 KB
2012-04-29 17:17:16.25 spid4s
CACHESTORE_VIEWDEFINITIONS (node 0)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 16 KB
MultiPage Allocator = 0 KB
2012-04-29 17:17:16.25 spid4s
CACHESTORE_VIEWDEFINITIONS (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 16 KB
MultiPage Allocator = 0 KB
2012-04-29 17:17:16.25 spid4s
CACHESTORE_XMLDBTYPE (node 0)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 8 KB
MultiPage Allocator = 0 KB
2012-04-29 17:17:16.25 spid4s
CACHESTORE_XMLDBTYPE (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 8 KB
MultiPage Allocator = 0 KB
2012-04-29 17:17:16.25 spid4s
CACHESTORE_XMLDBELEMENT (node 0)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 8 KB
MultiPage Allocator = 0 KB
2012-04-29 17:17:16.25 spid4s
CACHESTORE_XMLDBELEMENT (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 8 KB
MultiPage Allocator = 0 KB
2012-04-29 17:17:16.25 spid4s
CACHESTORE_XMLDBATTRIBUTE (node 0)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 8 KB
MultiPage Allocator = 0 KB
2012-04-29 17:17:16.25 spid4s
CACHESTORE_XMLDBATTRIBUTE (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 8 KB
MultiPage Allocator = 0 KB
2012-04-29 17:17:16.25 spid4s
CACHESTORE_STACKFRAMES (node 0)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 0 KB
MultiPage Allocator = 8 KB
2012-04-29 17:17:16.25 spid4s
CACHESTORE_STACKFRAMES (node 1)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 0 KB
MultiPage Allocator = 8 KB
2012-04-29 17:17:16.25 spid4s
CACHESTORE_STACKFRAMES (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 0 KB
MultiPage Allocator = 16 KB
2012-04-29 17:17:16.25 spid4s
CACHESTORE_BROKERTBLACS (node 0)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 96 KB
MultiPage Allocator = 0 KB
2012-04-29 17:17:16.25 spid4s
CACHESTORE_BROKERTBLACS (node 1)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 8 KB
MultiPage Allocator = 0 KB
2012-04-29 17:17:16.25 spid4s
CACHESTORE_BROKERTBLACS (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 104 KB
MultiPage Allocator = 0 KB
2012-04-29 17:17:16.25 spid4s
CACHESTORE_BROKERKEK (node 0)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 8 KB
MultiPage Allocator = 0 KB
2012-04-29 17:17:16.25 spid4s
CACHESTORE_BROKERKEK (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 8 KB
MultiPage Allocator = 0 KB
2012-04-29 17:17:16.25 spid4s
CACHESTORE_BROKERDSH (node 0)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 8 KB
MultiPage Allocator = 0 KB
2012-04-29 17:17:16.25 spid4s
CACHESTORE_BROKERDSH (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 8 KB
MultiPage Allocator = 0 KB
2012-04-29 17:17:16.25 spid4s
CACHESTORE_BROKERUSERCERTLOOKUP (node 0)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 8 KB
MultiPage Allocator = 0 KB
2012-04-29 17:17:16.25 spid4s
CACHESTORE_BROKERUSERCERTLOOKUP (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 8 KB
MultiPage Allocator = 0 KB
2012-04-29 17:17:16.25 spid4s
CACHESTORE_BROKERRSB (node 0)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 8 KB
MultiPage Allocator = 0 KB
2012-04-29 17:17:16.25 spid4s
CACHESTORE_BROKERRSB (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 8 KB
MultiPage Allocator = 0 KB
2012-04-29 17:17:16.25 spid4s
CACHESTORE_BROKERREADONLY (node 0)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 32 KB
MultiPage Allocator = 0 KB
2012-04-29 17:17:16.25 spid4s
CACHESTORE_BROKERREADONLY (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 32 KB
MultiPage Allocator = 0 KB
2012-04-29 17:17:16.25 spid4s
CACHESTORE_BROKERTO (node 0)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 8 KB
MultiPage Allocator = 0 KB
2012-04-29 17:17:16.25 spid4s
CACHESTORE_BROKERTO (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 8 KB
MultiPage Allocator = 0 KB
2012-04-29 17:17:16.25 spid4s
CACHESTORE_EVENTS (node 0)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 16 KB
MultiPage Allocator = 0 KB
2012-04-29 17:17:16.25 spid4s
CACHESTORE_EVENTS (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 16 KB
MultiPage Allocator = 0 KB
2012-04-29 17:17:16.25 spid4s
CACHESTORE_CLRPROC (node 0)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 32 KB
MultiPage Allocator = 0 KB
2012-04-29 17:17:16.25 spid4s
CACHESTORE_CLRPROC (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 32 KB
MultiPage Allocator = 0 KB
2012-04-29 17:17:16.25 spid4s
CACHESTORE_SYSTEMROWSET (node 0)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 456 KB
MultiPage Allocator = 0 KB
2012-04-29 17:17:16.25 spid4s
CACHESTORE_SYSTEMROWSET (node 1)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 1192 KB
MultiPage Allocator = 0 KB
2012-04-29 17:17:16.25 spid4s
CACHESTORE_SYSTEMROWSET (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 1648 KB
MultiPage Allocator = 0 KB
2012-04-29 17:17:16.25 spid4s
USERSTORE_SCHEMAMGR (node 0)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 2424 KB
MultiPage Allocator = 0 KB
2012-04-29 17:17:16.25 spid4s
USERSTORE_SCHEMAMGR (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 2424 KB
MultiPage Allocator = 0 KB
2012-04-29 17:17:16.25 spid4s
USERSTORE_DBMETADATA (node 0)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 888 KB
MultiPage Allocator = 0 KB
2012-04-29 17:17:16.25 spid4s
USERSTORE_DBMETADATA (node 1)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 7880 KB
MultiPage Allocator = 0 KB
2012-04-29 17:17:16.25 spid4s
USERSTORE_DBMETADATA (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 8768 KB
MultiPage Allocator = 0 KB
2012-04-29 17:17:16.25 spid4s
USERSTORE_TOKENPERM (node 0)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 12808 KB
MultiPage Allocator = 0 KB
2012-04-29 17:17:16.25 spid4s
USERSTORE_TOKENPERM (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 12808 KB
MultiPage Allocator = 0 KB
2012-04-29 17:17:16.25 spid4s
USERSTORE_OBJPERM (node 0)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 408 KB
MultiPage Allocator = 0 KB
2012-04-29 17:17:16.25 spid4s
USERSTORE_OBJPERM (node 1)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 928 KB
MultiPage Allocator = 0 KB
2012-04-29 17:17:16.25 spid4s
USERSTORE_OBJPERM (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 1336 KB
MultiPage Allocator = 0 KB
2012-04-29 17:17:16.25 spid4s
USERSTORE_SXC (node 0)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 112 KB
MultiPage Allocator = 0 KB
2012-04-29 17:17:16.25 spid4s
USERSTORE_SXC (node 1)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 104 KB
MultiPage Allocator = 0 KB
2012-04-29 17:17:16.25 spid4s
USERSTORE_SXC (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 216 KB
MultiPage Allocator = 0 KB
2012-04-29 17:17:16.25 spid4s
OBJECTSTORE_LBSS (node 0)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 128 KB
MultiPage Allocator = 96 KB
2012-04-29 17:17:16.25 spid4s
OBJECTSTORE_LBSS (node 1)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 128 KB
MultiPage Allocator = 160 KB
2012-04-29 17:17:16.25 spid4s
OBJECTSTORE_LBSS (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 256 KB
MultiPage Allocator = 256 KB
2012-04-29 17:17:16.25 spid4s
OBJECTSTORE_SNI_PACKET (node 0)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 760 KB
MultiPage Allocator = 48 KB
2012-04-29 17:17:16.25 spid4s
OBJECTSTORE_SNI_PACKET (node 1)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 520 KB
MultiPage Allocator = 48 KB
2012-04-29 17:17:16.25 spid4s
OBJECTSTORE_SNI_PACKET (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 1280 KB
MultiPage Allocator = 96 KB
2012-04-29 17:17:16.25 spid4s
OBJECTSTORE_SERVICE_BROKER (node 0)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 272 KB
MultiPage Allocator = 0 KB
2012-04-29 17:17:16.25 spid4s
OBJECTSTORE_SERVICE_BROKER (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 272 KB
MultiPage Allocator = 0 KB
2012-04-29 17:17:16.25 spid4s
OBJECTSTORE_LOCK_MANAGER (node 0)
VM Reserved = 16384 KB
VM Committed = 16384 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 6744 KB
MultiPage Allocator = 0 KB
2012-04-29 17:17:16.25 spid4s
OBJECTSTORE_LOCK_MANAGER (node 1)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 9352 KB
MultiPage Allocator = 0 KB
2012-04-29 17:17:16.25 spid4s
OBJECTSTORE_LOCK_MANAGER (Total)
VM Reserved = 16384 KB
VM Committed = 16384 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 16096 KB
MultiPage Allocator = 0 KB
2012-04-29 17:17:16.25 spid4s Buffer Distribution: Stolen=4294882214 Free=0 Cached=341304
Database (clean)=416297 Database (dirty)=101620
I/O=0, Latched=5
2012-04-29 17:17:16.25 spid4s Buffer Counts: Committed=774144 Target=785126 Hashed=517922
Internal Reservation=157025 External Reservation=137048
Stolen Potential=352599
Min Free=512 Visible=785126
Available Paging File=3642658816
2012-04-29 17:17:16.25 spid4s Procedure Cache: TotalProcs=3949 TotalPages=234138 InUsePages=168
2012-04-29 17:17:16.25 spid4s Process physical/virtual memory pressure: 0/0 System physical memory pressure: 0
2012-04-29 17:17:16.31 spid4s Global Memory Objects:
Resource=1264
Locks=2015
SE Schema Mgr=302
SQLCache=2613
Replication=2
ServerGlobal=50
XPGlobal=2
Xact=66
SETLS=16
DatasetMemObjs=32
SubpDescPmos=16
SortTables=1524
2012-04-29 17:17:16.31 spid4s Query Memory Objects: Grants=6 Waiting=0 Maximum=456970 Available=308515 Limit=456940
2012-04-29 17:17:16.31 spid4s Query Memory Objects: Next Request=0 Waiting For=0 Cost=0 Timeout=0 Wait Time=0 Last Target=469740
2012-04-29 17:17:16.31 spid4s Small Query Memory Objects: Grants=0 Waiting=0 Maximum=12800 Available=12800 Limit=12800
2012-04-29 17:17:16.31 spid4s
Optimization Queue
Overall Memory = 5155356672 Target Memory = 2931580928 Last Notification = GROW Timeout = 6 Early Termination Factor = 5
2012-04-29 17:17:16.31 spid4s
Small Gateway
Configured Units = 64 Available Units = 64 Acquires = 0
Waiters = 0 Threshold Factor = 380000 Threshold = 380000
2012-04-29 17:17:16.31 spid4s
Medium Gateway
Configured Units = 16 Available Units = 16 Acquires = 0
Waiters = 0 Threshold Factor = 12 Threshold = -1
2012-04-29 17:17:16.31 spid4s
Big Gateway
Configured Units = 1 Available Units = 1 Acquires = 0
Waiters = 0 Threshold Factor = 8 Threshold = -1
2012-04-29 17:17:16.31 spid4s
MEMORYBROKER_FOR_CACHE
Allocations = 239555
Rate = 0
Target Allocations = 592161
Future Allocations = 0
Last Notification = GROW
2012-04-29 17:17:16.31 spid4s
MEMORYBROKER_FOR_STEAL
Allocations = 5253
Rate = 0
Target Allocations = 357859
Future Allocations = 0
Last Notification = GROW
2012-04-29 17:17:16.31 spid4s
MEMORYBROKER_FOR_RESERVE
Allocations = 148455
Rate = 0
Target Allocations = 501061
Future Allocations = 144295
Last Notification = GROW
May 1, 2012 at 12:38 pm
Can you please provide the version, edition and bitness of your OS and SQL Server instance?
And the results of these queries:
-- memory overview
SELECT CAST(physical_memory_in_bytes / (1024.0 * 1024.0 * 1024.0) AS DECIMAL(20, 2)) AS PhysicalMemoryGB,
CAST(virtual_memory_in_bytes / (1024.0 * 1024 * 1024) AS DECIMAL(20, 2)) AS VasGB,
CAST((bpool_committed * 8) / (1024.0 * 1024.0) AS DECIMAL(20, 2)) AS BufferPoolCommittedMemoryGB,
CAST((bpool_commit_target * 8) / (1024.0 * 1024.0) AS DECIMAL(20, 2)) AS BufferPoolTargetMemoryGB,
(
SELECT CAST(CAST(value_in_use AS INT) / 1024.0 AS DECIMAL(20, 2))
FROM sys.configurations
WHERE name = 'min server memory (MB)'
) AS MinServerMemoryGB,
(
SELECT CAST(CAST(value_in_use AS INT) / 1024.0 AS DECIMAL(20, 2))
FROM sys.configurations
WHERE name = 'max server memory (MB)'
) AS MaxServerMemoryGB,
(
SELECT value_in_use
FROM sys.configurations
WHERE name = 'awe enabled'
) AS IsAweEnabled
FROM sys.dm_os_sys_info;
-- cpu overview
SELECT osi.cpu_count AS LogicalCpuCount,
osi.hyperthread_ratio AS HyperthreadCoreRatio,
osi.cpu_count / osi.hyperthread_ratio AS PhysicalCpuCount,
(
SELECT COUNT(*)
FROM sys.dm_os_schedulers
WHERE scheduler_id < osi.cpu_count
AND is_online = 1
) AS LogicalCpuOnline
FROM sys.dm_os_sys_info osi;
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 1, 2012 at 1:14 pm
PhysicalMemoryGBVasGBBufferPoolCommittedMemoryGB BufferPoolTargetMemoryGB
5.99 8192.00 2.21 3.79
MinServerMemoryGBMaxServerMemoryGBIsAweEnabled
0.00 2097152.00 0
LogicalCpuCountHyperthreadCoreRatioPhysicalCpuCountLogicalCpuOnline
16 8 2 16
May 1, 2012 at 1:20 pm
Krasavita (5/1/2012)
PhysicalMemoryGBVasGBBufferPoolCommittedMemoryGB BufferPoolTargetMemoryGB5.99 8192.00 2.21 3.79
MinServerMemoryGBMaxServerMemoryGB IsAweEnabled
0.00 2097152.00 0
LogicalCpuCountHyperthreadCoreRatioPhysicalCpuCountLogicalCpuOnline
16 8 2 16
Most likely issue is bolded above. You need to set max memory immediately. It does not require a restart and takes effect immediately. Some guidance: Suggested Max Memory Settings for SQL Server 2005/2008[/url]
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 1, 2012 at 1:33 pm
Thank you very much, I will changed it,what is your recomendations is 1500 enough?
May 1, 2012 at 1:37 pm
With 6GB of RAM in your machine 1500MB would be very conservative. 1500MB may make sense for you though, it depends on what else you have running on your server as to how much memory to allocate to the buffer pool (max memory setting only restricts the buffer pool). You need to leave some memory for other programs (including SQL Server non-buffer pool activities) and the OS itself to do work. Have a look at Glenn's article, it's a good start.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 1, 2012 at 1:48 pm
sorry it is 15000 not 1500
May 1, 2012 at 1:51 pm
If you have 6GB RAM then how would setting max memory to 15000MB help you restrict the SQL Server from growing the buffer pool to the point where it affected server performance? The article...read the article 😀
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 1, 2012 at 2:23 pm
I think I'd set max memory to say 4096MB. That would leave about 2GB for the OS.
May 1, 2012 at 2:27 pm
Thank you
May 2, 2012 at 6:46 am
Thank you everyone, but article recomends 6GB set to 4800, how did you come up with that number 4096 and plus 2 gb.
Thank you
May 2, 2012 at 6:51 am
Krasavita (5/2/2012)
Thank you everyone, but article recomends 6GB set to 4800, how did you come up with that number 4096 and plus 2 gb.Thank you
Simple math. Start with 1GB or 1024MB, multiple by 4, gives you 4096MB (4GB), which if you subtract that from 6GB leaves 2GB.
May 2, 2012 at 6:54 am
Thank you
May 2, 2012 at 7:23 am
I have another question, how would I know that I need to add more Ram?
Viewing 14 posts - 1 through 13 (of 13 total)
You must be logged in to reply to this topic. Login to reply