SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Memory issue
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Peter99
Constraint Violating Yak Guru

494 Posts

Posted - 01/28/2013 :  17:20:43  Show Profile  Reply with Quote
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

USA
37287 Posts

Posted - 01/28/2013 :  18:40:33  Show Profile  Visit tkizer's Homepage  Reply with Quote
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

494 Posts

Posted - 01/28/2013 :  19:14:19  Show Profile  Reply with Quote
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

USA
37287 Posts

Posted - 01/28/2013 :  19:56:19  Show Profile  Visit tkizer's Homepage  Reply with Quote
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 - 01/29/2013 :  04:28:20  Show Profile  Reply with Quote
There must be some processes running behind, please check for it and close if you do not wish.
Go to Top of Page

jackv
Flowing Fount of Yak Knowledge

United Kingdom
2075 Posts

Posted - 01/29/2013 :  10:31:54  Show Profile  Visit jackv's Homepage  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000