What does the message mean LAZYWRITER?greenspun.com : LUSENET : SQL Server Database Administration : One Thread |
What should be made when this message appears in ERRORLOG?99/08/02 21:00:19.50 backup DATABASE dumped with following info: Database Name:master, Creation Date and Time:Aug 2, 99(21:00), Pages dumped:6225, Current Sequence:36371 15975, Sort Order:54, Striped:NO, Number of Dump Devices:1, device info:(VOLID=SS0063 NAME=BKP_MASTER TYPE=DISK FILE=33) 99/08/02 21:05:58.87 spid28 DBCC TRACEON 3605, SPID 28 99/08/02 21:05:58.87 spid28 Checking space allocation for database 6 99/08/02 21:07:26.39 spid2 Lazywriter: WARNING, couldn't find slot, 8/8, scanned 8 99/08/02 21:07:26.40 spid2 Lazywriter: WARNING, couldn't find slot, 8/8, scanned 8 99/08/02 21:07:26.40 spid2 Lazywriter: WARNING, couldn't find slot, 8/8, scanned 8
-- Anonymous, August 26, 1999
Rogerio,This warns of some temporary disk contention for buffer space ('slots') and is nothing to be concerned about.
Eric
-- Anonymous, August 30, 1999
Eric,Thanks for your answer.
Rogirio
-- Anonymous, September 02, 1999