SQL Server with Mr. Denny

Dec 2 2010   2:00PM GMT

Will separation of data file and log file of SQL sever help if all are on the SAN? From performance perspective not management.

Denny Cherry Denny Cherry Profile: Denny Cherry

Most likely yes, but it really depends on the storage array and the storage array configuration.  If the array is a shared everything array like an IBM XIV then their may not be any benefit to breaking everything onto separate disks as each LUN is spread over every spindle in the device.  However if you are using an EMC array where you manually configure which LUNs are created on which disks then it will definitely matter.

One thing to remember which I can’t stress enough if that if you are writing directly to disk in a SAN environment then there is probably something wrong, as the array has a ton of cache which would be accepting all the writes, which are then destaged to the disk later on.

Now even when using a system like an IBM XIV array having multiple LUNs can give you some benefits as Windows will now have multiple disks queues and multiple paths over which to send the data.

Basically like everything else, you’ll need to test what works best in your environment, and test the other options occasionally to ensure that what you are using is still the best configuration later on.

Denny

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.

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
  • Alzdba
    Does it make a difference if the LUN is alllocated to windows as a mounted drive ? Is there a disadvantage when trying to cut on drive letters ? ALZDBA
    0 pointsBadges:
    report
  • Denny Cherry
    Performance will be the same if you are using a drive letter or a mount point.
    66,130 pointsBadges:
    report

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: