September 6, 2018 at 8:48 am
Hi
I happen to be on the server in the middle of the night checking something out, and I wanted to see the memory usage as one of the things that I was looking at.
I was not sure if this was the best way to do this which is part of my question here, but I ran task manager on the server. Now something I should mention that when they installed SQL Server they installed it on a Win10 operating system, Not a server one.
Anyway, I saw that the memory consumption was up to 93%, it then dropped to about 85% and stayed there for a good hour or so.
Questions:
Now, to me this seems really bad, and normally it seems to be about 50% Is it bad?
Is there something else I should be doing instead of using task manager. like some kind of DMV or scripts?
And lastly, how can I use the data to find what is causing it and what to do about it?
Thank you
September 6, 2018 at 8:50 am
SQL Server can be very memory-hungry. This is the normal state of affairs. Check that you have configured your Max Server Memory setting away from the default.
September 7, 2018 at 2:51 am
Generally SQL Server will consume every bit of memory it can and hold on to it. That your'e seeing it go up and down is more concerning than that it was up. I think Beatrix has it nailed. Make sure you set a max memory on it. You don't want the OS and SQL Server competing for memory. That will cause performance problems.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply