I have a Dell Poweredge 2900 server running Windows Server 2003 Enterprise Edition for our CRM program which uses SQL 2000. I just got this set up and running and I am not having any problems with it, but I want to keep it that way. When I first was going to get this server, I posted on here and one of the specs noted by an expert was this:
"Since its going to be for a database, the RAID card should not have any cache on it. And if it does, you'll need to disable it. Nothing should be stored in cache, this is how databases get corrupt. But this would be better for the boot drive."
Now, I want to make sue I do this if it's needed...is this correct, and if so, what is the process for doing this. I looked in the Open Open Manage Server Administrator setup, but did not find an option for Caching, I think when I set it up, I left caching enabled. This is all I got out of the configuration settings in the OpenManage system:
Adapter Manufacturer Dell Inc.
Adapter Description PERC 5/i Integrated
Adapter Data Bus Width [Not Obtained, see card documentation]
Adapter Speed [Not Obtained, see card documentation]