|
Team, What are your thoughts on having the additional space added on a separate drive? Can we string and grow the database across different drives? Is so, will there be a performance issues.
(comments are locked)
|
|
DBA's across the globe use file groups to spread data around. I personally use file groups to split data out by year in a financial database I support. I don't have the file groups on different disk because that is not a current issue for me but absolutely I could move the file groups to cheaper disk or another disk due to space constraints. As for performance issue, most likely you would see a performance gain by spreading the load across more spindles (disks). As long as you are moving the data to the same speed disk then you should be just fine. What I have seen from some shops is that a dba would move data to a backup lun which is much slower disk just because there was free space and then when they do a heavy load of processing data they would see a performance hit. You can also split data up by your static tables and tables/indexes that are written to and updated most often. I see that mentioned in books a good bit.
Sep 29 '11 at 09:49 AM
Shawn_Melton
Thanks, Im planning to add a new disk and i want to spread the data across two disks. what is the work around to get this done ? my current disk is almost full.
Sep 29 '11 at 01:45 PM
ETHMAN5
(comments are locked)
|

