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 |
|
leodone
Starting Member
30 Posts |
 Posted - 2010-06-24 : 13:20:12
|
| Under windows task manager we are noticing that SQL Server 2005 splservr.exe is up to 2g of mem usages and its just caching. Is there away to release unuse mem usage without rebooting the server? We are experince preformance issues. |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-06-24 : 13:32:33
|
| SQL Server will, over time, help itself to all available memory. That is by design so it doesn't waste CPU time continuously grabbing/releasing memory . You can set the Limit that you want SQL to Grab. If you change that, now, I don't know if SQL will releases it without a restart.However, SQL is supposed to "yield" memory to other applications when O/S memory is tight (which will be the case when SQL has grabbed all available memory!)I think the recommendation is to limit SQL on the basis of allowing 1GB per CPU for the O/S (plus more for anything else running on the same server) |
 |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-06-24 : 19:31:02
|
| How much memory on the server?Performance issues in SQL or performance issues in the OS? If it's SQL, it's not likely to be due to high memory usage.--Gail ShawSQL Server MVP |
|
|
|
|
|
|
SQL Server 2005 not releasing Mem usage