SQL Server Performance

Transaction Replication Slowdow the whole server

Discussion in 'Performance Tuning for SQL Server Replication' started by chen_wan, Dec 8, 2005.

  1. chen_wan New Member

    I have published a Transaction publication in my Sql Server 2000. In order for the replication to work, I have to start the sql server agent service and let the transaction replication run, the whole server become very slow. I noticed that the sql server agent service take up huge portion of my physical memory. I have 512 MB in the server. What is the recommended server spec to run transaction replication.
  2. ghemant Moderator

    Hi,<br />read Memory Architecture and Memory Pool from BOL ? is your application write intensive ?! is any of your existing SP / T-SQL / Reports are having complex / big query which need more resources ?<br /><br /><img src='/community/emoticons/emotion-1.gif' alt=':)' /><br />Regards<br /><br />Hemantgiri S. Goswami<br />ghemant@gmail.com<br />"Humans don't have Caliber to PASS TIME , Time it self Pass or Fail Humans" - by Hemantgiri S. Goswami<br />
  3. Luis Martin Moderator

    I've moved to relevant forum.


    Luis Martin
    Moderator
    SQL-Server-Performance.com

    One of the symptoms of an approaching nervous breakdown is the belief that one's work is terribly important
    Bertrand Russell


    All postings are provided “AS IS” with no warranties for accuracy.



  4. satya Moderator

    If the SQLAgent is taking too much of memory then you must look at the scheduled jobs during that time and make sure no other application is sharing the memory on SQL Server.

    BTW what is the memory setting on SQL server?
    I believe 512mb is too small if you are performing resource intensive queries on top of transactional replication.

    Satya SKJ
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  5. chen_wan New Member

    My apologize...

    it is the sqlserv.exe that takes up the memory. It takes up 230MB of memory while the sqlagent.exe only takes up 4MB.

    I noticed that the snapshot.exe also constantly takes up a lot of memory and CPU time. I reconfigure the scheduling for snapshot agent to run on every 4 hours instead of 1 minute previously. The server is working nornally with this new setting.

    I am new to replication. Why do we need to run snapshot agent while what I need is only the transaction replication. I used replication wizard to setup the transaction replication. Do I really need the snapshot agent while working on transaction replication. If yes, how often should I schedule the snapshot agent to run because I noticed that the snapshot agent is very slow.

  6. ghemant Moderator

    Hi,<br />please search the forum for the relaven topic as it is discussed several times . BTW is their any complex query running ! are all latest patches and hotfixes installed !?<br /><br /><br /><img src='/community/emoticons/emotion-1.gif' alt=':)' /><br />Regards<br /><br />Hemantgiri S. Goswami<br />ghemant@gmail.com<br />"Humans don't have Caliber to PASS TIME , Time it self Pass or Fail Humans" - by Hemantgiri S. Goswami<br />

Share This Page