Report Portal

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

 

2007-2015 VidasSoft Systems Inc.