By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,266 Members | 1,297 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,266 IT Pros & Developers. It's quick & easy.

No buffers

P: n/a
Ray
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
Jul 23 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Hi

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" <so*****@nowhere.com> wrote in message
news:vT****************@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

Jul 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.