SQL Split datafile

samelterrance

Hi All,

I have a 60GB disk where a database resides.
The database is now 58GB.
I have another drive which has 60GB free.
Is it possible to split the datafile over two disks or do I just have to purchase a bigger drive ?

Thanks

Tom Dunne

What database/operating system?

samelterrance

Hi Tom,

Windows 2003 Server, SQL Server 2005 Enterprise Edition

Tom Dunne

And this is where I bow out. More of an Oracle man, myself.

It's been a while since I looked at SQL server, but I would be very surprised if you can't do it.

amen

yes you can.

you could split the physical file device over multiple drives
or even better create new physical devices on the same/multiple drives
and then assign different tables to those devices.

Of course doing this can have performance issues as you may have tables involved in the same query on different drives/devices which could cause issues.

you need to be careful with this.

With only 2Gbs free how is performance?

is there any old data that can be removed/archived?

what size is your transaction log and how often do you back it up?

Do you run statistics, reindex and defrag jobs on a regular basis?

samelterrance

Hi there,
Thanks for the reply.


With only 2Gbs free how is performance?
It's adequate

is there any old data that can be removed/archived?
unfortunately not.

what size is your transaction log and how often do you back it up?
transaction log is 400MB, back it up every night

Do you run statistics, reindex and defrag jobs on a regular basis?[/QUOTE]
Statistics and reindex is done on a weekly basis.

I think I'll have a go at creating new filegroup then and adding various tables to that. ?

Cheers

amen

go for it!