Service Manager Database Using High RAM

sql2016

Last updated on April 13th, 2023 at 10:34 pm

Read Time:1 Minute, 7 Second

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.

Feedback

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]

Free Subscription

If you want to be notified when we post more quality guides like this one, sign up to our free subscription service and you will receive an email when a new post is live.

Join 441 other subscribers.

No need to worry, we will not be filling your inbox with spam and you can unsubscribe anytime you like.


Leave us a message...

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