Enterprise Vault SQL Maintenance Task Hung

Hi All,

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:

sp_who2 active

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.

 

Regards

Sukhija Vikas

 

 

 

Advertisements

One thought on “Enterprise Vault SQL Maintenance Task Hung

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s