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 |
|
shekardba
Starting Member
4 Posts |
 Posted - 2011-04-06 : 00:19:47
|
| Hi,I have sql server 2008 databases running on windows server 2003 R2.When i check in task manager mem usage is high for sqlservr.exe (around 13GB).Total RAM 16GB.Pls suggest me how can i decrease mem usage?RegardsShekar |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
shekardba
Starting Member
4 Posts |
Posted - 2011-04-06 : 00:34:35
|
| Hi Tara,Thank you for the reply.Yes this is dedicated db server.my management felt that any impact on server because of high utilization.RegardsShekar |
 |
|
|
Sachin.Nand
2937 Posts |
Posted - 2011-04-06 : 05:27:04
|
| What is your MAX memory setting ?PBUH |
|
|
|
shekardba
Starting Member
4 Posts |
Posted - 2011-04-06 : 05:59:02
|
| default setting --- 2147483647 MB |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-04-06 : 08:39:08
|
| I'll set the max memory to about 14336 (leaves 2 GB for the OS).You don't want to decrease memory usage in your case. Doing so will decrease performance. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
memory utilization