Merge Replication Problems Follow
I am working in a Merge replication environment where I have SQL Server 2005 at asphostportal.com server, 11 publications and 2 subscribers.
I used to get lot of incidents from the Application owner for blockings, recently I faced a situation where the lead blocker is in sleeping state and the session was used by the merge agent.
Checked the query that the session was running, it was sys.sp_MSenumgenerations90;1.
Could anyone please suggest me what is the above stored procedure and how to avoid this blocking other sessions?
Please sign in to leave a comment.