SQL Server Performance Forum – Threads Archive
lower memory specificationsDoes 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.