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 |
|
Sharon911
Starting Member
46 Posts |
 Posted - 2010-06-07 : 16:08:40
|
| Noticed sqlserver.exe is using almost 3GB RAM, we are running sharepoint system. Is this normal? Any suggestion to reduce the RAM being used by sql server?Thanks,Sharon |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2010-06-07 : 16:24:32
|
| It is normal for SQL Server to use all available memory. Due to this, you should cap the amount of memory that SQL Server can allocate using sp_configure or the SSMS GUI (right click on the server, properties). You should reserve memory for the OS and other processes. Please note that since SQL Srver is a memory hog, it is typically recommended that nothing else run on that server. Microsoft recommends reserving 1GB per CPU for the OS. For instance, I have 48GB of memory and 8 CPUs (2 quad-core sockets) on one of my systems. We set the max memory to 40GB for SQL Server.If you cap SQL Server memory lower than what it needs, you will see performance degradation.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
 |
|
|
Sharon911
Starting Member
46 Posts |
Posted - 2010-06-08 : 14:38:33
|
| Thanks Tara, if I update the maximum memory value using SSMS GUI, do I need to restart the service for the update to take effective? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Sharon911
Starting Member
46 Posts |
Posted - 2010-06-08 : 15:31:04
|
| Thats great, Would the sqlserver return the memory to OS after use? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
sqlserver memory usage