TTCLIVE
asked on
Disable Caching on my Server 2003
Hey all,
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]
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]
I think you will find that the cache is battery backed, therefore disabling write cache on the controller is not necessary.
ASKER
"andyalder: I think you will find that the cache is battery backed, therefore disabling write cache on the controller is not necessary."
What do you mean?
What do you mean?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
from start menu >> run >> gpedit.msc >> computer configuration >> windows settings >> security settings >> local security >> security options .
ASKER
You are absolutely right andyalder, thank you for the help.
Right click on the disk, select properties, select the hardware tab
Select the disk and then click properties
Go to the policies tab and you will find the option there.