Browse by Tags

SQL Server 2005 memory configuration gotchas

Published 28 December 7 4:44 AM | SSQA.net

This may be last post in Performance Tuning & Security blog section here for this year!! Most of this year in the forums & newsgroups I have seen a common question asking about memory configuration within SQL Server 2005. As you may be aware that...

Filed under: sql server, performance, memory, security, applications, best practice, awe, pae, dynamic, 3gb, benchmarking, performance monitoring, settings

More than 3GB memory is not used even though boot.ini has these switches on /3GB /PAE /AWE.

Published 23 August 7 4:33 AM | SSQA.net

Yet another AWE memory settings blog post here that I'm posting for the issues we have had recently. Before going into details review about 3GBPAE blurb here and also refer to this KBA274750 to enable more than 2GB memory within your SQL Server Enterprise...

Filed under: sql server, performance, memory, security, windows, edition, enterprise, instances, awe, pae, 3gb