SQL Server Performance Forum – Threads Archive

Should I use replication to increase performance?

I have a system that performs a lot of heavy background calculations and as the same time sevring web users. How do I increase performance and reduce blocking? Is Merge Replication a good idea in this case?

Merge replication is usually used in environments where you need to merge the data between publishers and subscribers, I’m not sure how this would increase performance in your system if at all, could you elaborate on the problem you’re having.
Do you only have a single database?
Are the calculations being done in the database or an application?
When you say blocking do you mean you’re getting alot of locking and timeouts?
How many users are you serving on average? Cheers
Shaun World Domination Through Superior Software

Replication is no way connected to increase the performance or blocking. You should consider using better indexes and search conditions to avoid blocking and to gain performance best bet is to run PROFILER and PERFMON to capture the events. Refer to the homepage of this site about PERFORMANCE counters and PROFILER tips to get more acquaintance. To increase the performance after all these tests better to addup more memory to the box. HTH _________
Satya SKJ

I was wondering if the reason you are considering replication is in order to divide the load between more than one server? Is this what you were thinking? Also, are the heavy backround calculations being performed in the same database that is being accessed by web users? Once I know these, then I may be able to offer some suggestions. ——————
Brad M. McGehee
Webmaster
SQL-Server-Performance.Com

]]>