May 13, 2019 at 2:34 pm
Can someone please explain me
I have SQL server 2012 with 24 GB of total ram in server
Out of which we have set 12 GB set for Minimum Memory and 22 GB to Max memory set. So what does that mean SQL server is using only 10 GB or 22 GB??
What if I set SQL memory Min to 0(Zero) GB and Max to 22 GB what is the difference when SQL memory Minimum set to 0 or 12 GB?
May 13, 2019 at 2:38 pm
Check SQL counters "Server Target Memory" & "Server Total Memory"
Below everything is explained :
https://blobeater.blog/2017/03/01/sql-server-target-vs-total-memory/
Query to get current values :
select
object_name
,counter_name
,cntr_value
from sys.dm_os_performance_counters
where counter_name like 'T%Se%Memory%'
May 13, 2019 at 3:10 pm
Thanks it got clear
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply