SQL Server Performance Forum – Threads Archive
Indexes on Separate IO
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.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=’
![Big Grin :D :D](styles/default/xenforo/smilies/biggrin.png)
]]>