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 |
Elidas
Starting Member
33 Posts |
Posted - 2008-04-25 : 07:41:26
|
My server has 2Gb memory, and right now sqlservr.exe is using 1.6Gb. I think it is consuming too much memory and that will probably cause a lot of pagination of virtual memory in the hard drive.Should I place a cap to the maximun amount of memory asigned to the sql server? or do I leave it with no limit?Also, what happens if in the options I cap the memory asigned to 1Gb and it is using in that moment 1.6Gb? will server crash or something because the maximun is inferior to the actual asigned memory? |
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-04-25 : 13:18:37
|
This is completely normal. Do not change it. And the reason why it's using so much memory is because it needs it. If you think pagination is a problem on your box, then add more physical memory.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|