I have one of our production Accounting Databases starting from 2 GB
now grown into a 20 GB SQL Server 2000 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....

On Dec 18, 11:48 am, "Query Builder" <querybuil... (AT) gmail (DOT) com> wrote:
I guess they don't cover this in the DBA documentation for SQL Server?
(Oracle, for example, covers this topic quite nicely.) But since yours
is a SQL Server question, I suggest you go downstairs to the
comp.databases.ms-sqlserver group. They would give a more specific
answer.

HTH,
ed