SQL Server Performance

Replication

Discussion in 'Performance Tuning for SQL Server Replication' started by lara99, Oct 19, 2007.

  1. lara99 New Member

    Hi champs, I really need some good suggestion from gurus so please help me out.
    On our production server we have replication setupt which is replicating to the client now the problem is, in a publishation we got something like 300 articles which is giving the problem. We are running SQL 2k. Now we are planning to breakup the articles into smaller articles, and that should happen transperent to the user. So can you guys come with some suggestion about this situation. I will be highly thakful..
    lara99, Oct 19, 2007
    #2

  2. satya Moderator

    What kind of issues you are having with current replication setup?
    satya, Oct 22, 2007
    #3

  3. lara99 New Member

    Our clients are facing performance problems. Thxs.
    lara99, Oct 22, 2007
    #4

  4. ghemant Moderator

    ghemant, Oct 23, 2007
    #5

  5. satya Moderator

    During the replicaiton or after the replication process is completed?
    In order to get correct solution you have to specific where and when they are having issues with performance on SQL SErver, this may not be due to replication. So be clear to get more solution.
    satya, Oct 23, 2007
    #6

Share This Page