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.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
Wednesday, March 7, 2012
New install - replication test takes 14 seconds
Labels:
clustered6,
core,
created,
database,
hyperthreading,
install,
installation,
microsoft,
mysql,
oracle,
procs,
ramdual,
replication,
seconds,
server,
simplest,
sql
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment