SQL Server Performance

Blocking in Analysis Services

Discussion in 'SQL Server 2005 Analysis Services' started by icltd, Feb 9, 2007.

  1. icltd New Member

    We 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?
  2. ranjitjain New Member

    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.
  3. satya Moderator

    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
    http://www.SQL-Server-Performance.Com
    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.

Share This Page