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
Last activity: May 29, 2025, 01:02 PM