SQL Server Memory Management
SQL FineBuild can configure SQL Server memory management properties to optimise the performance of SQL Server.
In general, the more memory that SQL Server uses the faster it can perform. There are two key items to consider when tuning SQL Server memory properties:
- Avoid trying to use more memory than is available
- Make sure the memory that is available is used
The standard Microsoft default values for memory management properties do not meet these objectives. If you rely on the Microsoft standard values, then 64-bit editions of SQL Server will often try to use more memory than is available, and 32-bit editions of SQL Server will not use all the memory that is available. Both of these situations can be fixed by SQL FineBuild.
The processes used by SQL FineBuild to optimise SQL Server memory use are described below:
Copyright © 2013 Edward Vassie. License and Acknowledgements