MSDE/SQL Error Help

Question

MSDE/SQL Error Help

Karn Snyder-Bishop

SSC Enthusiast

Points: 134
More actions
August 29, 2004 at 2:14 pm

#86507

I have two computers one running MSDE (cut down SQL) on NT4 SP6 (Pentium III, 1GB Mem) and one running MSDE on WIN2K SP4 (Pentium 4, 1GB Mem) and both are showing this problem, however the newer WIN2K computer is causing the error more regularly, probably due to it's speed? Every now and again the SQL server loses the plot and brings up the following error and does not crash but also does not allow any access to the database until the service is restarted. The error is Error 823 Severity 24 State 10. From what I can gather this is some sort of disk read or write I/O error. I first saw the problem on the new computer so I tried running it on the old (previously ok) computer and the same error occured, which rules out a hardware fault. In addition to this I have run a scan disk and there were no faults either drives. It seems to error some what randomly and I have not been able to trace the cause. I read some where that it could be due to read cache, however I have been unable to find out how to disable this, I have however found how to disable the write cache and have done so. Any help would be appreciated. Thanks Karn(UserID=174745)

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

MG-148046 SSCrazy Eights Points: 9946 More actions · Answer 1

This very much like the 605 error. Microsoft advised us to turn off read caching completely. Generally, you will need to turn the write cache up to 100% in order to turn the read cache.

MG

"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare

"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.

Bruce McCarthy SSC-Addicted Points: 477 More actions · Answer 2

I suggest you look here:

http://support.microsoft.com/default.aspx?scid=kb;en-us;826433

(this article lumps errors 605 & 823 - and others - together, as Grasshopper alluded)

http://support.microsoft.com/?id=231619

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/trblsql/tr_reslsyserr_1_23lh.asp

Good luck!

BMc

Karn Snyder-Bishop SSC Enthusiast Points: 134 More actions · Answer 3

With regards to turning read cache off (setting write cache to 100%). How would I do this? At present I have not yet been able locate where I might do this. In addition to this MSDE does not come with the enterprise manager facilities so if the setting is in SQL I will need to use the command line

MG-148046 SSCrazy Eights Points: 9946 More actions · Answer 4

Unfortunately, I don't know. You would have to contact support for your disk controller manufacturer and find out from them. It's done at the controller level.

MG

"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare

"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.