No buffers

Occasionally on my SQL 2K SP3 Standard servers. The servers lock up with
the error.

LazyWriter: warning, no free buffers found.

After that I have to restart the SQLServer service to get things up and
running. How can I prevent this from happening?

Thanks,
RayHi

Without knowing the configuration values it is hard to say exactly what is
happening. a likely cause may be lack of memory and it may also mention this
in your SQL Server log.

You may want to search for the error message on Google. There are lots of
posts about pinning tables in 6.5 so your version number is also important
information.

John

"Ray" <someone@.nowhere.com> wrote in message
news:vT3Ad.4051$Y8.1567@.newssvr17.news.prodigy.com ...
> Occasionally on my SQL 2K SP3 Standard servers. The servers lock up with
> the error.
> LazyWriter: warning, no free buffers found.
> After that I have to restart the SQLServer service to get things up and
> running. How can I prevent this from happening?
> Thanks,
> Ray