High Memory utilization
-
Hi Everyone,
One of our server in the production environment is hitting 93% of memory utilization and sqlserver is the only one installed in the server and takes almost 7gb out of total 8gb memory.
we haven't configured any min and max settings as sqlserver is the only one installed.
Does any one have faced these kind of issues,Please provide the steps for troubleshooting.
-
Normal, expected, documented behaviour. Nothing wrong at all.
If you want SQL to use less memory, set max server memory so that it knows that it's not allowed to use 100% of the available memory on the server.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
since sqlserver is the only one running in the machine why do we need to set Max memory setting
as it can allocate memory dynamically when ever required
-
DBA_007 (6/10/2013)
since sqlserver is the only one running in the machine why do we need to set Max memory settingYou don't absolutely have to set it, but if you don't, you'll get exactly the behaviour you're seeing here, SQL using all the memory on the server. Hence if you don't want SQL to use all the memory on the server, set max server memory and tell SQL how much it's allowed to use and how much you want to reserve for the OS.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
thank you,
can you tell me how much max and min memory we need to set and are there any standard settings based on the RAM configuration.
can you provide detail steps for troubleshooting memory issues(approaching the issue and trouble shooting it)
-
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
DBA_007 (6/10/2013)
since sqlserver is the only one running in the machine why do we need to set Max memory settingas it can allocate memory dynamically when ever required
since sqlserver is the only one running in the machine why do you concern yourself that it is using 93% memory?
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply