Tuesday, October 16, 2012

SQL Server Memory Settings



SQL Server Memory Settings

 
The fix was to limit the amount of memory that can be used by SQL Server.  The Lenel installation guide for SQL Server standard edition tells you to limit the memory and how to do it.  Microsoft explains this behavior and says it is “normal.”


“When you start SQL Server, SQL Server memory usage may continue to steadily increase and not decrease, even when activity on the server is low. Additionally, the Task Manager and Performance Monitor may show that the physical memory

No comments:

Post a Comment