2005年以来，有几个设施可帮助调整分析服务的调谐。

• You can get query plans for MDX in much the same way as SQL Server supports them, although the actual primitives in the engine are of a somewhat different nature.

• Running usage based aggregation will pick up what slices actually get looked at in practice.

• SSAS also supports the profiler, so you can get trace files to see what the server is actually getting up to.

• The debugger in BIDS lets you trace the cube scripts.

然而，这种东西要比在 SQL Server 上文档化得少得多，因此您可能需要涉及 MS 技术支持、第三方顾问或 Stackoverflow；-}

尝试运行MDX Studio。它分析MDX查询并针对常见问题给出一般性的性能建议。

我发现它非常有用，通过遵循这些提示，我已将一些查询的性能提高了8倍。

它也是免费的！