SQLServr.exe Memory Usage

[Matrix316]

I have installed SQL Server 2008 and i recently downloaded update from Windows Server Update Services 3.0. After updating SQL Server 2008 i have noticed that sqlservr.exe application always run as background process. It takes too much memory.I can't find a definitive answer,Can anyone help!!!

[Calvin K]

sqlservr.exe is the main executable relating to Microsoft's SQL Server Suite. This server application provides industry standard and flexible SQL server services. By default, SQL Server can change its memory requirements dynamically based on available system resources. sqlservr.exe program is important for the stable and secure running of your computer and should not be terminated.

[Lillebror]

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 available on the computer is steadily decreasing until the available memory is between 4 to 10 MB.

[Wynn]

There is a way to limit how much memory sql server can use in a given machine. However, sqlservr.exe does not seem to relinquish memory properly. A database system will allways use the memory it needs, but with also
release it, however the OS will reclaim memory when needed.SQL will allocate as much memory as you define in the Max Memory property.