InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 10:21:42 GMT20http://www.sqlservercentral.com/Forums/Topic1422164-391-1.aspxDon't use Task Manager to check SQL Server's memory, it can display completely incorrect (far too low) values.Perfmon counter - Total Server Memory.Wed, 20 Feb 2013 10:16:42 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1422164-391-1.aspxSql 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 knowemail: sql.lanka@gmail.comWed, 20 Feb 2013 09:51:08 GMTsql.lanka