How to improve SQL Server memory management

[Tylerrr]

Hi all,

Recently, my database server in order to be able to run other applications, while maintaining the operating system version of the database without changing the database server of the software and hardware upgrades. In software, the operating system from Windows 2000 to upgrade to Windows Server 2003; in hardware on the server from the original 512MB of RAM to 1GB (1024MB). I just want to know that how to improve SQL Server memory management. Thanks and reply.

[opaper]

The expected SQL Server buffer pool behavior. By default, SQL Server, after you start, SQL Server according to the report of physical memory the operating system to dynamically increase or decrease the number of cache capacity. As long as the size of physical memory available to keep 4MB to 10MB in between, SQL Server buffer pool will continue to increase memory in between 4MB to 10MB in order to avoid the operating system because of lack of memory and frequently changing pages. If the physical available memory becomes less time, then SQL Server will release some memory to the operating system. Check and reply.

[MindSpace]

In order to run the application on the server to achieve more satisfactory results, but also to give other applications in order to allocate sufficient memory, need to take measures to limit the SQL Server memory usage. We can set up SQL Server database engine used by the memory of the upper and lower limits to achieve this purpose. You should also try this and reply.

[Modifier]

The specific steps are specified for memory management in SQl server.
1. Open Enterprise Manager, expand the server group.
2. Click the server, click the right mouse button, click the Properties menu.
3. In the pop-up dialog box, click the memory tab.
Memory settings in two ways:
# To set min server memory and max server memory in a range of paragraph.
For example, we will set it into a minimum-0MB, maximum 255MB. This approach for a single server running multiple applications allocate memory very useful.
#To set min server memory and max server memory for the same value.

[Praetor]

You can be maximum and minimum values are set to 255MB. This set method and the window in the other option "Use a fixed memory size" is consistent. Although the minimum and maximum memory settings are advanced options, but the setting is completed, the best first stop SQL Server service and then re-run so that SQL Server can better memory and reasonable arrangement. check and reply.

[Katty]

When you start SQL Server, SQL Server memory usage may continue to progressively increase and not reduce, still when activity on the server is low. As well, the Task Manager and Performance Monitor may demonstrate that the physical memory available on the computer is progressively decreasing awaiting the available memory is between 4 to 10 MB. Check and reply.