Tip

Which SAN cache do you need?

The write cache on the disk controller is a two-edged sword in a SAN environment, especially one handling transactions. Although a cache improves throughput, it is also

    Requires Free Membership to View

a potential point of failure, which can corrupt the entire database when writes are being cached. The cache on a SAN isn't any more likely to have problems than one on a conventional storage system, but because SANs are more often used in business-critical environments, a problem with data cached on write in a SAN is likely to have more serious consequences.

The general rule is that if the cache isn't adequately protected, don't use write caching. Controllers vary in the safety features they provide, but some of the ones to look for include features to prevent uncontrolled resets, on-board battery backup of the cache memory and error-correcting or mirrored memory. Further, if you are using failover clustering, you should consider using mirrored cache. Various vendors have different feature sets and you should consider which one best matches your requirements.

A faulty read cache can cause problems too, of course, but usually the data will be preserved.

Microsoft discusses write caching and potential pitfalls in Chapter 6 of its SQL Server Operations Guide available over the Web from Microsoft's Technet site.


Rick Cook has been writing about mass storage since the days when the term meant an 80K floppy disk. The computers he learned on used ferrite cores and magnetic drums. For the last twenty years he has been a freelance writer specializing in storage and other computer issues.


 

This was first published in November 2003

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

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
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

Disclaimer: Our Tips Exchange is a forum for you to share technical advice and expertise with your peers and to learn from other enterprise IT professionals. TechTarget provides the infrastructure to facilitate this sharing of information. However, we cannot guarantee the accuracy or validity of the material submitted. You agree that your use of the Ask The Expert services and your reliance on any questions, answers, information or other materials received through this Web site is at your own risk.