SQL Server Performance

help please 2 questions

Discussion in 'Performance Tuning for SQL Server Replication' started by bashka_abdyli, Aug 4, 2003.

  1. bashka_abdyli New Member

    First I am using merge replication and sometimes it is nessesary to make a big delete or update for example 500 000 rows and it takes whole night to complete is it possible to send this to subscribers just like stored procedure if not which is the best way to do so,


    Second I have a table "transactions" with 20,000,000 rows is it better to seperate into this tables"deposits", "withdrawals", "transfers", "loans", "payments" or to keep just in one table

    thanks in advance
  2. gaurav_bindlish New Member

    What are the typical operations that you carry out on this table? And what is their frequency?

    Gaurav
    Moderator
    Man thrives, oddly enough, only in the presence of a challenging environment- L. Ron Hubbard
  3. Twan New Member

    Also:

    - do you use row or column level tracking
    - what is your retention period


    I can't think of a way to get around the 500,000 row delete problem other than
    - stop all activitity on the databases
    - delete subscribers
    - delete the rows on the publisher and subscribers
    - create the subscribers specifying the the schema and data is already on the subscribers (i.e. don't apply the snapshot)

    I don't like the sound of this though...

    Cheers
    Twan
  4. jbloyd New Member

    Are the deletes going through RI constraints? Do you implement RI on the subscriber also? These can seriously affect replication speed.

Share This Page