Today I am sharing a situation which we have faced issue in which maintenance tasks on Vault SQL server kind of hung.
We had waited for hours but it was still running, We generally run these tasks by setting the application to read-only mode.
I had contacted my SQL friend to assist me in this then it was resolved quickly.
We ran the following SQL Query:
Then we had found the process that was locking the rebuild indexes processes & from which host it was coming.
This was enterprise-vault server so We had changed the strategy of maintenance & now we stop the enterprise vault services as well during maintenance.
This solved our issue, so if you face same situation then this solution will help.