General discussion

Locked

SQL 7.0 REPLICATION

By jonngu23 ·
I am testing performance of SQL 7.0 replication. After a 6000 "update" trans was successfully replicated to the source table (~10 minutes), performance monitor on the source server continuously show high disk and processor performance that lasts for about 15 seconds and then repeat the same 5 seconds later.

This unusual activity seem to stop only when the server is rebooted or SQL services are stop and restarted. Any ideas?

Jonathan.

This conversation is currently closed to new comments.

1 total post (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

SQL 7.0 REPLICATION

by gjconely In reply to SQL 7.0 REPLICATION

SQL likes to do things as fast as it can, and then go back thru its work and try to clean itself up. It is probabaly writing cached info to disk, doing integrity checks, and cleaning out all of the open space that it crated while creating new records. On mine, it usually will do something like that for about an hour or two, depending on the activity on the server.

Back to Networks Forum
1 total post (Page 1 of 1)  

Related Discussions

Related Forums