Configuring HP SIM for Optimal Performance in Large Environments

24
Using AWE memory
After both Microsoft Windows 2008 and SQL Server 2008 are properly configured, you can take
advantage
of the benefits of your added RAM. If you have just added RAM to a new Microsoft SQL
Server,
you must watch the buffer cache hit ratio to see the effect of the addition of more RAM. If you
still
do not get a 90% or more buffer cache hit ratio after adding the extra RAM, you might need to
consider
adding even more RAM, or redesigning your database so that it is more efficient.
Carefully monitor the paging on the server after first configuring AWE memory. Microsoft SQL Server
does
not dynamically manage AWE memory. If you see that paging starts to become a problem, you
might
want to reduce the amount of RAM Microsoft SQL Server can access by reducing the Microsoft
SQL
Server max server memory setting. It might take some experimentation before you find the ideal
setting
for the maximum memory Microsoft SQL Server should have. Ideally, paging should be virtually
nonexistent on a well-tuned Microsoft SQL Server.