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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Memory asigned for SQL Server

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 Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/
Go to Top of Page
   

- Advertisement -