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.

All Forums  SQL Server 2008 Forums  SQL Server Administration (2008)  32-bit Server with 50GB memory

Author  Topic  TJTodd Starting Member 10 Posts Posted - 2012-03-13 : 18:44:40 In one of our environments we are running on a 32-bit server with SQL Server running 50GB of memory (using /PAE). There's a total of 64GB of memory on the server. I remember reading somewhere that on 32-bit servers when you run with large amoundts of memory that SQL Server has to maintain some virtual lookup table to utilize this memory and that this "lookup table" resides in the 2GB area of memory that is used by MTL and the BPool. We are seeing the "Maximum Workspace Memory (KB)" perfmon counter vary from only 80000 to 170000. This is resulting in us getting a lot of Resource Semaphore waits because of large memory grant requests. Is there any way to determine if this excess memory is actually chewing away at the "Maximum Workspace Memory (KB)"? Just wondering if we were to reduce the SQL Server memory from 50GB to 30GB if that would have a significant impact on "Maximum Workspace Memory (KB)". Any help would be appreciated Thanks, Tom