Posted by Query Builder on 12/18/06 16:45

I have one of our production Accounting Databases starting from 2 GB
now grown into a 20 GB Database over the period of a few years...

I have been getting timeouts when transactions are trying to update
different tables in the database.. Most of the error I get are I/O
requests to the data file (Data file of the production db
Accounting_Data.MDF).

I would like to implement the following to this Accounting database.

I need to split the Data file into multiple files by placing some of
the tables in different file groups. I have the server upgraded to be
able to have different drives in different channels. I can place these
data and log files in different drives so it will be less I/O
conflicts..

I would like to have the following file groups..

FileGroup 1 - which will have all database definitions (DDL).
FileGroup 2 - I will have the AR Module tables under here..
FileGroup 3 - I will have the GL module tables under here..
FileGroup 4 - I will have the rest of the tables under here
FileGroup 5 - I will like to place the indexes under here....

Also where will the associated transaction files go?

I would like to get some help doing this. Is there any articles / help
available that I can refer to. Any suggestions / corrections/
criticisms to what I have mentioned above is much appreciated...!

Thanks in advance....

• Next in forum: Re: Help!? Combining SQL Queries? Can it be done??
• Prev in forum: Re: Help!? Combining SQL Queries? Can it be done??
• Thread view: Split Data file into multiple file groups..!

[Reply to this message]