lower memory specifications | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

lower memory specifications

Does anyone know of a good resource for how memory is allocated in the non-AWE space for SQL 32-bit? I’m looking for limits on how much memory can be allocated to the procedure cache. Also how much can be allocated for user connection memory, buffer cache (hashing, sorting…). What happens to these limits when /3GB is turned on?

Try spotlight (freeware) from QUEST. Luis Martin
SQL-Server-Performance.com All postings are provided “AS IS” with no warranties for accuracy.