0

RAM usage is increasing in database server with time. When we restart the SQL services it take around 4 GB but after day or two it increases to 11-12 GB and even further. Application is hosted on separate server. Please suggest what could be the reason.

Mark Storey-Smith
  • 31,860
  • 9
  • 90
  • 125
nakul bhardwaj
  • 1
  • 1

2 Answers2

0

SQL Server will try and use all the RAM it can get hold of to reduce execution times on queries.

As you have had it running for a day or two, with the increased amount of queries ran it will be using as much RAM that it has available to it.

Daniel Hutmacher
  • 9,173
  • 1
  • 27
  • 52
0

Instead of trying to find a way to release your RAM, you might be better served trying to determine how much of your RAM your SQL server is allowed to use.

Seeing as how you're using a 16GB server, try leaving 2-3GB for the OS (or more depending on what else is installed on there)

The following commands would set your max server memory (the amount of memory SQL server will keep a hold of) to 12GB:

sp_configure 'max server memory', 12288;
GO
RECONFIGURE;
GO

http://msdn.microsoft.com/en-us/library/ms178067.aspx

Reaces
  • 2,681
  • 4
  • 27
  • 38