Post reply

tables and datafiles

  • April 5, 2007 at 12:30 pm

    #153510

    i understand you can create tables within certain filegroups,

    but when looking over the data files...

    how can you tell on which data file your tables are located?

    suppose i have 4 data files...

    data1.mdf 3000 mb

    data2.ndf 2000 mb

    data3.ndf 1000 mb

    data4.ndf 6000 mb

    i've got hundreds of tables. so where/how are the spread

    across these data files? are they located in 1, or 2 or

    both, all whatever.

    is there a query i can run to find out?

    thanks in advance.

    _________________________

  • April 5, 2007 at 1:23 pm

    #698910

    Hi, BOL Article Using Files and Filegroups says:

    "Filegroups use a proportional fill strategy across all the files within each filegroup. As data is written to the filegroup, the database engine writes an amount proportional to the free space in the file to each file within the filegroup, instead of writing all the data to the first file until full. It then writes to the next file. "

    It is not like different tables are in different files, all files are filled up proportionally.

    Regards,Yelena Varsha

  • April 5, 2007 at 2:40 pm

    #698927

    i'm checking the bol now, and seems what

    i need to do is force population of other filegroups.

    thanks yelena.

    _________________________

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply