SQL Server Performance Forum – Threads Archive

Transaction Replication Slowdow the whole server

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.

Hi, 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 ? <img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ /> Regards Hemantgiri S. Goswami [email protected] "Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri S. Goswami

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.

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.

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.

Hi, 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 !? <img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ /> Regards Hemantgiri S. Goswami [email protected] "Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri S. Goswami

]]>