x

Thoughts on adding additional space.

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.
more ▼

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

ETHMAN5 gravatar image

ETHMAN5
482 44 46 48

(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

Tim gravatar image

Tim
36.4k 38 41 139

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.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x22

asked: Sep 29, 2011 at 08:27 AM

Seen: 577 times

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