November 10, 2016 at 11:34 am
Hi
I have the same behavior in 2 SQL Servers where Stolen Server Memory and Database Cache Memory counters are decreasing (Db Cache) and increasing (Stolen Memory) in a linear way. The amount of memory decreased from Db Cache Memory is almost the same amount of memory increased in Stolen Memory.
Has anyone seeing this behavior before? Is it an expected behavior?
Both Servers Configuration:
SQL 2012 ENTERPRISE with SP3
32GB memory
Thanks for the attetion
November 12, 2016 at 2:10 am
Jose Marcelo Dias de Oliveira (11/10/2016)
HiI have the same behavior in 2 SQL Servers where Stolen Server Memory and Database Cache Memory counters are decreasing (Db Cache) and increasing (Stolen Memory) in a linear way. The amount of memory decreased from Db Cache Memory is almost the same amount of memory increased in Stolen Memory.
Has anyone seeing this behavior before? Is it an expected behavior?
Both Servers Configuration:
SQL 2012 ENTERPRISE with SP3
32GB memory
Thanks for the attetion
As the counter is the memory that the server is using for non database pages, the question is what it is being used for. Is this happening at specific times? Any maintenance operations running at the same time? Is the memory returned to the cache?
😎
November 14, 2016 at 4:59 am
Eirikur Eiriksson (11/12/2016)
Jose Marcelo Dias de Oliveira (11/10/2016)
HiI have the same behavior in 2 SQL Servers where Stolen Server Memory and Database Cache Memory counters are decreasing (Db Cache) and increasing (Stolen Memory) in a linear way. The amount of memory decreased from Db Cache Memory is almost the same amount of memory increased in Stolen Memory.
Has anyone seeing this behavior before? Is it an expected behavior?
Both Servers Configuration:
SQL 2012 ENTERPRISE with SP3
32GB memory
Thanks for the attetion
As the counter is the memory that the server is using for non database pages, the question is what it is being used for. Is this happening at specific times? Any maintenance operations running at the same time? Is the memory returned to the cache?
😎
Hi Eirikur
The increase is continuous and it does not happens at a specific time or when a maintenance operation runs.
Tks
November 14, 2016 at 5:31 am
Jose Marcelo Dias de Oliveira (11/14/2016)
Eirikur Eiriksson (11/12/2016)
Jose Marcelo Dias de Oliveira (11/10/2016)
HiI have the same behavior in 2 SQL Servers where Stolen Server Memory and Database Cache Memory counters are decreasing (Db Cache) and increasing (Stolen Memory) in a linear way. The amount of memory decreased from Db Cache Memory is almost the same amount of memory increased in Stolen Memory.
Has anyone seeing this behavior before? Is it an expected behavior?
Both Servers Configuration:
SQL 2012 ENTERPRISE with SP3
32GB memory
Thanks for the attetion
As the counter is the memory that the server is using for non database pages, the question is what it is being used for. Is this happening at specific times? Any maintenance operations running at the same time? Is the memory returned to the cache?
😎
Hi Eirikur
The increase is continuous and it does not happens at a specific time or when a maintenance operation runs.
Tks
This could possibly be the likes of OLE objects left hanging, that is not destroyed or de-allocated at the end of the batch, suggest you set up an Extended Event Session to identify what is causing this.
😎
There are few known issues which may cause memory leaks or thread exhaustion if run frequently, i.e. fn_dump_dblog but somehow I don't think that is your issue.
November 18, 2016 at 10:56 am
Thanks
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply