Thoughts on adding additional space.


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.

more ▼

asked Sep 29, 2011 at 08:27 AM in Default

avatar image

482 44 46 51

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

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.

more ▼

answered Sep 29, 2011 at 08:33 AM

avatar image

40.4k 39 84 166

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, 2011 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, 2011 at 01:45 PM ETHMAN5
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Sep 29, 2011 at 08:27 AM

Seen: 681 times

Last Updated: Sep 29, 2011 at 08:27 AM

Copyright 2016 Redgate Software. Privacy Policy