Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Max meomory setting vs task manager Expand / Collapse
Posted Wednesday, February 20, 2013 9:51 AM


Group: General Forum Members
Last Login: Wednesday, January 20, 2016 2:25 PM
Points: 13, Visits: 470
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

Post #1422164
Posted Wednesday, February 20, 2013 10:16 AM



Group: General Forum Members
Last Login: Yesterday @ 6:52 PM
Points: 45,436, Visits: 43,789
Don't use Task Manager to check SQL Server's memory, it can display completely incorrect (far too low) values.

Perfmon counter - Total Server Memory.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1422188
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse