Improve performance by spreading data |
 |
EXPERT RESPONSE FROM: Kevin Kline
|
|
|
|
| > |
QUESTION POSED ON: 17 October 2005
If data is spread across multiple files, but the files are on the same physical drive (or redundant array of independent disks), how does this setup improve performance? Wouldn't the single drive still be a bottleneck, so multiple requests to read/write to multiple files would need to be processed sequentially?
|
|
| > |
EXPERT RESPONSE
Yes, you are correct. You only get a performance improvement when spreading data files across physically separate volumes. It doesn't help to spread data files across logically separate but physically identical drives. It never really helps to spread the transaction log files across multiple drives since, as you mention, transaction log files always write on the last data page of the last drive in the transaction log file volume.
Do you have comments on this Ask the Expert Q&A? Let us know.
|
|
|
|
|
|
|
|
Search and Browse the Expert Answer Center
Search and browse more than 25,000 question and
answer pairs from more than 250 TechTarget industry experts.
|
|
|
|
|
|
|
|
|
|
|
|
