SQL Server 2005 SP2 X64 Crashes...LazyWriter: Warning, No Free Buffers Found.
Jun 15, 2007
While waiting for the fax of instructions to contact MS Support, I thought I would post here (tried several times and no fax...)
We get this message in the log file and then all hell breaks loose until it resets memory. The SQL Service continues working but nobody can connect for about 5 minutes and then is seems to reset itself. This has happened three times over the past two weeks. Only one time it did create the SQLDUMP files but all three occurences have practically the same entries.
We are running SQL Server 2005 x64 SP2 under Windows 2003 x64 SP1. We have 4GB RAM and SQL is configured to use 2GB of it. We have a large number of databases (about 400) on this one instance that experiences this problem. The server itself is not under a tremendous load. All of the databases were recently upgraded from SQL 2000 SP4 32 bit instance. The first occurence happened just days after the migration.
----- Log Entries -----
LazyWriter: warning, no free buffers found.
2007-06-14 14:15:56.18 spid3s
Memory Manager
VM Reserved = 4415288 KB
VM Committed = 4398048 KB
AWE Allocated = 0 KB
Reserved Memory = 1024 KB
Reserved Memory In Use = 0 KB
2007-06-14 14:15:56.18 spid3s
Memory node Id = 0
VM Reserved = 4409528 KB
VM Committed = 4392376 KB
AWE Allocated = 0 KB
SinglePage Allocator = 1951840 KB
MultiPage Allocator = 81680 KB
2007-06-14 14:15:56.18 spid3s
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 = 39264 KB
MultiPage Allocator = 21944 KB
2007-06-14 14:15:56.20 spid3s
MEMORYCLERK_SQLBUFFERPOOL (Total)
VM Reserved = 4214784 KB
VM Committed = 4198400 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 0 KB
MultiPage Allocator = 8 KB
2007-06-14 14:15:56.20 spid3s
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 = 264 KB
MultiPage Allocator = 104 KB
2007-06-14 14:15:56.20 spid3s
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 = 26816 KB
MultiPage Allocator = 96 KB
2007-06-14 14:15:56.20 spid3s
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 = 4728 KB
MultiPage Allocator = 0 KB
2007-06-14 14:15:56.20 spid3s
MEMORYCLERK_SQLSTORENG (Total)
VM Reserved = 96768 KB
VM Committed = 96768 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 62192 KB
MultiPage Allocator = 27624 KB
2007-06-14 14:15:56.20 spid3s
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 = 4392 KB
MultiPage Allocator = 0 KB
2007-06-14 14:15:56.20 spid3s
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
2007-06-14 14:15:56.20 spid3s
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 = 624 KB
MultiPage Allocator = 320 KB
2007-06-14 14:15:56.20 spid3s
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
2007-06-14 14:15:56.20 spid3s
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 = 568 KB
MultiPage Allocator = 16 KB
2007-06-14 14:15:56.20 spid3s
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
2007-06-14 14:15:56.20 spid3s
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
2007-06-14 14:15:56.20 spid3s
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 = 336 KB
MultiPage Allocator = 0 KB
2007-06-14 14:15:56.20 spid3s
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 = 8192 KB
MultiPage Allocator = 0 KB
2007-06-14 14:15:56.20 spid3s
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 = 24 KB
MultiPage Allocator = 0 KB
2007-06-14 14:15:56.20 spid3s
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 = 42376 KB
MultiPage Allocator = 27392 KB
2007-06-14 14:15:56.20 spid3s
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
2007-06-14 14:15:56.20 spid3s
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 = 352016 KB
MultiPage Allocator = 432 KB
2007-06-14 14:15:56.20 spid3s
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 = 953192 KB
MultiPage Allocator = 3088 KB
2007-06-14 14:15:56.20 spid3s
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 = 308728 KB
MultiPage Allocator = 0 KB
2007-06-14 14:15:56.20 spid3s
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 = 56 KB
MultiPage Allocator = 0 KB
2007-06-14 14:15:56.20 spid3s
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 = 128 KB
MultiPage Allocator = 0 KB
2007-06-14 14:15:56.20 spid3s
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
2007-06-14 14:15:56.20 spid3s
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
2007-06-14 14:15:56.20 spid3s
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
2007-06-14 14:15:56.20 spid3s
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
2007-06-14 14:15:56.20 spid3s
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
2007-06-14 14:15:56.20 spid3s
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
2007-06-14 14:15:56.20 spid3s
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 = 96 KB
MultiPage Allocator = 0 KB
2007-06-14 14:15:56.20 spid3s
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
2007-06-14 14:15:56.20 spid3s
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
2007-06-14 14:15:56.20 spid3s
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
2007-06-14 14:15:56.20 spid3s
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
2007-06-14 14:15:56.20 spid3s
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
2007-06-14 14:15:56.20 spid3s
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
2007-06-14 14:15:56.20 spid3s
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
2007-06-14 14:15:56.20 spid3s
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 = 43744 KB
MultiPage Allocator = 0 KB
2007-06-14 14:15:56.20 spid3s
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 = 30632 KB
MultiPage Allocator = 16 KB
2007-06-14 14:15:56.20 spid3s
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 = 39856 KB
MultiPage Allocator = 0 KB
2007-06-14 14:15:56.20 spid3s
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 = 14536 KB
MultiPage Allocator = 0 KB
2007-06-14 14:15:56.20 spid3s
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 = 14904 KB
MultiPage Allocator = 0 KB
2007-06-14 14:15:56.20 spid3s
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 = 936 KB
MultiPage Allocator = 0 KB
2007-06-14 14:15:56.20 spid3s
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 = 64 KB
MultiPage Allocator = 400 KB
2007-06-14 14:15:56.20 spid3s
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 = 6584 KB
MultiPage Allocator = 48 KB
2007-06-14 14:15:56.20 spid3s
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
2007-06-14 14:15:56.20 spid3s
OBJECTSTORE_LOCK_MANAGER (Total)
VM Reserved = 8192 KB
VM Committed = 8192 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 4232 KB
MultiPage Allocator = 0 KB
2007-06-14 14:15:56.21 spid3s Buffer Distribution: Stolen=22764 Free=0 Cached=221235
Database (clean)=268686 Database (dirty)=3406
I/O=0, Latched=5
2007-06-14 14:15:56.21 spid3s Buffer Counts: Committed=516096 Target=523990 Hashed=272097
Internal Reservation=104798 External Reservation=1022
Stolen Potential=252769
Min Free=128 Visible=523990
Available Paging File=4634734592
2007-06-14 14:15:56.21 spid3s Procedure Cache: TotalProcs=11768 TotalPages=202189 InUsePages=950
2007-06-14 14:15:56.21 spid3s Process physical/virtual memory pressure: 0/0 System physical memory pressure: 0
2007-06-14 14:15:56.23 spid3s Global Memory Objects:
Resource= 2880
Locks= 532
SE Schema Mgr= 3653
SQLCache= 1622
Replication= 3
ServerGlobal= 49
XPGlobal= 2
Xact= 165
SETLS= 4
DatasetMemObjs= 8
SubpDescPmos= 4
SortTables= 2
2007-06-14 14:15:56.23 spid3s Query Memory Objects: Grants=8 Waiting=0 Maximum=226034 Available=225010 Limit=226048
2007-06-14 14:15:56.23 spid3s Query Memory Objects: Next Request=0 Waiting For=0 Cost=0 Timeout=0 Wait Time=0 Last Target=237945
2007-06-14 14:15:56.23 spid3s Small Query Memory Objects: Grants=0 Waiting=0 Maximum=11895 Available=11895 Limit=11895
2007-06-14 14:15:56.24 spid3s
Optimization Queue
Overall Memory = 3440517120 Target Memory = 1485357056 Last Notification = GROW Timeout = 6 Early Termination Factor = 5
2007-06-14 14:15:56.24 spid3s
Small Gateway
Configured Units = 16 Available Units = 16 Acquires = 0
Waiters = 0 Threshold Factor = 380000 Threshold = 380000
2007-06-14 14:15:56.24 spid3s
Medium Gateway
Configured Units = 4 Available Units = 4 Acquires = 0
Waiters = 0 Threshold Factor = 12 Threshold = -1
2007-06-14 14:15:56.24 spid3s
Big Gateway
Configured Units = 1 Available Units = 1 Acquires = 0
Waiters = 0 Threshold Factor = 8 Threshold = -1
2007-06-14 14:15:56.24 spid3s
MEMORYBROKER_FOR_CACHE
Allocations = 221239
Rate = 0
Target Allocations = 379816
Future Allocations = 0
Last Notification = GROW
2007-06-14 14:15:56.24 spid3s
MEMORYBROKER_FOR_STEAL
Allocations = 22741
Rate = 0
Target Allocations = 181318
Future Allocations = 0
Last Notification = GROW
2007-06-14 14:15:56.24 spid3s
MEMORYBROKER_FOR_RESERVE
Allocations = 1024
Rate = 0
Target Allocations = 253810
Future Allocations = 95233
Last Notification = GROW
2007-06-14 14:39:56.82 Server Resource Monitor (0x1180) Worker 0x000000008000C1C0 appears to be non-yielding on Node 0. Memory freed: 148160 KB. Approx CPU Used: kernel 125 ms, user 62 ms, Interval: 65000.
2007-06-14 14:40:56.84 Server Resource Monitor (0x1180) Worker 0x000000008000C1C0 appears to be non-yielding on Node 0. Memory freed: 218536 KB. Approx CPU Used: kernel 328 ms, user 93 ms, Interval: 125046.
2007-06-14 14:41:56.84 Server Resource Monitor (0x1180) Worker 0x000000008000C1C0 appears to be non-yielding on Node 0. Memory freed: 288960 KB. Approx CPU Used: kernel 515 ms, user 125 ms, Interval: 185046.
2007-06-14 14:42:56.84 Server Resource Monitor (0x1180) Worker 0x000000008000C1C0 appears to be non-yielding on Node 0. Memory freed: 366008 KB. Approx CPU Used: kernel 718 ms, user 171 ms, Interval: 245046.
2007-06-14 14:43:56.84 Server Resource Monitor (0x1180) Worker 0x000000008000C1C0 appears to be non-yielding on Node 0. Memory freed: 435992 KB. Approx CPU Used: kernel 968 ms, user 296 ms, Interval: 305046.
2007-06-14 14:44:56.84 Server Resource Monitor (0x1180) Worker 0x000000008000C1C0 appears to be non-yielding on Node 0. Memory freed: 505160 KB. Approx CPU Used: kernel 1203 ms, user 390 ms, Interval: 365046.
2007-06-14 14:45:56.84 Server Resource Monitor (0x1180) Worker 0x000000008000C1C0 appears to be non-yielding on Node 0. Memory freed: 572488 KB. Approx CPU Used: kernel 1468 ms, user 468 ms, Interval: 425046.
2007-06-14 14:46:56.84 Server Resource Monitor (0x1180) Worker 0x000000008000C1C0 appears to be non-yielding on Node 0. Memory freed: 639056 KB. Approx CPU Used: kernel 1703 ms, user 500 ms, Interval: 485046.
View 12 Replies
ADVERTISEMENT
Jun 20, 2008
hi
We have use SQL Server 2005 on 64bit windows 2003 server Cluster. SQL instance stop responding for some leaving application interrupted.
In the Sql Err log I noticed the following information memory errors just before cluster issued stop command to SQlsrvres. Lazywriter gave warning that no free buffers found .
6/20/08 11:02 AMWarning[098] SQLServerAgent terminated (forcefully)
6/20/08 11:02 AMError[382] Logon to server '(local)' failed (DisableAgentXPs)
6/20/08 11:02 AMError[298] SQLServer Error: 258<c/> Unable to complete login process due to delay in prelogin response [SQLSTATE 08001]
6/20/08 11:02 AMError[165] ODBC Error: 0<c/> Login timeout expired [SQLSTATE HYT00]
6/20/08 11:02 AMError[298] SQLServer Error: 258<c/> TCP Provider: Timeout error [258]. [SQLSTATE 08001]
6/20/08 11:02 AMError[311] Thread 'AlertEngine' (ID 3812) is still running
6/20/08 11:02 AMError[311] Thread 'JobInvocationEngine' (ID 860) is still running
6/20/08 11:02 AMError[240] 2 engine thread(s) failed to stop after 30 seconds of waiting
6/20/08 11:01 AMInformation[131] SQLSERVERAGENT service stopping due to a stop request from a user<c/> process<c/> or the OS...
6/20/08 10:58 AMspid2sUnknownMEMORYBROKER_FOR_RESERVE <nl/>
6/20/08 10:58 AMspid2sUnknownMEMORYBROKER_FOR_STEAL <nl/>
6/20/08 10:58 AMspid2sUnknownMEMORYBROKER_FOR_CACHE <nl/>
6/20/08 10:58 AMspid2sUnknownBig Gateway <nl/>
6/20/08 10:58 AMspid2sUnknownMedium Gateway <nl/>
6/20/08 10:58 AMspid2sUnknownSmall Gateway <nl/>
6/20/08 10:58 AMspid2sUnknownOptimization Queue <nl/>
6/20/08 10:58 AMspid2sUnknownSmall Query Memory Objects: Grants=0 Waiting=0 Maximum=12800 Available=12800 Limit=12800
6/20/08 10:58 AMspid2sUnknownQuery Memory Objects: Next Request=0 Waiting For=0 Cost=0 Timeout=0 Wait Time=0 Last Target=787875
6/20/08 10:58 AMspid2sUnknownQuery Memory Objects: Grants=3 Waiting=0 Maximum=775075 Available=774691 Limit=775075
6/20/08 10:58 AMspid2sUnknownGlobal Memory Objects: <nl/>
6/20/08 10:58 AMspid2sUnknownProcess physical/virtual memory pressure: 0/0 System physical memory pressure: 0
6/20/08 10:58 AMspid2sUnknownProcedure Cache: TotalProcs=10446 TotalPages=117316 InUsePages=6442
6/20/08 10:58 AMspid2sUnknownBuffer Counts: Committed=1032192 Target=1048458 Hashed=895536<nl/>
6/20/08 10:58 AMspid2sUnknownBuffer Distribution: Stolen=10949 Free=0 Cached=125707<nl/>
6/20/08 10:58 AMspid2sUnknownOBJECTSTORE_LOCK_MANAGER (Total) <nl/>
6/20/08 10:58 AMspid2sUnknownOBJECTSTORE_SERVICE_BROKER (Total) <nl/>
6/20/08 10:58 AMspid2sUnknownOBJECTSTORE_SNI_PACKET (Total) <nl/>
6/20/08 10:58 AMspid2sUnknownOBJECTSTORE_LBSS (Total) <nl/>
6/20/08 10:58 AMspid2sUnknownUSERSTORE_SXC (Total) <nl/>
6/20/08 10:58 AMspid2sUnknownUSERSTORE_OBJPERM (Total) <nl/>
6/20/08 10:58 AMspid2sUnknownUSERSTORE_TOKENPERM (Total) <nl/>
6/20/08 10:58 AMspid2sUnknownUSERSTORE_DBMETADATA (Total) <nl/>
6/20/08 10:58 AMspid2sUnknownUSERSTORE_SCHEMAMGR (Total) <nl/>
6/20/08 10:58 AMspid2sUnknownCACHESTORE_SYSTEMROWSET (Total) <nl/>
6/20/08 10:58 AMspid2sUnknownCACHESTORE_EVENTS (Total) <nl/>
6/20/08 10:58 AMspid2sUnknownCACHESTORE_BROKERTO (Total) <nl/>
6/20/08 10:58 AMspid2sUnknownCACHESTORE_BROKERREADONLY (Total) <nl/>
6/20/08 10:58 AMspid2sUnknownCACHESTORE_BROKERRSB (Total) <nl/>
6/20/08 10:58 AMspid2sUnknownCACHESTORE_BROKERUSERCERTLOOKUP (Total) <nl/>
6/20/08 10:58 AMspid2sUnknownCACHESTORE_BROKERDSH (Total) <nl/>
6/20/08 10:58 AMspid2sUnknownCACHESTORE_BROKERKEK (Total) <nl/>
6/20/08 10:58 AMspid2sUnknownCACHESTORE_BROKERTBLACS (Total) <nl/>
6/20/08 10:58 AMspid2sUnknownCACHESTORE_STACKFRAMES (Total) <nl/>
6/20/08 10:58 AMspid2sUnknownCACHESTORE_XMLDBATTRIBUTE (Total) <nl/>
6/20/08 10:58 AMspid2sUnknownCACHESTORE_XMLDBELEMENT (Total) <nl/>
6/20/08 10:58 AMspid2sUnknownCACHESTORE_XMLDBTYPE (Total) <nl/>
6/20/08 10:58 AMspid2sUnknownCACHESTORE_VIEWDEFINITIONS (Total) <nl/>
6/20/08 10:58 AMspid2sUnknownCACHESTORE_NOTIF (Total) <nl/>
6/20/08 10:58 AMspid2sUnknownCACHESTORE_TEMPTABLES (Total) <nl/>
6/20/08 10:58 AMspid2sUnknownCACHESTORE_XPROC (Total) <nl/>
6/20/08 10:58 AMspid2sUnknownCACHESTORE_PHDR (Total) <nl/>
6/20/08 10:58 AMspid2sUnknownCACHESTORE_SQLCP (Total) <nl/>
6/20/08 10:58 AMspid2sUnknownCACHESTORE_OBJCP (Total) <nl/>
6/20/08 10:58 AMspid2sUnknownMEMORYCLERK_SQLSERVICEBROKERTRANSPORT (Total) <nl/>
6/20/08 10:58 AMspid2sUnknownMEMORYCLERK_SOSNODE (Total) <nl/>
6/20/08 10:58 AMspid2sUnknownMEMORYCLERK_HOST (Total) <nl/>
6/20/08 10:58 AMspid2sUnknownMEMORYCLERK_SQLQERESERVATIONS (Total) <nl/>
6/20/08 10:58 AMspid2sUnknownMEMORYCLERK_BHF (Total) <nl/>
6/20/08 10:58 AMspid2sUnknownMEMORYCLERK_SQLXP (Total) <nl/>
6/20/08 10:58 AMspid2sUnknownMEMORYCLERK_FULLTEXT (Total) <nl/>
6/20/08 10:58 AMspid2sUnknownMEMORYCLERK_SNI (Total) <nl/>
6/20/08 10:58 AMspid2sUnknownMEMORYCLERK_SQLHTTP (Total) <nl/>
6/20/08 10:58 AMspid2sUnknownMEMORYCLERK_SQLSERVICEBROKER (Total) <nl/>
6/20/08 10:58 AMspid2sUnknownMEMORYCLERK_SQLCLR (Total) <nl/>
6/20/08 10:58 AMspid2sUnknownMEMORYCLERK_SQLCONNECTIONPOOL (Total) <nl/>
6/20/08 10:58 AMspid2sUnknownMEMORYCLERK_SQLSTORENG (Total) <nl/>
6/20/08 10:58 AMspid2sUnknownMEMORYCLERK_SQLUTILITIES (Total) <nl/>
6/20/08 10:58 AMspid2sUnknownMEMORYCLERK_SQLOPTIMIZER (Total) <nl/>
6/20/08 10:58 AMspid2sUnknownMEMORYCLERK_SQLQUERYEXEC (Total) <nl/>
6/20/08 10:58 AMspid2sUnknownMEMORYCLERK_SQLBUFFERPOOL (Total) <nl/>
6/20/08 10:58 AMspid2sUnknownMEMORYCLERK_SQLGENERAL (Total) <nl/>
6/20/08 10:58 AMspid2sUnknownMemory node Id = 0 <nl/>
6/20/08 10:58 AMspid2sUnknownMemory Manager <nl/>
6/20/08 10:58 AMspid2sUnknownLazyWriter: warning<c/> no free buffers found.
View 2 Replies
View Related
Aug 23, 2007
I don€™t know if this is the case but I need some help. We have itanium server with Microsoft SQL Server 2005 - 9.00.3054.00 (Intel IA-64) Mar 23 2007 18:42:19 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2).
We has had lot of problem with that the sqlserver.exe process hangs 100% cpu. It€™s totally non responsive I€™m not even able to contact the server with DAC. The general solution has been just kill the process. Not nice.
https://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=440746&SiteID=17
The log is full of those
Date,Source,Severity,Message
08/16/2007 09:00:38,spid3s,Unknown,LazyWriter: warning<c/> no free buffers found.
08/16/2007 08:55:17,spid3s,Unknown,LazyWriter: warning<c/> no free buffers found.
08/15/2007 13:06:09,spid4s,Unknown,LazyWriter: warning<c/> no free buffers found.
08/14/2007 10:07:08,spid3s,Unknown,LazyWriter: warning<c/> no free buffers found.
08/09/2007 11:07:29,spid3s,Unknown,LazyWriter: warning<c/> no free buffers found.
08/06/2007 09:41:13,spid2s,Unknown,LazyWriter: warning<c/> no free buffers found.
08/06/2007 09:14:50,spid2s,Unknown,LazyWriter: warning<c/> no free buffers found.
08/06/2007 08:54:38,spid2s,Unknown,LazyWriter: warning<c/> no free buffers found.
08/06/2007 08:24:59,spid2s,Unknown,LazyWriter: warning<c/> no free buffers found.
08/03/2007 11:09:54,spid3s,Unknown,LazyWriter: warning<c/> no free buffers found.
08/01/2007 12:30:56,spid2s,Unknown,LazyWriter: warning<c/> no free buffers found.
07/31/2007 10:16:45,spid2s,Unknown,LazyWriter: warning<c/> no free buffers found.
07/30/2007 10:44:22,spid3s,Unknown,LazyWriter: warning<c/> no free buffers found.
07/24/2007 01:03:36,spid3s,Unknown,LazyWriter: warning<c/> no free buffers found.
07/23/2007 01:02:33,spid3s,Unknown,LazyWriter: warning<c/> no free buffers found.
07/16/2007 12:27:52,spid3s,Unknown,LazyWriter: warning<c/> no free buffers found.
07/16/2007 12:25:12,spid3s,Unknown,LazyWriter: warning<c/> no free buffers found.
07/16/2007 11:54:07,spid3s,Unknown,LazyWriter: warning<c/> no free buffers found.
07/16/2007 11:44:16,spid3s,Unknown,LazyWriter: warning<c/> no free buffers found.
07/14/2007 01:04:15,spid3s,Unknown,LazyWriter: warning<c/> no free buffers found.
07/12/2007 06:18:51,spid3s,Unknown,LazyWriter: warning<c/> no free buffers found.
07/12/2007 06:06:49,spid3s,Unknown,LazyWriter: warning<c/> no free buffers found.
07/10/2007 13:20:08,spid3s,Unknown,LazyWriter: warning<c/> no free buffers found.
07/10/2007 13:10:43,spid3s,Unknown,LazyWriter: warning<c/> no free buffers found.
07/09/2007 10:36:27,spid3s,Unknown,LazyWriter: warning<c/> no free buffers found.
07/09/2007 10:28:46,spid3s,Unknown,LazyWriter: warning<c/> no free buffers found.
07/06/2007 10:12:20,spid3s,Unknown,LazyWriter: warning<c/> no free buffers found.
07/06/2007 10:09:39,spid3s,Unknown,LazyWriter: warning<c/> no free buffers found.
07/06/2007 10:06:19,spid3s,Unknown,LazyWriter: warning<c/> no free buffers found.
07/06/2007 10:01:28,spid3s,Unknown,LazyWriter: warning<c/> no free buffers found.
07/06/2007 01:17:08,spid3s,Unknown,LazyWriter: warning<c/> no free buffers found.
07/06/2007 01:13:47,spid3s,Unknown,LazyWriter: warning<c/> no free buffers found.
07/04/2007 10:41:06,spid3s,Unknown,LazyWriter: warning<c/> no free buffers found.
07/03/2007 10:24:24,spid3s,Unknown,LazyWriter: warning<c/> no free buffers found.
07/03/2007 01:22:44,spid3s,Unknown,LazyWriter: warning<c/> no free buffers found.
06/28/2007 01:03:03,spid3s,Unknown,LazyWriter: warning<c/> no free buffers found.
LazyWriter: warning, no free buffers found.
We used to solution to set a fixed as told in the post above and after that the problem went away. At least for the last 4 days.
Is this LazyWriter not fixed in SP2 for itanium or what?
View 5 Replies
View Related
Dec 6, 2000
We see the following message in our error log.
WARNING: Clearing procedure cache to free contiguous memory.
It is accomonpanied by fairly intensive CPU activity.
We get this roughly once per working day.
Anyone have any idea why, and what we can do to stop this?
Regads,
Jim Plant
View 2 Replies
View Related
Jun 29, 2006
Hi,
A long time ago I posted this: http://blogs.conchango.com/jamiethomson/archive/2005/06/09/1583.aspx explaining all the different buffer types in the pipeline.
I have to admit I'm still not clear on the difference between a private buffer and a flat buffer though.
Are flat buffers a subset of private buffers.
If so, if a private buffer is not a flat buffer - what is it?
If not, can a buffer be a private buffer AND a flat buffer?
Some descriptions from BOL are:
Private buffers: A private buffer is a buffer that a transformation uses for temporary work only
Flat buffers: Flat buffers are blocks of memory that a component uses to store data
That sounds like two ways of saying the same thing to me! It certainly doesn't distinguish them anyway!
Just seeking some clarification here. If you could whip of a demo package that explains the difference between the two (with reference to the Performance Counters) then that would be great.
Thanks
Jamie
View 4 Replies
View Related
Sep 27, 2013
I am having problems with the "Duplicate key was ignored" warning message. The problem is that the message seems to happen randomly and cannot be reproduced. If i take the same set of data and run the stored procedure that causes the problem i don't get the warning message a second or subsequent time. Also all the SELECT statements have criteria set to remove duplicates before they are inserted into the tables.
I have a data feed that pulls data from a DB2 database to a SQL Server 2008 staging table as a flattened set of records. A stored procedure in SQL Server is run to load the data into the destination tables. The data feed is run hourly for new and updated records in DB2 Monday-Friday 09:00-17:00 and then there is a midnight run of all the records going back for the last 12 months.
The data feed was originally sent from DB2 as a CSV file and pulled into SQL Server using SSIS but is now an Informatica workflow that pulls the data directly from DB2.
It is the Informatica workflow that is returning the "duplicate key was ignored" warning message and this stops the workflow. The workflow is restarted and the data is always loaded the second time without the warning message. The warning does not happen every time the workflow is run - it can run for a number of days with no warnings and then one will come through I can see in Profiler that it is SQL Server that returns the Duplicate key was ignored warning message so it is not an issue with Informatica.
I cannot reproduce the problem to get to the root cause of the issue. I would expect that if i run the same set of data through the stored procedure i would get the warning message every time, but this is not the case. Even when i step through the stored procedure i do not get the message. As the midnight data feed returns the records from the last 12 months, so by definition would include duplicates, the warning message only appears randomly and is not consistent.
View 8 Replies
View Related
Jan 4, 2006
Hi all, i am getting these type of errors in the managment tool where i try to look a stored p. or see the schema list or listing tables in a database.
THe errors looks like this one below but it does change in the InvalidArgument=Value of '***' *** area it gets numbers 448 1 5 or something else and after the error management studio doesnt work correctly, in the summory window nothing shows up, .
here is the detailed error message Please help.
See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.
************** Exception Text **************
System.ArgumentOutOfRangeException: InvalidArgument=Value of '448' is not valid for 'index'.
Parameter name: index
at System.Windows.Forms.ListView.ListViewItemCollection.get_Item(Int32 index)
at System.Windows.Forms.ListView.set_VirtualListSize(Int32 value)
at Microsoft.SqlServer.Management.UI.VSIntegration.AppIDPackage.RightPaneListViewer.set_VirtualListSize(Int32 value)
at Microsoft.SqlServer.Management.UI.VSIntegration.AppIDPackage.RightPaneListViewer.PopulateView()
at Microsoft.SqlServer.Management.UI.VSIntegration.AppIDPackage.RightPaneListViewer.Microsoft.SqlServer.Management.UI.VSIntegration.AppIDPackage.IReportView.SetReportSource(ReportSource reportSource)
at Microsoft.SqlServer.Management.UI.VSIntegration.AppIDPackage.RightPaneControl.InternalSetReportSource(ReportSource reportSource, IReportView newView)
************** Loaded Assemblies **************
mscorlib
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
----------------------------------------
AppIDPackage
Assembly Version: 9.0.242.0
Win32 Version: 9.00.1399.00
CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/AppIDPackage.DLL
----------------------------------------
System
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
Microsoft.SqlServer.SqlTools.VSIntegration
Assembly Version: 9.0.242.0
Win32 Version: 9.00.1399.00
CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.SqlTools.VSIntegration.DLL
----------------------------------------
Microsoft.VisualStudio.Shell.Interop
Assembly Version: 7.1.40304.0
Win32 Version: 7.0.4054
CodeBase: file:///C:/WINDOWS/assembly/GAC/Microsoft.VisualStudio.Shell.Interop/7.1.40304.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Shell.Interop.dll
----------------------------------------
Microsoft.VisualStudio.OLE.Interop
Assembly Version: 7.1.40304.0
Win32 Version: 7.0.4054
CodeBase: file:///C:/WINDOWS/assembly/GAC/Microsoft.VisualStudio.OLE.Interop/7.1.40304.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.OLE.Interop.dll
----------------------------------------
System.Windows.Forms
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System.Drawing
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
Microsoft.SqlServer.SqlTDiagM
Assembly Version: 9.0.242.0
Win32 Version: 9.00.1399.00
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.SqlTDiagM/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.SqlTDiagM.dll
----------------------------------------
Microsoft.DataWarehouse.SQM
Assembly Version: 9.0.242.0
Win32 Version: 9.00.1399.00
CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.DataWarehouse.SQM.DLL
----------------------------------------
Microsoft.SqlServer.Instapi
Assembly Version: 9.0.242.0
Win32 Version: 9.00.1399.00
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.Instapi/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.Instapi.dll
----------------------------------------
ObjectExplorer
Assembly Version: 9.0.242.0
Win32 Version: 9.00.1399.00
CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/ObjectExplorer.DLL
----------------------------------------
ConnectionDlg
Assembly Version: 9.0.242.0
Win32 Version: 9.00.1399.00
CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/ConnectionDlg.DLL
----------------------------------------
SqlWorkbench.Interfaces
Assembly Version: 9.0.242.0
Win32 Version: 9.00.1399.00
CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/SqlWorkbench.Interfaces.DLL
----------------------------------------
Microsoft.SqlServer.CustomControls
Assembly Version: 9.0.242.0
Win32 Version: 9.00.1399.00
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.CustomControls/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.CustomControls.dll
----------------------------------------
Accessibility
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Accessibility/2.0.0.0__b03f5f7f11d50a3a/Accessibility.dll
----------------------------------------
SqlMgmt
Assembly Version: 9.0.242.0
Win32 Version: 9.00.1399.00
CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/SqlMgmt.DLL
----------------------------------------
Microsoft.SqlServer.RegSvrEnum
Assembly Version: 9.0.242.0
Win32 Version: 9.00.1399.00
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.RegSvrEnum/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.RegSvrEnum.dll
----------------------------------------
EnvDTE
Assembly Version: 8.0.0.0
Win32 Version: 8.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC/EnvDTE/8.0.0.0__b03f5f7f11d50a3a/EnvDTE.dll
----------------------------------------
Microsoft.NetEnterpriseServers.ExceptionMessageBox
Assembly Version: 9.0.242.0
Win32 Version: 9.00.1399.00
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.NetEnterpriseServers.ExceptionMessageBox/9.0.242.0__89845dcd8080cc91/Microsoft.NetEnterpriseServers.ExceptionMessageBox.dll
----------------------------------------
System.Data
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll
----------------------------------------
Microsoft.SqlServer.ConnectionInfo
Assembly Version: 9.0.242.0
Win32 Version: 9.00.1399.00
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.ConnectionInfo/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.ConnectionInfo.dll
----------------------------------------
System.Xml
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
Microsoft.SqlServer.SmoEnum
Assembly Version: 9.0.242.0
Win32 Version: 9.00.1399.00
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.SmoEnum/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.SmoEnum.dll
----------------------------------------
System.Configuration
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
System.Transactions
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Transactions/2.0.0.0__b77a5c561934e089/System.Transactions.dll
----------------------------------------
System.EnterpriseServices
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.EnterpriseServices/2.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll
----------------------------------------
Microsoft.SqlServer.Smo
Assembly Version: 9.0.242.0
Win32 Version: 9.00.1399.00
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.Smo/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.Smo.dll
----------------------------------------
Microsoft.SqlServer.SqlEnum
Assembly Version: 9.0.242.0
Win32 Version: 9.00.1399.00
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.SqlEnum/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.SqlEnum.dll
----------------------------------------
Microsoft.SqlServer.BatchParser
Assembly Version: 9.0.242.0
Win32 Version: 2005.090.1399.00
CodeBase: file:///C:/WINDOWS/assembly/GAC_32/Microsoft.SqlServer.BatchParser/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.BatchParser.dll
----------------------------------------
msvcm80
Assembly Version: 8.0.50608.0
Win32 Version: 8.00.50727.42
CodeBase: file:///C:/WINDOWS/WinSxS/x86_Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_8.0.50727.42_x-ww_0de06acd/msvcm80.dll
----------------------------------------
System.Management
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Management/2.0.0.0__b03f5f7f11d50a3a/System.Management.dll
----------------------------------------
ObjectExplorerReplication
Assembly Version: 9.0.242.0
Win32 Version: 9.00.1399.00
CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/ObjectExplorerReplication.DLL
----------------------------------------
Microsoft.ReportViewer.WinForms
Assembly Version: 8.0.0.0
Win32 Version: 8.0.50727.42
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.ReportViewer.WinForms/8.0.0.0__b03f5f7f11d50a3a/Microsoft.ReportViewer.WinForms.dll
----------------------------------------
SQLEditors
Assembly Version: 9.0.242.0
Win32 Version: 9.00.1399.00
CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/SQLEditors.DLL
----------------------------------------
Microsoft.VisualStudio.TextManager.Interop
Assembly Version: 7.1.40304.0
Win32 Version: 7.0.4054
CodeBase: file:///C:/WINDOWS/assembly/GAC/Microsoft.VisualStudio.TextManager.Interop/7.1.40304.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.TextManager.Interop.dll
----------------------------------------
SqlManagerUI
Assembly Version: 9.0.242.0
Win32 Version: 9.00.1399.00
CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/SqlManagerUi.DLL
----------------------------------------
Microsoft.AnalysisServices
Assembly Version: 9.0.242.0
Win32 Version: 9.00.1399.00
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.AnalysisServices/9.0.242.0__89845dcd8080cc91/Microsoft.AnalysisServices.dll
----------------------------------------
Microsoft.SqlServer.GridControl
Assembly Version: 9.0.242.0
Win32 Version: 9.00.1399.00
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.GridControl/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.GridControl.dll
----------------------------------------
Microsoft.SqlServer.DlgGrid
Assembly Version: 9.0.242.0
Win32 Version: 9.00.1399.00
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.DlgGrid/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.DlgGrid.dll
----------------------------------------
Microsoft.SqlServer.DataStorage
Assembly Version: 9.0.242.0
Win32 Version: 9.00.1399.00
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.DataStorage/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.DataStorage.dll
----------------------------------------
System.Design
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Design/2.0.0.0__b03f5f7f11d50a3a/System.Design.dll
----------------------------------------
Microsoft.VisualStudio
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 built by: RTM
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.VisualStudio/2.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.dll
----------------------------------------
Microsoft.VisualStudio.Shell
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.VisualStudio.Shell/2.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Shell.dll
----------------------------------------
Microsoft.VisualStudio.Shell.Interop.8.0
Assembly Version: 8.0.0.0
Win32 Version: 8.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC/Microsoft.VisualStudio.Shell.Interop.8.0/8.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Shell.Interop.8.0.dll
----------------------------------------
System.Drawing.Design
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing.Design/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.Design.dll
----------------------------------------
Microsoft.VisualStudio.Designer.Interfaces
Assembly Version: 1.0.5000.0
Win32 Version: 1.1.4322.573
CodeBase: file:///C:/WINDOWS/assembly/GAC/Microsoft.VisualStudio.Designer.Interfaces/1.0.5000.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Designer.Interfaces.dll
----------------------------------------
************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.
For example:
<configuration>
<system.windows.forms jitDebugging="true" />
</configuration>
When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.
View 8 Replies
View Related
Mar 16, 2008
Hi,
I just developed a ASP.NET website with SQL Server 2005 as database. I am having connection crash problem when multiple user click on same link to fetch data from the database. If users click on different links or there is few seconds of time gap between the data access, then it works fine. But the connections crash problem only occurs when 2 or more users click same link at same time.
I am using the following kind of Datalayers to access the data from database:
public static ContentInformation GetContentForUpdate(int ContentId)
{
ContentInformation result = new ContentInformation(); ;
SqlCommand command = new SqlCommand();
command.CommandType = CommandType.StoredProcedure;
command.Connection = Connection;
command.CommandText = "Content_GetContentForUpdate1";
SqlParameter parameter = new SqlParameter("@ContentId", SqlDbType.Int);
parameter.Direction = ParameterDirection.Input;
parameter.Value = ContentId;
command.Parameters.Add(parameter);
try
{
command.Connection.Open();
SqlDataReader reader = command.ExecuteReader(CommandBehavior.SingleRow);
if (reader.Read())
{
// read the data
}
reader.Close();
}
catch (SqlException ex)
{
Trace.TraceError(ex.Message);
throw ex;
}
finally
{
command.Connection.Close();
}
return result;
}
I would be really grateful if someone can help me out with this problem. Waiting for the soonest reply. Thanks.
View 7 Replies
View Related
Mar 15, 2008
Hi,
I just developed a ASP.NET website with SQL Server 2005 as database. I am having connection crash problem when multiple user click on same link to fetch data from the database. If users click on different links or there is few seconds of time gap between the data access, then it works fine. But the connections crash problem only occurs when 2 or more users click same link at same time.
I am using the following kind of Datalayers to access the data from database:
public static ContentInformation GetContentForUpdate(int ContentId)
{
ContentInformation result = new ContentInformation(); ;
SqlCommand command = new SqlCommand();
command.CommandType = CommandType.StoredProcedure;
command.Connection = Connection;
command.CommandText = "Content_GetContentForUpdate1";
SqlParameter parameter = new SqlParameter("@ContentId", SqlDbType.Int);
parameter.Direction = ParameterDirection.Input;
parameter.Value = ContentId;
command.Parameters.Add(parameter);
try
{
command.Connection.Open();
SqlDataReader reader = command.ExecuteReader(CommandBehavior.SingleRow);
if (reader.Read())
{
// read the data
}
reader.Close();
}
catch (SqlException ex)
{
Trace.TraceError(ex.Message);
throw ex;
}
finally
{
command.Connection.Close();
}
return result;
}
I would be really grateful if someone can help me out with this problem. Waiting for the soonest reply. Thanks.
View 4 Replies
View Related
Jun 4, 2006
Hello
I have a question: is the SQL Server 2005 mobile edition free? or is it necessary to buy a licence when i use it combinated with a comercial program which i have delevoped by myself and i sell it?
greetings
stefan lederer
View 1 Replies
View Related
Sep 21, 2006
COM Plus Catalog Requirement (Warning)
Messages
COM Plus Catalog Requirement
If SQL Server Setup fails, Setup will roll back the installation but may not remove all .manifest files. The workaround is to rename the files and then rerun Setup. For more information, see How to: Work Around COM+ Check Failure in SQL Server Setup.
View 6 Replies
View Related
Nov 4, 2006
Dear friends
I need to report the amount of free space in each datafile of a database.
I have tried sys.dm_db_file_space_usage , but the documentation says that it only works for the TempDB.
Please help.
Regards
Parviz
View 5 Replies
View Related
Feb 13, 2006
I'm working towards MCAD and as elective I want to do the SQL Server course. The exam is on SQL Server 2000. I was just wondering whether the online course that Microsoft currently have a available for free at https://www.microsoftelearning.com/sqlserver2005/default.aspx would be useful and applicable to SQL Server 2000, or whether it is sufficiently different product to make it confusing to use this as a learning resource.
Also if anyone can point me toward any webcasts for SQL Server that would be great. I listened to Fritz Onion's 15 part series when I studied for my ASP.NET exam and would like to do something similar for SQL Server 2000 if any are available.
View 3 Replies
View Related
Nov 7, 2007
I've tried to installed sql server 2005 developer edition on windows vista home premium but failed many times, almost giving up.
I've installed and turned on all the features of IIS 7.0 but it still failed and I tried to test IIS 7 by running the local host and received this error " HTTP Error 500.0 - Internal Server Error."
I even ran the windows update SP1 for Vista and MDAC 2.8 SP1
I really appreciate any comments and help.
-----
Here are the messages in the windows system check for the sql server 2005 installation:
IIS Feature Requirement (Warning)
Messages
€¢ IIS Feature Requirement
Microsoft Internet Information Services (IIS) is either not installed or is disabled. IIS is required by some SQL Server features. Without IIS, some SQL Server features will not be available for installation. To install all SQL Server features, install IIS from Add or Remove Programs in Control Panel or enable the IIS service through the Control Panel if it is already installed, and then run SQL Server Setup again. For a list of features that depend on IIS, see Features Supported by Editions of SQL Server in Books Online.
View 24 Replies
View Related
Nov 8, 2007
I've tried to installed sql server 2005 developer edition on windows vista home premium but failed many times, almost giving up.
I've installed and turned on all the features of IIS 7.0 but it still failed and I tried to test IIS 7 by running the local host and received this error " HTTP Error 500.0 - Internal Server Error."
I even ran the windows update SP1 for Vista and MDAC 2.8 SP1
I really appreciate any comments and help.
-----
Here are the messages in the windows system check for the sql server 2005 installation:
IIS Feature Requirement (Warning)
Messages
€¢ IIS Feature Requirement
Microsoft Internet Information Services (IIS) is either not installed or is disabled. IIS is required by some SQL Server features. Without IIS, some SQL Server features will not be available for installation. To install all SQL Server features, install IIS from Add or Remove Programs in Control Panel or enable the IIS service through the Control Panel if it is already installed, and then run SQL Server Setup again. For a list of features that depend on IIS, see Features Supported by Editions of SQL Server in Books Online.
View 5 Replies
View Related
May 1, 2007
Hello,
I have been trying to drill down to the cause for this event log message:
"The configuration of the AdminConnectionTCP protocol in the SQL instance
SQLEXPRESS is not valid."
It is reported from the SQLBrowser service as a warning when the service
starts. I have tried starting SQLBrowser.exe with -c flag, but the output reveals no
errors. I have seen this error on three computers. Two are running SQL 2000, 2005
and Express. One was only running Express, but still this message.
I then looked into the log for the SQL Express server itself. It shows this
message on startup:
"Dedicated administrator connection support was not started because it is
not available on this edition of SQL Server. This is an informational message
only. No user action is required."
Now, it appears to me that these two messages may relate to the same
"error" (or rather behaviour by design). So, can anyone confirm that the
warning in the event log from the SQL Browser service occurs becuase of that
the SQL Express edition doesn't allow any "AdminConnection", but the SQL
Browser service isn't aware of that SQL Express edition shouldn't support that, and
reports it as a warning (implying that we can't do much about this warning)?
Thanks for any input on this issue!
View 5 Replies
View Related
Apr 23, 2006
I can't find any information on this. Thanks.
View 1 Replies
View Related
Jul 6, 2007
Hi folks
I attended one of the SQL Server 2005 "Ready to Launch" parties a couple of years ago and was given a complimentary SQL Server Standard Edition CAL along with a copy of the SQL Server 2005 Standard setup DVD.
As there's no mention in the "Ready to Launch" pack of an included Server license I was wondering whether it is possible to install a copy of SQL Server 2005 on a standalone server and use the single CAL in a Production environment without having to purchase a Server license? The pack does include a Product Key - is this the Server license?
Thanks
Chris
View 1 Replies
View Related
Jul 20, 2005
I am looking for an API to flush all data in memory held by SQL Serverto disk. Also, is there a tool for SQL Server like eseutil forExchange that lets you correct a SQL database?
View 5 Replies
View Related
Feb 6, 2007
Hi!
when I'm trying something litle bit more complex thing than string manipulation in calculated field ex: =RunningValue(Fields!SALES.Value, Sum)
It just crashes visual studio when trying to run the report?! I think this could state as a bug in RS?
View 4 Replies
View Related
Dec 15, 2005
Sorry if someone already covered this, but I can't find anything about it.
I just installed (3 hours ago actually) SQL2005 Standard Edition (from the Launch event) on my machine, and i don't seem to have a shortcut to the SQL Server 2005 Management Studio anywhere.
I looked for a likely executable, but couldn't find it anywhere. This wouldn't bother me as much if I could use Enterprise Manager from 2K, but SQL2005 will not allow it to register.
How do I get this going? There are people here that want to inspect it's features, etc. I haven't got anything to show them.
View 25 Replies
View Related
Nov 7, 2007
i just don't kown was happening... please help!....
thanks!
11/06/2007 21:44:25.532 ================================================================================
11/06/2007 21:44:25.548 Hotfix package launched
11/06/2007 21:46:07.532 Attempting to install instance: SQL Server Native Client
11/06/2007 21:46:07.532 Attempting to install target: BTS-108
11/06/2007 21:46:07.548 Attempting to install file: sqlncli.msi
11/06/2007 21:46:07.673 Attempting to install file: \BTS-108c$4afc0bb080422f7b54a29ff48HotFixSqlncliFilessqlncli.msi
11/06/2007 21:46:07.688 Creating MSI install log file at: C:WINDOWSHotfixRedist9LogsRedist9_Hotfix_KB913090_sqlncli.msi.log
11/06/2007 21:46:07.719 Successfully opened registry key: SoftwarePoliciesMicrosoftWindowsInstaller
11/06/2007 21:46:07.735 Failed to read registry key: Debug
11/06/2007 21:46:07.938 MSP returned 0: The installed software already has a higher version update applied.
Product version detected is 9.00.3042.00 while the update version is: 9.00.2047.00.
11/06/2007 21:46:07.954 Successfully opened registry key: SoftwarePoliciesMicrosoftWindowsInstaller
11/06/2007 21:46:07.969 Failed to read registry key: Debug
11/06/2007 21:46:07.985 Successfully installed file: \BTS-108c$4afc0bb080422f7b54a29ff48HotFixSqlncliFilessqlncli.msi
11/06/2007 21:46:08.001 Successfully installed target: BTS-108
11/06/2007 21:46:08.016 Successfully installed instance: SQL Server Native Client
11/06/2007 21:46:08.048
11/06/2007 21:46:08.048 Product Status Summary:
11/06/2007 21:46:08.079 Product: SQL Server Native Client
11/06/2007 21:46:08.094 SQL Server Native Client (RTM ) - Success
11/06/2007 21:46:08.110
11/06/2007 21:46:08.126 Product: Setup Support Files
11/06/2007 21:46:08.141 Setup Support Files (RTM ) - Not Applied
11/06/2007 21:46:08.157
11/06/2007 21:46:08.173 Product: Database Services
11/06/2007 21:46:08.188 Database Services (RTM 1406 ENU) - Not Applied
11/06/2007 21:46:08.204 Reporting Services (RTM 1406 ENU) - Not Applied
11/06/2007 21:46:08.219
11/06/2007 21:46:08.235 Product: Database Services
11/06/2007 21:46:08.266 Database Services (SP2 3042 ENU) - NA
11/06/2007 21:46:08.282 Details: This update requires service pack 0,1. The service pack for product instance SQLEXPRESS is 2. Download the update for service pack 2.
11/06/2007 21:46:08.313
11/06/2007 21:46:08.329 Product: Notification Services
11/06/2007 21:46:08.344 Notification Services (RTM 1406 ENU) - Not Applied
11/06/2007 21:46:08.376
11/06/2007 21:46:08.391 Product: Integration Services
11/06/2007 21:46:08.438 Integration Services (RTM 1399 ENU) - Not Applied
11/06/2007 21:46:08.469
11/06/2007 21:46:08.485 Product: Client Components
11/06/2007 21:46:08.501 Client Components (RTM 1406 ENU) - Not Applied
11/06/2007 21:46:08.516
11/06/2007 21:46:08.532 Product: MSXML 6.0 Parser
11/06/2007 21:46:08.563 MSXML 6.0 Parser (RTM ) - Not Applied
11/06/2007 21:46:08.579
11/06/2007 21:46:08.610 Product: SQLXML4
11/06/2007 21:46:08.626 SQLXML4 (RTM ) - Not Applied
11/06/2007 21:46:08.641
11/06/2007 21:46:08.657 Product: Backward Compatibility
11/06/2007 21:46:08.688 Backward Compatibility (RTM ) - Not Applied
11/06/2007 21:46:08.704
11/06/2007 21:46:08.735 Product: Microsoft SQL Server VSS Writer
11/06/2007 21:46:08.751 Microsoft SQL Server VSS Writer (RTM ) - Not Applied
11/06/2007 21:46:08.766
View 4 Replies
View Related
Apr 21, 2006
I am seeing repeated failures installing SP1 database services with crashes in hotfix.exe being reported and the following appearing in log files:
Property(S): SqlUpgradeMessage = SQL Server Setup has encountered the following problem: [Microsoft][SQL Native Client][SQL Server]Cannot find the object 'dm_exec_query_resource_semaphores', because it does not exist or you do not have permission.. To continue, correct the problem, and then run SQL Server Setup again.
Property(S): UpgradeInstruction = Connect to SQL instance ZENO as sysadmin
Launch SQL statement USE master
Launch script file C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLInstallsysdbupg.sql
Launch script file C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLInstallDbEngine_hotfix_install.sql
Launch script file C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLInstall
epl_hotfix_install.sql
Stop service MSSQLSERVER
MSI (s) (38:80) [09:35:35:246]: Product: Microsoft SQL Server 2005 - Update 'Service Pack 1 for SQL Server Database Services 2005 ENU (KB913090)' could not be installed. Error code 1603. Additional information is available in the log file C:WINDOWSHotfixSQL9LogsSQL9_Hotfix_KB913090_sqlrun_sql.msp.log.
This is happening on a Windows 2003 SP1 system.
Any ideas?
View 19 Replies
View Related
Oct 14, 2007
I just installed Sql Server Reporting Services 2005 on a Windows Server 2003 R2 x64 server. I configured Reporting Services through the Reporting Services Configuration tool and everything has a green checkmark.
I'm trying to connect to the webservice, but keep getting 404 not found errors. I've tried putting the following into a web browser and all return a 404 error:
http://msql01/reports/
http://msql01/reportserver/
http://msql01/reportserver/reportservice.asmx?wsdl
http://msql01/reportserver/reportservice2005.asmx?wsdl
I've tried edting the RSWebApplication.config file using the following configurations (restarting IIS afterwards) without any luck:
<UI>
<ReportServerUrl></ReportServerUrl>
<ReportServerVirtualDirectory>ReportServer</ReportServerVirtualDirectory>
<ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>
</UI>
and
<UI>
<ReportServerUrl>http://msql01/ReportServer/</ReportServerUrl>
<ReportServerVirtualDirectory></ReportServerVirtualDirectory>
<ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>
</UI>
Any help is appreciated!
Thanks,
Rob
View 10 Replies
View Related
Jan 25, 2007
Has anybody ever had VS2005 sometimes crash when deploying reports? It only happens once and awhile, but it is annoying. I was hoping this would go away with service pack 1, but it didn't.
Another problem that I thought would be fixed is when you try to close VS2005 after working on reports and it states "Cannot close because an active modal is active" occasionally.
BJ
View 3 Replies
View Related
Apr 10, 2007
I'm a developer at a medium-sized installation using ReportServer 2005. There's a problem that occurs for some users and not others. After the ReportServer 2005 report has been generated, the user clicks the Print icon. The print dialog comes up; when they click the OK button on the Print dialog, the screen goes black and their machine reboots.
We've then gone to install the latest Microsoft updates on their machine, to no avail.
After the reboot, they can print from, e.g., Microsoft Word or other applications, but they crash the OS when they print from the ReportServer 2005 report.
I know the first time you print from ReportServer, it installs some software on your machine. I don't know if the problem is related to this.
Any ideas would be appreciated.
Charlie
View 17 Replies
View Related
Apr 3, 2007
Ok guys, I am trying to install Sql server 2005 on Vista but I am still stuck with this warning message in the System Configuration Check during Sql server 2K5 installation :
SQL Server Edition Operating System Compatibility (Warning)
Messages
* SQL Server Edition Operating System Compatibility
* Some components of this edition of SQL Server are not supported on this operating system. For details, see 'Hardware and Software Requirements for Installing SQL Server 2005' in Microsoft SQL Server Books Online.
Now, I know I need to install SP2 but how the hell I am going to install SP2 if Sql server 2005 doesn't install any of the components including Sql server Database services, Analysus services, Reporting integration services( only the workstation component is available for installation)?
Any work around for this issue?
P.S.: I didn't install VS.NET 2005 yet, can this solve the problem?
Thanks.
View 8 Replies
View Related
May 29, 2007
Hi Everyone,
I have problem when installing SQL 2005 Enterprise to my Windows 2003 R2 cluster. I install the SQL instance on the first node in my cluster, it analyses the cluster and comes up with no errors or warnings, i answer all the installation questions and proceed with the installation. When installing the SQL engine I see the status changing as the instance is started and then stopped again etc, finally the status changes to "removing backup files" when it get an error that reports:
"The setup has encountered an unexpected error while Completing Commit. The error is: The specified module could not be found."
Unfortunately there isnt any more information to go on. Any help would be appreciated.
View 2 Replies
View Related
Aug 10, 1999
One of my clients has received the following message:
"99/08/10 10:40:15.38 spid2 Lazywriter: WARNING, LRU list is empty (408 free bufs, 3025 total bufs)"
I understand that it has something to do with the caching of data, but how can I fix this error message? Do I need to change the allocation of cache or just add more memory?
View 2 Replies
View Related
Apr 26, 2006
We have an application server running Windows Server 2000 with Sp4. When we use the ODBC data sources connection software, it shows the SQL Server 2000 servers in the drop down box, but none of the new 2005 servers. If we enter the 2005 server name and try to connect, we get the 'Specified SQL Server not found' error message. The connection works fine from a newer Windows XP box and remote connections is enabled. My guess is that we need a new ODBC to connect to SQL Server 2005, but I can't find anything that says this.
View 2 Replies
View Related
May 21, 2008
Hi,
*every processing* of a cube with 7 dimensions 5 measure groups (no table has more than 100.000 rows) hangs while trying to process the measure groups. I have to restart the Analysis Service all the time. But even worse every 2nd processing crashes the whole Analysis Services Process.
The only time I could sucessfully deploy a cube was with 1 measure group only.
How can anyone do any serious work with Analysis Services?
The error messages from evenlog are not helpful either.
Thanks,
Tobias
EventType sql90exception, P1 msmdsrv.exe, P2 9.0.3054.0, P3 46048069, P4 msmdsrv.exe, P5 9.0.3054.0, P6 46048069, P7 0, P8 005e9430, P9 00000000, P10 NIL.
The description for Event ID ( 22 ) in Source ( MSSQLServerOLAPService ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: Internal error: An unexpected exception occured..
View 1 Replies
View Related
Jun 5, 2001
2001/06/04 10:14:05.90 spid2 Lazywriter: WARNING, couldn't find slot, 8/8, scanned 8
Did a check on a NT4 server with RIAD 5, this error message is appearing on numorous occasions, any ideas welcome.
Sean
View 1 Replies
View Related
