2 processors/2.67 Ghz
I have a windows 2008 and sql server 2008 on it.
Currently sqlserver.exe is using up all the memory.It fluctuates between 90 to 95% of the memory present.(Physical box not virtual.)
I would like to set the min and max memory utilised by sql server .How to calculate the min and max values.Can I get any t-sql to calculate these min /max values
Task manager shows:CPU used:1% to 5%
Physical memory :5.77 GB.Once I restart the sqlserver.exe service,it comes down to 2.0Gb physical memory used.Obviously sql server is not releasing the memory back to the OS once it grabs the memory.How do I prevent this from happenning.Are there any repurcussions if I leave it the way it is presently.