SQL Server Performance

Indexes on Separate IO

Discussion in 'SQL Server 2005 Performance Tuning for Hardware' started by cranshark, Mar 8, 2007.

  1. cranshark New Member

    Hello all,

    I was wondering if anyone could provide me with links to documentation supporting whether or not moving indexes to separate IO will help to improve performance. Thanks for your help in advance.

    Mike C.
  2. joechang New Member

    this is an Oracle old wives tale
    not substanitated on any system in the last 15 or so years

    the solution is having adequate IO in the first place

    if you current having 4 disks for data and index
    adding 4 more to put the index there will help

    but it will help more to spread data and indexes across all 8
    and it is even better to have 56+ disks
  3. satya Moderator

    <blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by joechang</i><br /><br />this is an Oracle old wives tale<br />not substanitated on any system in the last 15 or so years<br /><br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"> LOL on the quote Joe, [<img src='/community/emoticons/emotion-2.gif' alt=':D' />].<br /><br />On the subject aspects see this<a target="_blank" href=http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlIObasics.mspx>http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlIObasics.mspx</a> link too.<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>

Share This Page