Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Memory issue

Author  Topic 

Peter99
Constraint Violating Yak Guru

498 Posts

Posted - 2013-01-28 : 17:20:43
Hi,

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.

Thanks

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2013-01-28 : 18:40:33
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?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

Peter99
Constraint Violating Yak Guru

498 Posts

Posted - 2013-01-28 : 19:14:19
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?
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2013-01-28 : 19:56:19
Yes this is expected behavior. SQL Server is a memory hog. It's designed that way.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

srimami
Posting Yak Master

160 Posts

Posted - 2013-01-29 : 04:28:20
There must be some processes running behind, please check for it and close if you do not wish.
Go to Top of Page

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2013-01-29 : 10:31:54
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?


Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page
   

- Advertisement -