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

Answers

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


Moderation questions? read the FAQ