-1

I have a windows server and this server has 4 GB of memory. But the msmdsrv.exe is taking 1.5 GB of memory. What is that, and why is it doing this? How can I make it stop?

This is a production server.

MDMarra
  • 100,734
  • 32
  • 197
  • 329
seema
  • 7
  • 1
  • 2

1 Answers1

1

A very quick google shows that msmdsrv is SQL Server Analytics Server. So, the short answer is: You don't. I assume you are doing something with SSAS, which means that you want it to have memory allocated.

4GB isn't really very much though - especially for anything running SQL Server or its related services.

Mark Henderson
  • 68,823
  • 31
  • 180
  • 259
  • 1
    Yeah, this is another case of "I want my server to waste memory rather than using it efficiently". We see a lot of those. – David Schwartz Jan 29 '14 at 06:41
  • 1
    Or it's another case of "My server is using resources and I have no idea whether or not that's normal but I'm pretty sure I don't want it to because I have no idea of what I'm looking at". – joeqwerty Jan 29 '14 at 19:42