Browse by Tags

• applications
• benchmarking
• best practice
• dynamic
• edition
• enterprise
• instances
• memory
• pae
• performance
• performance monitoring
• security
• settings
• sql server
• windows

SQL Server 2005 memory configuration gotchas
28 December 07 03:44 AM | SQL Master | 5 Comments   

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 Read More...

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

More than 3GB memory is not used even though boot.ini has these switches on /3GB /PAE /AWE.
23 August 07 02:33 AM | SQL Master | 3 Comments   

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 Read More...

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