1

Can anyone help me what does this indicate:

From the MSDN forums thread Total Server Memory VS Target Server Memory made me crazy answer by Jonathan Kehayias:

If Total Server Memory is less than Target Server Memory it can be a sign of memory pressure

But in my case the values are same:

enter image description here

Paul White
95.4k30 gold badges440 silver badges689 bronze badges
asked Nov 30, 2016 at 10:04

1 Answer 1

1

But in my case the values are same :

You cannot and should not come to conclusion that SQL Server is facing memory pressure by just looking at one perfmon counter, this is just not correct. You have to rely on other perfmon counters which I am sure you are aware.

Now for your question, since both are same this means the SQL Server memory requirement is balanced as of now and its quite likely that SQL Server is not facing memory pressure. In most cases I have seen that on steady system target and total server memory are equal and I have always found out that when they are same it means currently there is no memory pressure.

answered Nov 30, 2016 at 10:15
4
  • Thanks Shanky ,thanks for the responses each time. I am trying to understand SQL Server Memory correct and sometime I am going crazy to understand things properly. Your responses help me so much. Thanks a lot. Commented Nov 30, 2016 at 10:19
  • Shanky,sorry for extra question,Follow up on your response : As for heading question NO, memory for SSIS does not comes from buffer pool in any instance of SQL Server – Shanky Jul 28 '15 at 4:15 same is the case with SSRS,SSAS too...are they out of SQL Server Maximum Memory ? Can you please tell me what else are out of SQL Server Max Memory ? Thanks Commented Nov 30, 2016 at 10:28
  • 1
    Can you tell me what version of SQL Server we are taking. Yes for SSIS, SSAS and SSRS the memory comes outside from buffer pool. Buffer pool is mainly for satisfying database engine requests Commented Nov 30, 2016 at 10:39
  • Shanky mine is SQL Server 2008 R2,Thanks again lot. Commented Nov 30, 2016 at 10:41

Your Answer

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Email and Password

Post as a guest

Required, but never shown

Post as a guest

Required, but never shown

By clicking "Post Your Answer", you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.