Microsoft

SQL Server Best Practices Article: Identifying and Resolving MDX Query Performance Bottlenecks in SQL Server 2005 Analysis Services

Share
Language:
English
This article provides the information about the available MDX query troubleshooting tools and demonstrates how to use the most common of these tools to identify and resolve MDX query performance bottlenecks with individual MDX queries
  • Details

    Note: There are multiple files available for this download. Once you click on the “Download” button, you will be prompted to select the files you need.
    Version:
    Date Published:

    1.0

    3/12/2012

    File name:
    File size:

    IdentifyingAndResolvingMDXBottlenecksSSAS.doc

    906 KB

    AdvWorksDW-Simple.exe

    262 KB

      There are a variety of things that you can do to improve the performance of an individual MDX query. To begin, you must identify the source(s) of the performance bottlenecks in the execution of a poorly performing MDX query. To identify the source(s) of performance bottlenecks, you need to understand how to use the available Microsoft Windows and SQL Server 2005 Analysis Services troubleshooting tools to assist you with identifying bottlenecks and learn how to interpret the information revealed by these tools. This article provides the information about the available tools and demonstrates how to use the most common of these tools to identify and resolve MDX query performance bottlenecks with individual MDX queries.
  • System Requirements

    Supported Operating System

    Windows 2000, Windows Server 2003, Windows Vista, Windows XP

      Microsoft Word
  • Install Instructions

      Click Save to save the document to your hard disk
      Click Open to open the document immediately

Popular downloads

Free PC updates

  • Security patches
  • Software updates
  • Service packs
  • Hardware drivers
Run Microsoft Update
close
moreinfo