Post reply

How to Monitor Memory on an SSAS Instance

  • December 6, 2016 at 8:08 am

    #146323

    Hello,

    I had a SSAS memory crash today while a cube was loading data from SQL Server 2014 into the Tabular data cube.

    I have googled around to find how I can use PerfMon or Profiler to monitor the SSAS memory so I can see if it's close to rebooting itself or something else not good on the brink.

    Thanks,

    JPQ

  • December 6, 2016 at 8:40 am

    #1916256

    I understand it's going to be primarily MDX type queries, what would be most helpful are the commonly exec tured queries to check Memory, CPU usage, Storage on a certain cube, that goes after key columns. I'm also thinking that the result set gets put into a pivot table and the data analyzed to hunt the problem a cube may have, or is about to crash?

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply