Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2005
    Posts
    319

    Unanswered: New install - replication test takes 14 seconds

    SQL 2000 Installation - Clustered
    6 GB of RAM
    Dual Core with hyperthreading (shows 4 procs)

    Created the simplest of tests, created 2 DB's (1 for publication, 1 for subscription), 1 table with 2 columns, a PK int and a varchar(50).

    Setup distribution
    Setup the publication on that 1 table
    Setup a pull subscription on that publication

    inserted a record, takes on average 12 seconds to replicate to the subscription DB, tested it 7 times, and every time it takes 12 seconds, tried updating a column, still takes 12 seconds.

    It must be something very simple - anyone have an idea what could be going on here that would make it take so long? Any type of trace I can do to see what the bottleneck is? Going to start a SQL Profiler trace and see what I see, brb.
    Last edited by Gagnon; 07-21-06 at 16:30.

  2. #2
    Join Date
    Jun 2005
    Posts
    319
    Here are the trace results...

    --14:58:53
    UPDATE MY_TEST
    SET MY_DATA = '__NEW__2'
    WHERE MY_ID = 7


    --14:58:54
    exec sp_MSadd_logreader_history 1, 3, N'1 transaction(s) with 1 command(s) were delivered.', 0x000000050000025E0004, 0, 8, 8, 0, 0x00, 1, 0x01


    --14:58:54
    SELECT GETDATE(),* FROM DELETE_ME..MY_TEST
    --14:58:55
    SELECT GETDATE(),* FROM DELETE_ME..MY_TEST
    --14:58:56
    SELECT GETDATE(),* FROM DELETE_ME..MY_TEST
    --14:58:57
    SELECT GETDATE(),* FROM DELETE_ME..MY_TEST
    --14:58:58
    SELECT GETDATE(),* FROM DELETE_ME..MY_TEST
    --14:58:59
    SELECT GETDATE(),* FROM DELETE_ME..MY_TEST
    --14:59:00
    SELECT GETDATE(),* FROM DELETE_ME..MY_TEST

    --14:59:00
    exec sp_MSget_subscription_guid 1

    --14:59:00
    exec sp_MSget_repl_commands 1, 0x000000050000025C000400000000, 0, 7500000

    --14:59:00
    exec sp_MSupd_MY_TEST NULL, '__NEW__2', 7, 0x02

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •