2

This question is a follow up from the SSAS - what could be a good starting point for memory settings?

What and how can I monitor the server resources in order to best identify the settings that I should apply to my SSAS instance?

In this case we're talking about sql server 2014, and the server is a windows server 2012, with the spect below

enter image description here

  • 1
    Check out the SSAS specific DMVs which can help you isolate a user, measure etc. issue. Also, avoid storing string data in a cube... it will consume memory at a fantastic rate and doesn't benefit from the aggregation centric design of SSAS. msdn.microsoft.com/en-us/library/hh230820.aspx – Dave Sep 17 '15 at 20:41
  • 1
    Are you still wanting help? Are you wanting perfmon counters to monitor overall memory usage by SSAS? Something else? This blog post talks about SSAS memory use and it's use of the file system cache: artisconsulting.com/blogs/greggalloway/2010/12/29/… – GregGalloway Nov 2 '15 at 6:29
1

When trying to fine-tune your memory settings there are two things you'd want to watch:

  1. MSOLAP Memory counters for your server in Performance monitor

enter image description here

  1. Specific DMV queries over discover_object_memory_usage rowset and discover_object_activity rowset.

You can always use a third-party tool to monitor your resources. Also, you might want to check out this article – it gives a detailed description on how to achieve exactly what you are looking for.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.