April 10, 2006 at 10:38 am
I have Replication set up from 1 publisher to 2 subscribers. My dist agent failed with errors as
i) The SQL Server cannot obtain a LOCK resource at this time. Rerun your statement when there are fewer active users or
ask the system administrator to check the SQL Server lock and memory configuration.
ii) IDistPut Interface has been shut down.
iii) Transaction (Process ID 72) was deadlocked on lock resources with another process
and has been chosen as the deadlock victim. Rerun the transaction.
iv) Transaction (Process ID 84) was deadlocked on lock resources
with another process and has been chosen as the deadlock victim. Rerun the transaction.
After restarting these agent its shows IDLE status for few of them and no data is coming thru on subscriber. Has anyone seen this before. any help will be greatly appreciated as this is on prodn env and greatly affecting us.TIA
April 10, 2006 at 1:12 pm
It simply looks like you have contention issues. Transactional or Merge?
April 11, 2006 at 8:56 am
What is the value of the CommitBatchSize parameter of your distribution agents? Try making it a bit smaller to reduce contention for resources in the distribution database.
John
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply