turn write-to-cache off 
Author Message
 turn write-to-cache off
A while ago I took a SQL class and the instructor insisted that we deselect
the write-to-cache option for data integrity in case of a crash.  Where can
I find this option and then deselect it (I believe that it is a NT option)?


Sat, 24 Aug 2002 03:00:00 GMT
 turn write-to-cache off

Actually, that option will be based on the RAID card that you are using.

Erich Huemoeller


Quote:
> A while ago I took a SQL class and the instructor insisted that we
deselect
> the write-to-cache option for data integrity in case of a crash.  Where
can
> I find this option and then deselect it (I believe that it is a NT
option)?



Sat, 24 Aug 2002 03:00:00 GMT
 turn write-to-cache off
Nacho - it is set on the raid controller.  As long as the raid controller's
memory is battery backed then you can leave write-caching on.

Quote:
> A while ago I took a SQL class and the instructor insisted that we deselect
> the write-to-cache option for data integrity in case of a crash.  Where can
> I find this option and then deselect it (I believe that it is a NT option)?

 Neil Pike MVP/MCSE.  Protech Computing Ltd
 (Please reply only to newsgroups)
 SQL FAQ (420 entries) see

http://forumsb.compuserve.com/vlforums/UK/default.asp?SRV=MSDevApps
 or www.ntfaq.com/sql.html (+ ntfaq download)
 or http://www.sql-server.co.uk


Sat, 24 Aug 2002 03:00:00 GMT
 turn write-to-cache off
I've received a couple of emails stating that turning off the write-to-cache
option isn't a good idea.  What are your thoughts?


Sat, 24 Aug 2002 03:00:00 GMT
 turn write-to-cache off
 That's what I said - don't turn it off as performance will suffer. Write-back
caching improves update i/o performance a great deal.  (Make sure it is battery
backed though and TEST it)

 > I've received a couple of emails stating that turning off the write-to-cache

Quote:
> option isn't a good idea.  What are your thoughts?

 Neil Pike MVP/MCSE.  Protech Computing Ltd
 (Please reply only to newsgroups)
 SQL FAQ (420 entries) see

http://forumsb.compuserve.com/vlforums/UK/default.asp?SRV=MSDevApps
 or www.ntfaq.com/sql.html (+ ntfaq download)
 or http://www.sql-server.co.uk


Sat, 24 Aug 2002 03:00:00 GMT
 turn write-to-cache off
There are 2 types of cache that is affecting what your instructor mentioned;
1.) cache on the scsi hard drive, most come with this turned off, but
utilities like adaptecs let you check that, this is most important in a SQL
system to turn off, write performance does get hurt, but you never loss
data.

2.) Raid array controllers some have batteries and some don't. if you have a
battery backed up controller the the cache write can be turned on on the
controller but not on the scsi hard drive, as the controller assumes that
when it writes to the drive it has commited the data, and if the drive has
it's cache turned on it could get lost in power failure situation.


Quote:
> A while ago I took a SQL class and the instructor insisted that we
deselect
> the write-to-cache option for data integrity in case of a crash.  Where
can
> I find this option and then deselect it (I believe that it is a NT
option)?



Sat, 12 Oct 2002 03:00:00 GMT
 
 [ 6 post ] 

 Relevant Pages 

1. SQL Server & turning RAID Cache Off

2. Turning Off the PTS Cache

3. Performance Testing ( Turn compile cache off ? )

4. Can I turn OFF read cache?

5. Possible to turn off file system cache?

6. Turning off cache for a single sql-query

7. Possible to turn off file system cache?

8. Possible to turn off file system cache?

9. Turning cache off on a Seagate drive under AIX - Progress/AIX/Seagate don't mix

10. Turn it off, turn it on

11. Turn off system warning

12. Can Transaction log be turned off?


 
Powered by phpBB® Forum Software