Monday, March 19, 2012

a time out has occurred while waiting for buffer latch type 4

We are getting this error on SQL Server 2000 ( SP3)
" a time out has occurred while waiting for buffer latch type 4 "
As per Microsoft this may happen when memory is >3GB and awe enabled ,and
this is fixed in SP2
But in my case
SQL Server 2000 -Standard Edition (SP3)
AWE disabled
OS Memory -- 2GB
Service Pack -- SP3
Any one experienced this and solved ? Any help is appreciated .
Thanks
BinuLook at this article.
There are couple of reasons why it can be:
http://support.microsoft.com/default.aspx?scid=kb;en-
us;310834&Product=sql
Regards,
Sergey.
>--Original Message--
>We are getting this error on SQL Server 2000 ( SP3)
>" a time out has occurred while waiting for buffer
latch type 4 "
>As per Microsoft this may happen when memory is >3GB and
awe enabled ,and
>this is fixed in SP2
>But in my case
>SQL Server 2000 -Standard Edition (SP3)
>AWE disabled
>OS Memory -- 2GB
>Service Pack -- SP3
>Any one experienced this and solved ? Any help is
appreciated .
>Thanks
>Binu
>
>.
>

No comments:

Post a Comment