We recently had a problem with our Service Manager database server using massively high RAM usage. It was using up all the RAM we gave it no matter how much extra we allocated to it.

So we needed to try and figure out why it was doing this, like all good IT people, we started Googling!

All the usual tricks were found and a lot of blog posts about setting the top limit of the RAM but all this had already been carried out. But then we stumbled upon a blog post about setting the memory limits within the Analysis Server settings:

Microsoft System Center Service Manager 2012 and SQL Analysis Services

So we tried this out and there it was – no more hitting the top limit of the RAM. We even managed to lower the RAM usage on the virtual machine and everything start to work correctly again.

Update – Does it really work?

We have now had this fix in place for about five weeks and everything is still working fine and we still do not have any high RAM usage, so this seems to have worked perfectly.


If you have any questions or feedback if you have tried this method, we would love to hear from you. So please feel free to leave us a message below in the comments section.

Click to rate this post!
[Total: 0 Average: 0]

Discover more from TechyGeeksHome

Subscribe to get the latest posts to your email.

Avatar for Andrew Armstrong

Andrew Armstrong

Founder of TechyGeeksHome and Head Editor for over 15 years! IT expert in multiple areas for over 26 years. Sharing experience and knowledge whenever possible! Making IT Happen.

Leave us a message...

This site uses Akismet to reduce spam. Learn how your comment data is processed.