Lazywriter: WARNING in 6.5

Lazywriter: WARNING in 6.5

Post by Bret Stitze » Fri, 16 Mar 2001 03:10:44



I'm having trouble locating any resource for an error I'm getting:
Lazywriter: WARNING, couldn't find slot, 8/8, scanned 8
any ideas?
 
 
 

Lazywriter: WARNING in 6.5

Post by Neil Pik » Fri, 16 Mar 2001 06:01:40


 Bret - usually t's just a disk bottleneck.  You can try upping Max lazywrite
io, but if the disk subsystem is the bottleneck already then it's not going to
help.

 > I'm having trouble locating any resource for an error I'm getting:

Quote:> Lazywriter: WARNING, couldn't find slot, 8/8, scanned 8
> any ideas?

 Neil Pike MVP/MCSE.  Protech Computing Ltd
 Reply here - no email
 SQL FAQ (484 entries) see
 http://forumsb.compuserve.com/gvforums/UK/default.asp?SRV=MSDevApps
 (faqxxx.zip in lib 7)
 or www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
 or www.sqlserverfaq.com
 or www.mssqlserver.com/faq

 
 
 

Lazywriter: WARNING in 6.5

Post by Vaughan Powel » Sat, 17 Mar 2001 02:25:34


I suffered similar problems on SQL Server 6.5 and no matter what we did with MAX ASYNC IO we could not solve the problem.  I upgraded to SQL Server 7 a year ago and never saw a lazywriter error again!!

Regards

Vaughan Powell
MCDBA, MCSD, MCSE
Internet Database Architect

Keybright Services Ltd
<http://www.keybright.co.uk/>

'Databases for the Internet'

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

  _alt.0
1K Download
 
 
 

1. SQL 6.5 Lazywriter Warning.

        I have a handfull of these errors in my log file.  Lazywriter:
WARNING, No free buffers found within the last 5 minutes. These time
frame on the minutes field increases with each error. During this time
no SQL queries were being processed. I couldn't even connect via SQL
Enterprise manager. Had to reboot to recover. Can anyone tell me what
these Warnings mean and any suggestions to prevent them. I've check
the manual, MS web site and the Net to no avail.

Thank you for any help.

-Jess-

2. Forms3.0/Post-Query/update rows selected but not displayed

3. Lazywriter Warning

4. Archibus on Sybase -- db portability problem

5. Lazywriter Warning message

6. Collation Conflict

7. LazyWriter: warning, no free buffers found.

8. Is the MS SQL server 'manageable' with SNMP ?

9. Lazywriter warning

10. Lazywriter: WARNING, couldn't find slot 8/8, scanned 8

11. Lazywriter Warning/Error

12. Lazywriter Warning