Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

limit cpu usage by replication process

Status
Not open for further replies.

y3by

Programmer
Jan 15, 2002
92
PT
hi ppl,

I've created a db and defined replication with more than 30 MSDE on a VPN.
the db is in a double PIII XEON with 1.5 gb memory
every thing works fine but when ever i update more than 30000 records... then machine starts replication and the processor goes up to 100%...

until replication finishes the machine is very slow..
querys take to much time...

can i limite the process of replication to 50% of the processor machine?!
can i define that only one processor deals with replication letting the other to other querys ?!

any help would be apreciated!! :)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top