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!

Register Log in
  • Congratulations SkipVought 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

y3by

Programmer
Jan 15, 2002
92
0
0
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.

Similar threads

mattmontalto
  • Locked
  • Question
SQL Server 2008 RAM Usage
Replies
2
Views
44
mattmontalto
mattmontalto
griffitd
  • Locked
  • Question
SQL 2005 replication hanging
Replies
0
Views
30
griffitd
griffitd
Kliot
  • Locked
  • Question
Sql Server 2008 Replication Agent message code 20084
Replies
5
Views
105
Kliot
Kliot
wp1
  • Locked
  • Question
Database base memory usage question!
Replies
2
Views
56
wp1
wp1
TheBugSlayer
  • Locked
  • Question
Please explain the CMD - executed by a job 1
Replies
4
Views
94
SajidAttar
SajidAttar

Part and Inventory Search

Sponsor

Back
Top