SQL Server with Mr. Denny

May 23 2011   2:00PM GMT

On an EMC array is it possible to assign WRITE cache to wherever your transaction log files are?



Posted by: Denny Cherry
Tags:
EMC
SQL Server
Storage

Yes, provided that your transaction logs have their own LUN from the other files as the write cache is enabled and disabled at the LUN level.  By default read and write cache will be enabled for every LUN which is created on the array.

There aren’t to many cases where you would want to disable the write cache on a LUN except for maybe a data warehouse LUN where no data is updated, only new rows are written.  The reason for this is that these will be sequential writes, and the array will bypass the write cache when it detects that sequential writes are being done as these sequential writes can be done directly to disk about as quickly as they can be done to cache as once head gets into the correct place the writes are put done very quickly as the head and the spindle don’t need to move very far between each write operation.

Denny

 Comment on this Post

 
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 other members comment.

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: