SQL Server Performance

Should I use replication to increase performance?

Discussion in 'Performance Tuning for SQL Server Replication' started by kel, Apr 9, 2003.

  1. kel New Member

    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?
  2. trifunk New Member

    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
  3. satya Moderator

    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
  4. bradmcgehee New Member

    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

Share This Page