SQL Server with Mr. Denny

Jan 17 2011   2:00PM GMT

How much cache to allocate for servers that host 500gb databases?

Denny Cherry Denny Cherry Profile: Denny Cherry


The short answer is as much as possible.

The more exact answer is you typically can’t allocate cache to a specific LUN.  You can usually carve up the total amount of cache into read and write cache.  You want as much write cache as possible so that the database writes directly to the disk as little as possible.

There is no number that I can give saying that you need X amount of write cache for a 500 Gig database, because it doesn’t depend on the database size.  It depends on the amount of data change per minute, how fast the data can be destaged from the write cache to the disks, and how much load is being placed on the disk for reading data.


 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.

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:

Share this item with your network: