Merge Replication Problems 关注

0
Avatar
Legacy Poster

Hi, 
 
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?
 
Thanks.

请先登录再写评论。