Post reply

Replication related to performance issues

  • July 26, 2006 at 1:45 pm

    #169028

    we have recently moved our SQL database to a SAN drive because of performance issues,  I am planning out how to align the tables / indexes on this SAN drive.  I would like any advice on if i can improve the performance of replication by locating specific tables on dedicated clustered drives and if so what tables.

    I have already moved all indexes to a clusted drive of their own.

     

  • July 31, 2006 at 12:17 pm

    #652449

    It depends on your DB. If you have large tables you might want to put them in a separate file group or sep drive. Obviously log will be on a diff drive. Also you can put indexes on diff drive or diff file group. These are some general guidelines. I think there is some article on sqlserverperformance regarding this.

    ******************
    Dinakar Nethi
    Life is short. Enjoy it.
    ******************

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

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