Post reply

Filegroups

  • March 8, 2007 at 8:49 pm

    #369796

    My Dear Experts

    Can you please explain me what happens if we create a number of  filegrooups?. How it is related to DB performance?.. How many filegroups we can create for a DB?..  

     

     

    Thanks ,

    Shekhar

  • March 9, 2007 at 5:48 am

    #694053

    Using filegroups is an architecture issue and depends upon your circumstances so there is no simple answer that fits all.

    Filegroups add an extra level of complexity and can cause performance problems, on the other hand filegroups can aid in partitioning, performance and recovery. I'd have a read up on filegroups in BOL or get one of the many good SQL Books, Inside SQL Server 2000 speings to mind.

    I'm sure most posters will have their own advice, but at the end of the day it's an architecture issue which suits your circumstances best. In SQL2005 there are additional reasons to use filegroups with Enterprise SQL Server which relate to the on-line recovery and always on strategies.

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

  • March 12, 2007 at 9:59 pm

    #694570

    Colin,

     Thank you for your response..

    I have read some where that Avg Disk Queue Length should be less than 3 always.. and which is some way related to the number of Filegroups.

    Can anybody please explain how the filegroups are realted to this performance counter.

     

    Thanks ,

    Shekhar

  • March 13, 2007 at 3:46 am

    #694617

    filegroups and av disk queue are not related. I personally never use disk queue , mainly because the values become meaningless on a san.

    The best counter to use for disk performance is io completion time. You may be thinking of  ::fn_virtualfilestats which displays information at sql file level.

     

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

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

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