Optimal Database Setup Hardware Guide

Published On: 2009-02-16By:

2 responses to “Optimal Database Setup Hardware Guide”

  1. SuperCoolMoss says:

    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

  2. mrdenny says:

    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

Video

Globally Recognized Expertise

As Microsoft MVP’s and Partners as well as VMware experts, we are summoned by companies all over the world to fine-tune and problem-solve the most difficult architecture, infrastructure and network challenges.

And sometimes we’re asked to share what we did, at events like Microsoft’s PASS Summit 2015.

Awards & Certifications

Microsoft Partner       Insights Sccess Award    Technology Headlines Award    Golden Bridge Gold Award    CIO Review Top 20 Azure Solutions Providers    VMWare Partner
Microsoft Certified Master    Microsoft MVP
Share via