Sample Header Ad - 728x90

Publication Properties window in SSMS hung when attempting to update

1 vote
1 answer
280 views
We have a SQL 2012 Database that is mirrored. It also has one publication with 3 subscribers. After a problem occurred (a view that couldn't replicate) during a snapshot push to one of the subscribers, I attempted to change the properties so that view was not in the list of articles to push. I clicked OK and the window hung. Upon inspection in the Activity Monitor, I have 9 different SIDs with a Wait time in excess of an hour. Most of them are "SELECTS" in the SSMS Application. I presume I can kill these with no issues. 2 are in SSMS but are "UPDATE" commands. I also have 3 SQLAgent SIDs that are hung: one is an "OPEN CURSOR" one is a "DELETE" and one is a "SELECT". There is also a "Distribution History" application SID SELECT that is hung. These SIDs are all in a "SUSPENDED" state. They all are waiting on a resource LOCK (mostly shared) This is a critical production database and I am nervous about just killing SSMS while it's in the midst of trying to do something. Can someone recommend one of: A - kill the SSMS interface B - kill various SIDs. If so, should I only kill certain types? Which ones? C - something else.
Asked by SMWilliams (11 rep)
Nov 1, 2021, 05:12 AM
Last activity: May 29, 2025, 01:02 PM