Post reply

NDF''s and MDF''s growing in parralell?

  • June 22, 2006 at 2:19 pm

    #190971

    we have a server that  we were playing around with and we wanted to see if a second data base file in the same filegroup would help us at all or not.  we have 2 cpus so we thougth we migth get a bit more throughput from doing this.

    here is the odd thing.... we assumed ( probably wrongly) that both files would grow at the same rate.  one file was larger when we started (2Gb) and the second file we created was only 500MB so we thougth the 500MB file would eventually catch up to the other datafile and they would eventually be pretty close in size.

    nope. nuthin... in fact the 500MB file has not even been used. free space is 499MB .

    anyone help me out here on understanding this?

     

     

  • June 23, 2006 at 1:52 pm

    #645666

    If the files are on different filegroups, only objects specifically created on the new filegroup will reside there.

    If the files are on the same filegroup, only new objects will be created 'split' between the original and new file (i.e. existing objects will not take advantage of the new file space).

    In Books Online see:

         filegroups, described and filegroups, table placement

        

  • June 24, 2006 at 3:36 pm

    #645735

    You have to restrict growth on the first file (mdf). When it fills up to the size you set, sql will start using your ndf.

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

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