SQL Server Performance Forum – Threads Archive

S2K Trans Rep

does anyone have this hooked into a heavy traffic web site?
we have 300 hit/sec. looking to chat with a person of similar experience. we are in testing now.

We have similar setup but I have never measured the hits/sec during thsi replication, but never had issues. We followed the steps for performance tuning: -Running agents continuously instead of on frequent schedules.
-Configuring the Distributor on a dedicated server.
-Minimizing the log history and retention period.
-Using custom stored procedures for inserts, updates, and deletes at Subscribers
-Using stored procedure replication when a large number of rows are affected.
Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

would u be able to elaborate on these? -Minimizing the log history and retention period.
-Using custom stored procedures for inserts, updates, and deletes at Subscribers
-Using stored procedure replication when a large number of rows are affected.

]]>