Analysis Services Stops Accepting New Connections -Processing commit locks hurt
This common blocking symptom really can cause trouble if you get caught off guard.
When you process an Analysis Services object, like FullProcess on a database or cube, near the end of processing is the phase where it needs to swap the old files out and replace it with the new files a lock is needed a the highest level in the database. The users running queries have got the priority until they finish.
Some times, the users and the server administrator cannot even log in with management studio to run a new query.
Read more...Tags: management, connectivity, dmv