I have sql server 2008 R2 running on windows 2008 R2. In task manager memory is constantly showing very high (almost 99%) since morning. How I can check what is causing this high memory usage? I want to figure out the root cause and then resolve it. Any help.
Sort task manager by memory. But it's likely due to SQL Server, which is expected. Have you set the max memory setting for the instance? How much memory do you have? How many instances of SQL Server are there on this server? And is it dedicated to SQL?
It shows sql server process is consuming max memory in sort list in task manager. Total server memory is 16GB. Max server memory set to 14GB. Only one SQL Server instance is there. This server is dedicated to SQL Server only.
Is it expected behaiour of sql server that it will not relase memory unless requested by OS even if nothing is using so high memory in sql server?
Even though it's a dedicated server SQL Server - have you analysed the memeory requirments for other utility software you may have installed on the server. Are you seeing any memory pressure? Are you monitoring queries which are very memory intensive - such as sorts and hashing?