Re: index on separate physical disk
From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 02/23/05
- Next message: Andrew J. Kelly: "Re: Moving Transaction Log to a different device"
- Previous message: James: "SQL Server Authentication Question (easy I think)"
- In reply to: arthur: "index on separate physical disk"
- Next in thread: arthur: "Re: index on separate physical disk"
- Reply: arthur: "Re: index on separate physical disk"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 23 Feb 2005 15:56:46 -0500
Something like that depends on a lot of factors and is hard to quantify as
such. I don't think you will find a white paper or anything official along
those lines due to the fact there are so many variables. Do you have a
specific question in mind?
-- Andrew J. Kelly SQL MVP "arthur" <alangham@gmail.com> wrote in message news:1109187034.716627.83110@g14g2000cwa.googlegroups.com... > does anyone have any data on performance increase due to separating > data and indexes - each on a different physical drive? thanks, > > arthur >
- Next message: Andrew J. Kelly: "Re: Moving Transaction Log to a different device"
- Previous message: James: "SQL Server Authentication Question (easy I think)"
- In reply to: arthur: "index on separate physical disk"
- Next in thread: arthur: "Re: index on separate physical disk"
- Reply: arthur: "Re: index on separate physical disk"
- Messages sorted by: [ date ] [ thread ]