April 20, 2009 at 12:38 pm
We are running a ~500 GB database. Currently 400 GB of it is images in one table. What I would like to do is move this to another disk or raid channel with a larger capacity. I really think the size of the database is really dragging down the performance of main tables. There doesn't seem to be anyway to get Enterprise as management isn't going to spring 100k for it.
April 20, 2009 at 12:52 pm
You don't need EE for what you want to accomplish.
What you need to do is create a new filegroup on your database and put that filegroup and file on the new disk. Then you need to "move" the table with the images to that new filegroup. Now I have done this myself, but there are two ways to accomplish this. The first is to create a new table in the new filegroup and then copy the data from one table to the other, drop the original table, and then rename the new table to the old table name. The second is to recreate the tables clustered index on the new filegroup.
Personally, I'd probably go for the first method.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply