SQL Server Performance Forum – Threads Archive
Blocking in Analysis ServicesWe have a report in Reporting Services that connects to a Cube. The report has 4 input parameters that are also derived from the same cube. If the report is running and another user tries to select the drop downs for the report or runs just the query portion in report designer, the query will not return until the report has finished. It looks like the report is creating some type of wait. Has anyone ran across something like this?
In 2005, You can even run SQL profiler to trace all MDX queries analysis server is running.
Same the time, keep eye on perfmon and cpu usage.
Also record the total bytes read, which can help you in investigating further.
In simple terms, if AS is using lots of resources, it has to queue other queries.
http://download.microsoft.com/download/8/5/e/85eea4fa-b3bb-4426-97d0-7f7151b2011c/SSAS2005PerfGuide.doc fyi. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.