On this SQL Server 2000 SP4 Machine (ServerPrincipal), the job pulls in data from Table1 and pushes the data to another SQL Server 2000 SP4 Machine (ServerTarget). The ServerTarget has Datanase Isolation Level as Serializable. There are constant updates on the ServerTarget.
I can see that the both the databases have proper indexes and are properly utilizaed. The statistics are updated two days back. I can see that ServerTarget accquires Page locks while updates are in process.
Since the last say 20 days the ServerPricipal exhibits nearly 100% CPU Utilization during morning when there is a huge data to be sent from ServerPrincipal to ServerTarget.
Need guidance to troubleshoot.