How to monitor locks and deadlocks within SQL Analysis Services connections?
説明
User has Analysis Services instance where randomly cube builds will fail with the error "Server: The operation was cancelled because of locking conflicts." Is there any way to get the deadlock graphs (or details) from within SSAS connection like we do with a normal SQL instance connections?
対策
WORKAROUND:
None
STATUS:
Enhancement request SOSSE-5999 has been submitted to Development for consideration in a future release of Spotlight on SQL Server Enterprise.