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 |
|
jhocutt
Constraint Violating Yak Guru
385 Posts |
 Posted - 2005-03-14 : 07:59:40
|
| Can someone give me a clue as to where to start looking for this problem.I have 3 database servers (SQL 2000) set up with transactional replication on 2 of the databases from server 1 to server's 2 and 3, pull subscriptions.Replication is working fine and has been for some time now. Occasionally when records are inserted into one of the replicated tables, on server 1 it takes an extremely long time, on inserts to a different database on server 1.This table and database are not replicated, only inserts are done on the table and only using a stored procedure. Selects updates deletes and inserts to other databases and tables continues to function correctly. The machine is not under an excessive load IE < 10% CPU and < 40% Memory utilization, and the disk subsystem is not bottle necked. There seems to be no rhyme or reason for this to occur, the only similarity I can find is the replication. And as I said it only occasionally happens. Is there a SQL Server resource that might be getting locked by the replication process and if so what is it. Thanks in advance. |
|
|
kish
Starting Member
45 Posts |
Posted - 2005-03-14 : 08:15:44
|
| Try Profiling using SQL Profiler the particular table and see if there is any lock that is causing the problem. Kishore |
 |
|
|
jhocutt
Constraint Violating Yak Guru
385 Posts |
Posted - 2005-03-14 : 08:16:52
|
| I have and there is not. |
|
|
|
|
|
|
SQL Server insert issues