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.
| 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 |
|
|
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? |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
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. |
|
|
|
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 |
|
|
|
|
|
|
Memory issue