Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
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: Friday, December 19, 2014 1:42 PM
Points: 13, Visits: 467
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 @ 9:26 AM
Points: 41,287, Visits: 37,879
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 2008, MVP
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