SQL Server with Mr. Denny

Feb 16 2009   8:58AM GMT

Optimal Database Setup Hardware Guide

Denny Cherry Denny Cherry Profile: Denny Cherry


A little while back I published an article on Enterprise IT Planet called “Optimal Database Setup Hardware Guide“.  In this article I talk about some key points that should be looked at when building a new SQL Server.


2  Comments 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.
  • SuperCoolMoss
    Hello, Is splitting out the indexes onto on a separate lun/drive preferable to just spreading the database proportionally over two luns/drives? Regards, SCM
    140 pointsBadges:
  • Denny Cherry
    SCM, Yes it is. Access to the indexes will often happen at different times than access to the row data, and if your queries are setup correctly you'll be mostly writing to the database, while reading from the indexes so you'll want to have this data broken up onto two different database files each on there own separate LUN. Denny
    68,390 pointsBadges:

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: