Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 SQL Cls failed LazyWriter: no free buffers found.

Author  Topic 

amirs
Constraint Violating Yak Guru

260 Posts
Posted - 2008-06-20 : 08:26:07
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 AM Warning [098] SQLServerAgent terminated (forcefully)
6/20/08 11:02 AM Error [382] Logon to server '(local)' failed (DisableAgentXPs)
6/20/08 11:02 AM Error [298] SQLServer Error: 258<c/> Unable to complete login process due to delay in prelogin response [SQLSTATE 08001]
6/20/08 11:02 AM Error [165] ODBC Error: 0<c/> Login timeout expired [SQLSTATE HYT00]
6/20/08 11:02 AM Error [298] SQLServer Error: 258<c/> TCP Provider: Timeout error [258]. [SQLSTATE 08001]
6/20/08 11:02 AM Error [311] Thread 'AlertEngine' (ID 3812) is still running
6/20/08 11:02 AM Error [311] Thread 'JobInvocationEngine' (ID 860) is still running
6/20/08 11:02 AM Error [240] 2 engine thread(s) failed to stop after 30 seconds of waiting
6/20/08 11:01 AM Information [131] SQLSERVERAGENT service stopping due to a stop request from a user<c/> process<c/> or the OS...
6/20/08 10:58 AM spid2s Unknown MEMORYBROKER_FOR_RESERVE <nl/>
6/20/08 10:58 AM spid2s Unknown MEMORYBROKER_FOR_STEAL <nl/>
6/20/08 10:58 AM spid2s Unknown MEMORYBROKER_FOR_CACHE <nl/>
6/20/08 10:58 AM spid2s Unknown Big Gateway <nl/>
6/20/08 10:58 AM spid2s Unknown Medium Gateway <nl/>
6/20/08 10:58 AM spid2s Unknown Small Gateway <nl/>
6/20/08 10:58 AM spid2s Unknown Optimization Queue <nl/>
6/20/08 10:58 AM spid2s Unknown Small Query Memory Objects: Grants=0 Waiting=0 Maximum=12800 Available=12800 Limit=12800
6/20/08 10:58 AM spid2s Unknown Query Memory Objects: Next Request=0 Waiting For=0 Cost=0 Timeout=0 Wait Time=0 Last Target=787875
6/20/08 10:58 AM spid2s Unknown Query Memory Objects: Grants=3 Waiting=0 Maximum=775075 Available=774691 Limit=775075
6/20/08 10:58 AM spid2s Unknown Global Memory Objects: <nl/>
6/20/08 10:58 AM spid2s Unknown Process physical/virtual memory pressure: 0/0 System physical memory pressure: 0
6/20/08 10:58 AM spid2s Unknown Procedure Cache: TotalProcs=10446 TotalPages=117316 InUsePages=6442
6/20/08 10:58 AM spid2s Unknown Buffer Counts: Committed=1032192 Target=1048458 Hashed=895536<nl/>
6/20/08 10:58 AM spid2s Unknown Buffer Distribution: Stolen=10949 Free=0 Cached=125707<nl/>
6/20/08 10:58 AM spid2s Unknown OBJECTSTORE_LOCK_MANAGER (Total) <nl/>
6/20/08 10:58 AM spid2s Unknown OBJECTSTORE_SERVICE_BROKER (Total) <nl/>
6/20/08 10:58 AM spid2s Unknown OBJECTSTORE_SNI_PACKET (Total) <nl/>
6/20/08 10:58 AM spid2s Unknown OBJECTSTORE_LBSS (Total) <nl/>
6/20/08 10:58 AM spid2s Unknown USERSTORE_SXC (Total) <nl/>
6/20/08 10:58 AM spid2s Unknown USERSTORE_OBJPERM (Total) <nl/>
6/20/08 10:58 AM spid2s Unknown USERSTORE_TOKENPERM (Total) <nl/>
6/20/08 10:58 AM spid2s Unknown USERSTORE_DBMETADATA (Total) <nl/>
6/20/08 10:58 AM spid2s Unknown USERSTORE_SCHEMAMGR (Total) <nl/>
6/20/08 10:58 AM spid2s Unknown CACHESTORE_SYSTEMROWSET (Total) <nl/>
6/20/08 10:58 AM spid2s Unknown CACHESTORE_EVENTS (Total) <nl/>
6/20/08 10:58 AM spid2s Unknown CACHESTORE_BROKERTO (Total) <nl/>
6/20/08 10:58 AM spid2s Unknown CACHESTORE_BROKERREADONLY (Total) <nl/>
6/20/08 10:58 AM spid2s Unknown CACHESTORE_BROKERRSB (Total) <nl/>
6/20/08 10:58 AM spid2s Unknown CACHESTORE_BROKERUSERCERTLOOKUP (Total) <nl/>
6/20/08 10:58 AM spid2s Unknown CACHESTORE_BROKERDSH (Total) <nl/>
6/20/08 10:58 AM spid2s Unknown CACHESTORE_BROKERKEK (Total) <nl/>
6/20/08 10:58 AM spid2s Unknown CACHESTORE_BROKERTBLACS (Total) <nl/>
6/20/08 10:58 AM spid2s Unknown CACHESTORE_STACKFRAMES (Total) <nl/>
6/20/08 10:58 AM spid2s Unknown CACHESTORE_XMLDBATTRIBUTE (Total) <nl/>
6/20/08 10:58 AM spid2s Unknown CACHESTORE_XMLDBELEMENT (Total) <nl/>
6/20/08 10:58 AM spid2s Unknown CACHESTORE_XMLDBTYPE (Total) <nl/>
6/20/08 10:58 AM spid2s Unknown CACHESTORE_VIEWDEFINITIONS (Total) <nl/>
6/20/08 10:58 AM spid2s Unknown CACHESTORE_NOTIF (Total) <nl/>
6/20/08 10:58 AM spid2s Unknown CACHESTORE_TEMPTABLES (Total) <nl/>
6/20/08 10:58 AM spid2s Unknown CACHESTORE_XPROC (Total) <nl/>
6/20/08 10:58 AM spid2s Unknown CACHESTORE_PHDR (Total) <nl/>
6/20/08 10:58 AM spid2s Unknown CACHESTORE_SQLCP (Total) <nl/>
6/20/08 10:58 AM spid2s Unknown CACHESTORE_OBJCP (Total) <nl/>
6/20/08 10:58 AM spid2s Unknown MEMORYCLERK_SQLSERVICEBROKERTRANSPORT (Total) <nl/>
6/20/08 10:58 AM spid2s Unknown MEMORYCLERK_SOSNODE (Total) <nl/>
6/20/08 10:58 AM spid2s Unknown MEMORYCLERK_HOST (Total) <nl/>
6/20/08 10:58 AM spid2s Unknown MEMORYCLERK_SQLQERESERVATIONS (Total) <nl/>
6/20/08 10:58 AM spid2s Unknown MEMORYCLERK_BHF (Total) <nl/>
6/20/08 10:58 AM spid2s Unknown MEMORYCLERK_SQLXP (Total) <nl/>
6/20/08 10:58 AM spid2s Unknown MEMORYCLERK_FULLTEXT (Total) <nl/>
6/20/08 10:58 AM spid2s Unknown MEMORYCLERK_SNI (Total) <nl/>
6/20/08 10:58 AM spid2s Unknown MEMORYCLERK_SQLHTTP (Total) <nl/>
6/20/08 10:58 AM spid2s Unknown MEMORYCLERK_SQLSERVICEBROKER (Total) <nl/>
6/20/08 10:58 AM spid2s Unknown MEMORYCLERK_SQLCLR (Total) <nl/>
6/20/08 10:58 AM spid2s Unknown MEMORYCLERK_SQLCONNECTIONPOOL (Total) <nl/>
6/20/08 10:58 AM spid2s Unknown MEMORYCLERK_SQLSTORENG (Total) <nl/>
6/20/08 10:58 AM spid2s Unknown MEMORYCLERK_SQLUTILITIES (Total) <nl/>
6/20/08 10:58 AM spid2s Unknown MEMORYCLERK_SQLOPTIMIZER (Total) <nl/>
6/20/08 10:58 AM spid2s Unknown MEMORYCLERK_SQLQUERYEXEC (Total) <nl/>
6/20/08 10:58 AM spid2s Unknown MEMORYCLERK_SQLBUFFERPOOL (Total) <nl/>
6/20/08 10:58 AM spid2s Unknown MEMORYCLERK_SQLGENERAL (Total) <nl/>
6/20/08 10:58 AM spid2s Unknown Memory node Id = 0 <nl/>
6/20/08 10:58 AM spid2s Unknown Memory Manager <nl/>
6/20/08 10:58 AM spid2s Unknown LazyWriter: warning<c/> no free buffers found.

sodeep
Master Smack Fu Yak Hacker

7174 Posts
Posted - 2008-06-20 : 10:31:38
Looks like Memory issue?Can you check memory counters for Memory in Performance monitor?
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts
Posted - 2008-06-20 : 23:46:59
This is sql agent error log. How much memory does server have? How did you config memory in sql?
Go to Top of Page
   

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources

Articles

Forums

Blogs

Contact Us

About the Site