Experiencing SQL slowdowns? Is it taking forever for your data to process? It may be the memory settings on your SQL server. Read below to find out how to change your memory settings to adjust your Server Memory Options:
SQL Server is designed to request as much RAM as possible which will not be released unless this memory is explicitly required by the operating system. The best approach is to limit the amount of RAM the server can use which will allow the OS to have a set amount of resources to use no-matter-what.
Use the two server memory options, min server memory and max server memory, to reconfigure the amount of memory (in megabytes) managed by the SQL Server Memory Manager for an instance of SQL Server.
1. In Object Explorer, right-click a server and select Properties.
2. Click the Memory node.
3. Under Server Memory Options, enter the amount that you want for Minimum server memory and Maximum server memory
Note: the above is not going to limit all aspects of SQL Server to that amount of memory. This only controls the buffer pool and the execution plan cache. Things like CLR, Full Text, the actual memory used by the SQL Server .exe files, SQL Agent, extended stored procedures, etc. aren’t controlled by this setting. However these other things typically don’t need all that much memory, it’s the buffer pool and the execution plan cache which need the bulk of the memory.
If you would like to learn more about this or any Microsoft Dynamics product news, please contact Complete Software by calling 410-740-1090 or by emailing support@completesoftware.net!
Based out of Columbia, Maryland, Complete Software Solutions (CSS) is proud to be a Microsoft Partner and Value Added Reseller (VAR) for Microsoft Dynamics GP and Microsoft Dynamics SL as well as a unique software developer providing solutions for businesses and non-profit organizations throughout the country. We offer a variety of services including Microsoft Dynamics consulting, system evaluation, business process analysis, system design, customizations, Enterprise Resource Planning (ERP) implementations and system upgrades.