Post reply

is performance can increase if existing database table moves into different file group

  • September 9, 2010 at 5:50 am

    #1218529

    pankaj.kuchaliya (9/9/2010)

    then it will increase the performance.

    Maybe. Providing that the bottleneck is IO. It's not guaranteed to improve performance. If the cause of the poor performance is something other than IO (like poorly written queries or missing indexes) it may not help at all.

    Even if it does help, don't expect orders of magnitude of performance improvement. Not unless you've done a lot of analysis and design on this.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • September 10, 2010 at 11:41 am

    #1219392

    With only 2 drives it is likely more important to be concerned about your tempdb and transaction log placements as opposed to your database file placement.

    Surprised no one has mentioned this (that I saw) but have you read Books Online on how to create files and file groups and move tables onto them? It is a WONDERFUL resource.

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

Viewing 2 posts - 16 through 16 (of 16 total)

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