SQL Server 2000 error in log: WARNING: EC 5c3320c0, 9 waited 300 sec. on latch 44173b2c. Not a BUF latch.

40 pts.
Tags:
SQL Server 2000
SQL Server errors
SQL Server logs
SQL Server performance
I am seeing this error weekly in the sql server log with associated performance hit: WARNING: EC 5c3320c0, 9 waited 300 sec. on latch 44173b2c. Not a BUF latch. Has anyone resolved this error?
ASKED: July 18, 2008  9:02 PM
UPDATED: November 4, 2008  9:25 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

This error usually means that your disk isn’t responding fast enough. You may have a disk failure comming, or a SCSI cable going bad.

If you are on a SAN you could have a bad fibre cable, or a heat problem within the array.

Or you may simple need more spindles in your array that is having the problem.

If it’s a disk failure problem you will want to run a DBCC CHECKDB on the database to ensure that the database didn’t get corrupted.

Check perfmon and look for high queueing or high latency to the disk.

UPDATE: I contacted the vendor of our CRM tool to find out if they had any experience with this issue. they set me up with one of their senior DBAs. After some poking around in Enterprise manager and my describing what we do weekly with our maintenance plans we saw that as a result of shrinking the database every week we were creating the problem. We noticed that the timestamp of the database file was exactly the time of the buf latch error starting. We surmised it was useless to shrink the database since it was going to expand almost immediately after the shrink anyway and it was impacting performance. We have gone an entire day without the error resurfacing.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following