why this happen?

Question

why this happen?

webc

SSC-Addicted

Points: 420
More actions
November 19, 2009 at 4:12 am

#139459

2009-11-19 17:36:33.850spid1sWorktable with partition ID 0 was dropped successfully after repeated attempts.
2009-11-19 17:36:29.050spid166 MEMORYBROKER_FOR_RESERVE Allocations = 63936 Rate = -2048 Target Allocations = 60047 Future Allocations = 29052 Last Notification = SHRINK
2009-11-19 17:36:29.050spid166 MEMORYBROKER_FOR_STEAL Allocations = 23463 Rate = -1558 Target Allocations = 21253 Future Allocations = 0 Last Notification = SHRINK
2009-11-19 17:36:29.050spid166 MEMORYBROKER_FOR_CACHE Allocations = 69709 Rate = -19011 Target Allocations = 49190 Future Allocations = 0 Last Notification = SHRINK
2009-11-19 17:36:29.050spid166 Big Gateway Configured Units = 1 Available Units = 1 Acquires = 0 Waiters = 0 Threshold Factor = 8 Threshold = -1
2009-11-19 17:36:29.050spid166 Medium Gateway Configured Units = 8 Available Units = 8 Acquires = 0 Waiters = 0 Threshold Factor = 12 Threshold = 14508714
2009-11-19 17:36:29.050spid166 Small Gateway Configured Units = 32 Available Units = 31 Acquires = 1 Waiters = 0 Threshold Factor = 250000 Threshold = 250000
2009-11-19 17:36:29.050spid166 Optimization Queue Overall Memory = 1068982272 Target Memory = 174104576 Last Notification = SHRINK Timeout = 6 Early Termination Factor = 5
2009-11-19 17:36:29.050spid166Small Query Memory Objects: Grants=0 Waiting=0 Maximum=2814 Available=2814 Limit=2814
2009-11-19 17:36:29.050spid166Query Memory Objects: Next Request=0 Waiting For=0 Cost=0 Timeout=0 Wait Time=0 Last Target=56280
2009-11-19 17:36:29.050spid166Query Memory Objects: Grants=6 Waiting=0 Maximum=53466 Available=11482 Limit=53466
2009-11-19 17:36:29.050spid166Global Memory Objects: Resource= 247 Locks= 203 SE Schema Mgr= 730 SQLCache= 1218 Replication= 2 ServerGlobal= 26 XPGlobal= 2 Xact= 403 SETLS= 16 DatasetMemObjs= 32 SubpDescPmos= 43 SortTables= 35
2009-11-19 17:36:29.050spid166Process physical/virtual memory pressure: 1/0 System physical memory pressure: 0
2009-11-19 17:36:29.050spid166Procedure Cache: TotalProcs=10445 TotalPages=69283 InUsePages=1754
2009-11-19 17:36:29.050spid166Buffer Counts: Committed=3465216 Target=3465216 Hashed=3348530 Internal Reservation=32563 External Reservation=36475 Stolen Potential=25569 Min Free=1616 Visible=162816 Available Paging File=6928302080
2009-11-19 17:36:29.050spid166Buffer Distribution: Stolen=22427 Free=23994 Cached=70280 Database (clean)=3289524 Database (dirty)=58970 I/O=2, Latched=19
2009-11-19 17:36:29.050spid166 OBJECTSTORE_LOCK_MANAGER (Total) VM Reserved = 4096 KB VM Committed = 4096 KB AWE Allocated = 0 KB SM Reserved = 0 KB SM Committed = 0 KB SinglePage Allocator = 1600 KB MultiPage Allocator = 0 KB
2009-11-19 17:36:29.050spid166 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 = 256 KB MultiPage Allocator = 0 KB
2009-11-19 17:36:29.050spid166 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 = 3064 KB MultiPage Allocator = 48 KB
2009-11-19 17:36:29.050spid166 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 = 616 KB MultiPage Allocator = 0 KB
2009-11-19 17:36:29.050spid166 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 = 240 KB MultiPage Allocator = 0 KB
2009-11-19 17:36:29.050spid166 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 = 1816 KB MultiPage Allocator = 24 KB
2009-11-19 17:36:29.050spid166 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 = 1912 KB MultiPage Allocator = 0 KB
2009-11-19 17:36:29.050spid166 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 = 728 KB MultiPage Allocator = 0 KB
2009-11-19 17:36:29.050spid166 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 = 5848 KB MultiPage Allocator = 0 KB
2009-11-19 17:36:29.050spid166 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 = 680 KB MultiPage Allocator = 0 KB
2009-11-19 17:36:29.050spid166 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
2009-11-19 17:36:29.050spid166 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
2009-11-19 17:36:29.050spid166 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
2009-11-19 17:36:29.050spid166 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
2009-11-19 17:36:29.050spid166 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
2009-11-19 17:36:29.050spid166 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
2009-11-19 17:36:29.050spid166 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
2009-11-19 17:36:29.050spid166 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 = 112 KB MultiPage Allocator = 0 KB
2009-11-19 17:36:29.050spid166 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 = 8 KB
2009-11-19 17:36:29.050spid166 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
2009-11-19 17:36:29.050spid166 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
2009-11-19 17:36:29.050spid166 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 = 16 KB MultiPage Allocator = 0 KB
2009-11-19 17:36:29.050spid166 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
2009-11-19 17:36:29.050spid166 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
2009-11-19 17:36:29.050spid166 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 = 16 KB MultiPage Allocator = 0 KB
2009-11-19 17:36:29.050spid166 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 = 24 KB MultiPage Allocator = 0 KB
2009-11-19 17:36:29.050spid166 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 = 1168 KB MultiPage Allocator = 0 KB
2009-11-19 17:36:29.050spid166 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 = 529992 KB MultiPage Allocator = 7384 KB
2009-11-19 17:36:29.050spid166 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 = 14720 KB MultiPage Allocator = 712 KB
2009-11-19 17:36:29.050spid166 MEMORYCLERK_SQLSERVICEBROKERTRANSPORT (Total) VM Reserved = 0 KB VM Committed = 0 KB AWE Allocated = 0 KB SM Reserved = 0 KB SM Committed = 0 KB SinglePage Allocator = 24 KB MultiPage Allocator = 0 KB
2009-11-19 17:36:29.050spid166 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 = 11864 KB MultiPage Allocator = 6888 KB
2009-11-19 17:36:29.050spid166 MEMORYCLERK_HOST (Total) VM Reserved = 0 KB VM Committed = 0 KB AWE Allocated = 0 KB SM Reserved = 0 KB SM Committed = 0 KB SinglePage Allocator = 88 KB MultiPage Allocator = 64 KB
2009-11-19 17:36:29.050spid166 MEMORYCLERK_SQLQERESERVATIONS (Total) VM Reserved = 0 KB VM Committed = 0 KB AWE Allocated = 0 KB SM Reserved = 0 KB SM Committed = 0 KB SinglePage Allocator = 336896 KB MultiPage Allocator = 0 KB
2009-11-19 17:36:29.050spid166 MEMORYCLERK_BHF (Total) VM Reserved = 0 KB VM Committed = 0 KB AWE Allocated = 0 KB SM Reserved = 0 KB SM Committed = 0 KB SinglePage Allocator = 96 KB MultiPage Allocator = 0 KB
2009-11-19 17:36:29.050spid166 MEMORYCLERK_SQLXP (Total) VM Reserved = 0 KB VM Committed = 0 KB AWE Allocated = 0 KB SM Reserved = 0 KB SM Committed = 0 KB SinglePage Allocator = 16 KB MultiPage Allocator = 0 KB
2009-11-19 17:36:29.050spid166 MEMORYCLERK_FULLTEXT (Total) VM Reserved = 0 KB VM Committed = 0 KB AWE Allocated = 0 KB SM Reserved = 0 KB SM Committed = 0 KB SinglePage Allocator = 16 KB MultiPage Allocator = 0 KB
2009-11-19 17:36:29.050spid166 MEMORYCLERK_SNI (Total) VM Reserved = 0 KB VM Committed = 0 KB AWE Allocated = 0 KB SM Reserved = 0 KB SM Committed = 0 KB SinglePage Allocator = 216 KB MultiPage Allocator = 16 KB
2009-11-19 17:36:29.050spid166 MEMORYCLERK_SQLHTTP (Total) VM Reserved = 0 KB VM Committed = 0 KB AWE Allocated = 0 KB SM Reserved = 0 KB SM Committed = 0 KB SinglePage Allocator = 8 KB MultiPage Allocator = 0 KB
2009-11-19 17:36:29.050spid166 MEMORYCLERK_SQLSERVICEBROKER (Total) VM Reserved = 0 KB VM Committed = 0 KB AWE Allocated = 0 KB SM Reserved = 0 KB SM Committed = 0 KB SinglePage Allocator = 72 KB MultiPage Allocator = 192 KB
2009-11-19 17:36:29.050spid166 MEMORYCLERK_SQLCLR (Total) VM Reserved = 0 KB VM Committed = 0 KB AWE Allocated = 0 KB SM Reserved = 0 KB SM Committed = 0 KB SinglePage Allocator = 8 KB MultiPage Allocator = 0 KB
2009-11-19 17:36:29.050spid166 MEMORYCLERK_SQLCONNECTIONPOOL (Total) VM Reserved = 0 KB VM Committed = 0 KB AWE Allocated = 0 KB SM Reserved = 0 KB SM Committed = 0 KB SinglePage Allocator = 1496 KB MultiPage Allocator = 0 KB
2009-11-19 17:36:29.050spid166 MEMORYCLERK_SQLSTORENG (Total) VM Reserved = 5760 KB VM Committed = 5760 KB AWE Allocated = 0 KB SM Reserved = 0 KB SM Committed = 0 KB SinglePage Allocator = 6088 KB MultiPage Allocator = 400 KB
2009-11-19 17:36:29.050spid166 MEMORYCLERK_SQLUTILITIES (Total) VM Reserved = 120 KB VM Committed = 120 KB AWE Allocated = 0 KB SM Reserved = 0 KB SM Committed = 0 KB SinglePage Allocator = 18600 KB MultiPage Allocator = 0 KB
2009-11-19 17:36:29.050spid166 MEMORYCLERK_SQLOPTIMIZER (Total) VM Reserved = 0 KB VM Committed = 0 KB AWE Allocated = 0 KB SM Reserved = 0 KB SM Committed = 0 KB SinglePage Allocator = 3520 KB MultiPage Allocator = 88 KB
2009-11-19 17:36:29.050spid166 MEMORYCLERK_SQLQUERYEXEC (Total) VM Reserved = 0 KB VM Committed = 0 KB AWE Allocated = 0 KB SM Reserved = 0 KB SM Committed = 0 KB SinglePage Allocator = 78960 KB MultiPage Allocator = 416 KB
2009-11-19 17:36:29.050spid166 MEMORYCLERK_SQLBUFFERPOOL (Total) VM Reserved = 1577496 KB VM Committed = 274968 KB AWE Allocated = 27721728 KB SM Reserved = 0 KB SM Committed = 0 KB SinglePage Allocator = 0 KB MultiPage Allocator = 7032 KB
2009-11-19 17:36:29.050spid166 MEMORYCLERK_SQLGENERAL (Total) VM Reserved = 0 KB VM Committed = 0 KB AWE Allocated = 0 KB SM Reserved = 0 KB SM Committed = 0 KB SinglePage Allocator = 12872 KB MultiPage Allocator = 2856 KB
2009-11-19 17:36:29.050spid166 Memory node Id = 0 VM Reserved = 1617360 KB VM Committed = 313864 KB AWE Allocated = 27721728 KB SinglePage Allocator = 696920 KB MultiPage Allocator = 26264 KB
2009-11-19 17:36:29.050spid166 Memory Manager VM Reserved = 1621520 KB VM Committed = 317872 KB AWE Allocated = 27721728 KB Reserved Memory = 1024 KB Reserved Memory In Use = 0 KB
2009-11-19 17:36:28.870spid153The client was unable to reuse a session with SPID 153, which had been reset for connection pooling. This error may have been caused by an earlier operation failing. Check the error logs for failed operations immediately before this error message.

Viewing 2 posts - 1 through 1 (of 1 total)

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

Henrico Bekker One Orange Chip Points: 27652 More actions · Answer 1

2009-11-19 17:36:28.870 spid153 The client was unable to reuse a session with SPID 153, which had been reset for connection pooling. This error may have been caused by an earlier operation failing. Check the error logs for failed operations immediately before this error message.

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle