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


Add to briefcase 12»»

Error message:IO Completion Listener Expand / Collapse
Author
Message
Posted Tuesday, May 1, 2012 9:59 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, July 31, 2014 11:58 AM
Points: 1,279, Visits: 1,886
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
Post #1293267
Posted Tuesday, May 1, 2012 12:38 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 7:44 PM
Points: 7,107, Visits: 12,661
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
Post #1293415
Posted Tuesday, May 1, 2012 1:14 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, July 31, 2014 11:58 AM
Points: 1,279, Visits: 1,886
PhysicalMemoryGB VasGB BufferPoolCommittedMemoryGB BufferPoolTargetMemoryGB
5.99 8192.00 2.21 3.79

MinServerMemoryGB MaxServerMemoryGB IsAweEnabled
0.00 2097152.00 0

LogicalCpuCount HyperthreadCoreRatio PhysicalCpuCount LogicalCpuOnline
16 8 2 16
Post #1293455
Posted Tuesday, May 1, 2012 1:20 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 7:44 PM
Points: 7,107, Visits: 12,661
Krasavita (5/1/2012)
PhysicalMemoryGB VasGB BufferPoolCommittedMemoryGB BufferPoolTargetMemoryGB
5.99 8192.00 2.21 3.79

MinServerMemoryGB MaxServerMemoryGB IsAweEnabled
0.00 2097152.00 0

LogicalCpuCount HyperthreadCoreRatio PhysicalCpuCount LogicalCpuOnline
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


__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato
Post #1293461
Posted Tuesday, May 1, 2012 1:33 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, July 31, 2014 11:58 AM
Points: 1,279, Visits: 1,886
Thank you very much, I will changed it,what is your recomendations is 1500 enough?
Post #1293479
Posted Tuesday, May 1, 2012 1:37 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 7:44 PM
Points: 7,107, Visits: 12,661
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
Post #1293484
Posted Tuesday, May 1, 2012 1:48 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, July 31, 2014 11:58 AM
Points: 1,279, Visits: 1,886
sorry it is 15000 not 1500
Post #1293488
Posted Tuesday, May 1, 2012 1:51 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 7:44 PM
Points: 7,107, Visits: 12,661
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
Post #1293490
Posted Tuesday, May 1, 2012 2:23 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 4:18 PM
Points: 20,705, Visits: 32,353
I think I'd set max memory to say 4096MB. That would leave about 2GB for the OS.



Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #1293504
Posted Tuesday, May 1, 2012 2:27 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, July 31, 2014 11:58 AM
Points: 1,279, Visits: 1,886
Thank you
Post #1293506
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse