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 |
|
bala012
Starting Member
4 Posts |
 Posted - 2013-02-20 : 11:54:39
|
| Sql production box has 108 GB RAM i allocated Max memory 100 GB for sql server ,in task manager i see 106 GB Used i.e 98% of memory ,My question is when we allocate max memory to sql server it will allocate or sql server request memory when it required and leave the memory to OS.But i see sql server is not taking memory when it required it is locking the memory what it was allocated. please let me know |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
SQl max memory vs task manager