SQL Server Performance Forum – Threads Archive
Indexes on Separate IOHello 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.
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
<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=’‘ />].<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>