Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
henrikop
Constraint Violating Yak Guru
280 Posts |
 Posted - 2007-01-23 : 04:56:43
|
| I was asked to solve a problem regarding replication on SQL 2000.The production DB publishes (push, continueus) to 2 SQL DB's. The hardware on all three servers are more than adequate. All was fine till one week ago. Replication processes generated a *lot* I/O on the disk and query database was slow until I/O dropped. Then website and query's where lightning fast once again.Updates are only on the production server. All disk have enough free space, CPU's doing nothing much and ther're still heaps of free RAM on all servers.Replication processes are the processes that generate this disk I/O.How do I find directions to solve this problem?Henri~~~~There's no place like 127.0.0.1 |
|
|
|
|
|
Replication SQL 2000