Hi Friends Good Morning, This is subba reddy , i am working Sql server data base developer in small
organization.in production the sql server consuming more memory why? Configuration: Sql server -2012. Server Ram- 7 Gb Current data bse size(.Mdf)= 20 gb Consuming memory: With out front-application:intialy 3 gb graduallyincress to 4 gb With application running with along 30 users: 6.5 gb nearly. if there is no any sql are not in wait status. but why its consuming more memory>
what is the MIN and MAX memory setting of the SQL Server? You can check this by executing the below command: EXEC sp_Configure look for the below two option: min memory per query (KB) min server memory (MB) In case they are not visible then execute the sp_configure command once again with below parameters: EXEC sp_configure 'show advanced options',1 GO RECONFIGURE
I will expand on vishalhsingh answer. It is important to set the MAX RAM to LESS than total server RAM. If you do not set the Max memory BELOW the Server's max RAM then SQL Server will consume as much RAM as it can and leave almost nothing for the Operating System. So in your case with 7GB of RAM I suggest 5120 as the MAX. This leaves approximately 2GB for OS functionality. This assumes you have only one instance installed.