SQL Server Performance

SAN Configuration - Data on SAN but Logs on SCSI?

Discussion in 'Performance Tuning for Hardware Configurations' started by DBADave, Mar 7, 2007.

  1. DBADave New Member

    Do you see any issues with the data (500GB) being on a RAID 10 SAN partition and log files being stored on SCSI drives?

    Thanks, Dave
  2. satya Moderator

    Im bit surprised how come Joe Chang missed this post [<img src='/community/emoticons/emotion-1.gif' alt=':)' />], anyway refer to this<a target="_blank" href=http://groups.google.com/group/comp.arch.storage/browse_thread/thread/5db8d267ab4560f3/1b49daafa5c9bcbb?lnk=st&q=sql+server+transaction+log+on+scsi+device&rnum=2&hl=en#1b49daafa5c9bcbb>http://groups.google.com/group/comp.arch.storage/browse_thread/thread/5db8d267ab4560f3/1b49daafa5c9bcbb?lnk=st&q=sql+server+transaction+log+on+scsi+device&rnum=2&hl=en#1b49daafa5c9bcbb</a> post for reference, for the sake of theory I don't see any issues.<br /><br /><b>Satya SKJ</b><br />Microsoft SQL Server MVP<br />Writer, Contributing Editor & Moderator<br /<a target="_blank" href=http://www.SQL-Server-Performance.Com>http://www.SQL-Server-Performance.Com</a><br /><center><font color="teal"><font size="1">This posting is provided AS IS with no rights for the sake of <i>knowledge sharing. <hr noshade size="1">The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.</i></font id="size1"></font id="teal"></center>
  3. DBADave New Member

    Thanks Satya. I elected to place the data and log files on the SAN, rather then splitting them with data files on the SAN and the log files on SCSI. The thought being from a disaster perspective it simplifies the failover process. It also didn't make much sense to keep the logs on SCSI and risk having data writes being delayed as the server waits for SQL Server to complete the log write activity before writing data to the faster SAN drives.

    The link you sent is very informative. I need to read more about calculating I/O per second. That's not one of my strongest areas.

    Dave
  4. satya Moderator

    True on the aspects of the data & disaster recovery, if the disk is fast enough to accomodate the read and writes I don't see any issue or stress of seperating the data and log files.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.

Share This Page