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 |
|
nitin1353
Constraint Violating Yak Guru
381 Posts |
 Posted - 2008-05-20 : 04:58:12
|
| Hello Gurusi have my production server where sqlserver exe seems to be consuming all the RAMWhat can be the possible reasons for thisI have checked for the pending jobs and everythingPlease adviceRegardsNitin |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2008-05-20 : 05:25:00
|
| That is SQL Server, it will only release it if some other application requests it. This is by design so that it can respond as quickly as possible to any reequest.This is the reason that Microsoft recommends you have SQL on its own server. You can set limits (Max Server Memory) if you need to. |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-05-20 : 21:40:08
|
| Have to set max memory if it's 32-bit sql and awe is enabled. |
|
|
|
|
|
|
Sql server consuming 7gb ram