Viewing 4 posts - 1 through 4 (of 4 total)
Was able to fix the issue but it required a failover, restore with recovery of the impacted db's on the previous principal and then failover back to the original node....
July 7, 2022 at 6:42 am
I'm facing exactly the same issue on two production databases since a VM failure.
Can you share how/if you found a solution ? So far the tlog is growing on...
July 5, 2022 at 11:37 am
The solution is here : http://sqlmag.com/reporting/managing-analysis-services-activity-14-feb-2010
To show running queries, execute this MDX query :
SELECT * FROM $SYSTEM.DISCOVER_COMMANDS
order by command_start_time
SELECT * FROM $SYSTEM.DISCOVER_SESSIONS
SELECT * FROM $SYSTEM.DISCOVER_CONNECTIONS
May 30, 2013 at 2:50 am
It looks scarier than it really was. I didn't have to do most of it. For me,...
May 22, 2012 at 2:20 am