SQL Server Performance Forum – Threads Archive

Calculate Replication Overload on Publisher

[?]Hi all :
I have a server with 7 user databases(total data 80GB) Daily growth in all 7 databases is around 500MB and transactions per sec on server is
225 during peak hours (10 to 12 am and 03 to 05 pm)
135 during normal working hours
Appx 75 during late night and weekend
–all in all daliy avg is almost 150 trans per sec. I need to know if i have to configure 3 databases for snapshot and rest 4 for transactional replication. then how much additional overhead it will be putting on server on an average. Publisher and distributor
—————————-
Operating system: Windows 2003 Ent Edition
SQL: 2000 Ent Ed. with SP3a
RAM: 6GB
CPU: 4* ~2.49GHz
Storage: RAID 10 & 1 for data and log files. Subscriber
—————————-
Operating system: Windows 2003 Ent Edition
SQL: 2000 Ent Ed. with SP3a
RAM: 6GB
CPU: 4* ~2.49GHz
Storage: RAID 10 & 1 for data and log files.
There is 1GB/s connectivity between servers, and subscriber will be pulling changes from distributor database. Actually (would be*)publisher server is already running on 80 to 90% CPU utilization during peak working hours.. Over it i need to setup replicaiton now.. do we have any way to find out how much additional overhead it will put putting on CPU’s and Memory after establishing replication. ANY way to find out CPU & MEMORY cost….. Thanks, Deepak Kumar

Microsoft says : As indicated in "Cost of Transactional Replication," there is a cost in adding replication to an OLTP server; however, the cost under stress conditions can be as low as 8-10 percent when using a remote Distributor, and somewhat higher when using a local Distributor. Furthermore, if the publishing server has enough CPU capacity, the cost can be insignificant: When using a four-processor or eight-processor server, the cost of replication is often less than 3 percent.
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/tranrepl.mspx Deepak Kumar

And also capturing the PERFMON stats for the required counters will help to assess the situation. 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.

]]>