Symptoms

Microsoft SQL Server 2012 Analysis Services (SSAS 2012) may intermittently not respond to user query or new user connection during extensive lock conflicts, and this behavior results in an extensive blocking or a deadlock. Take a blocking scenario for example. If there is a transaction session that holds a commitshared lock that prevents the commitwrite lock of another transaction session from continuously committing the processing operation on the database, any new connections to the database may not be served in a timely manner until the blocking situation is resolved. If you run SQL Server Profiler before the extensive blocking occurs, you receive the following message in the profiler trace, and you can take proper action such as aborting or canceling the blocking transaction session:

Progress Report Begin 6 - Commit
Notification 24 - Transaction abort requested         Transaction errors: Aborting transaction on session <SPID>.

The information indicates that a lock conflict occurs, and it is useful in troubleshooting both the extensive lock conflicts and post mortem analysis. However, no corresponding information is recorded in the SSAS log file msmdsrv.log.

Each new cumulative update for SQL Server contains all the hotfixes and all the security fixes that were included with the previous cumulative update. Check out the latest cumulative updates for SQL Server:


Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

What affected your experience?

Thank you for your feedback!

×