SQL Server Performance

SAN Performance Question - Utilizing LUNs

Discussion in 'SQL Server 2005 Performance Tuning for Hardware' started by DBADave, Feb 27, 2008.

  1. DBADave New Member

    I'm still trying to understand the differences in performance between fiber channel (FC) SAN drives and SCSI. I've been told that SAN performance is much better then SCSI and SAS and that we should consider dividing drives into LUNs to better utilize disk space. We have an EMC SAN and our smallest drives are 73GB. In allocating disk space for tempdb a RAID 10 made up of (4) 73GB drives is too much space for our needs. One of our SAN people (note the Star Wars reference) suggests dividing the (4) 73GB RAID 10 into multiple LUNs, allocating 36GB to tempdb and the remaining 110GB to SQL Server logs. Should I be concerned with this approach or is SAN performance with LUNs much better then SCSI and SAS?
    Thanks, Dave
  2. satya Moderator

Share This Page