Submitting forms on the support site are temporary unavailable for schedule maintenance. If you need immediate assistance please contact technical support. We apologize for the inconvenience.
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.