Question about TARGET SERVER Memory and TOTAL SERVER Memory

Posted on 2011-03-13
Medium Priority
Last Modified: 2012-05-11

I noticed that the counter TARGET SERVER Memory was upper (12go ) to the counter TOTAL SERVER MEMORY (8go)
While the min and the max to server memory are fixed in 12go.
There is 16go of RAM on the server
How to explain it?
How can I estimate the mempry needed by SQL Server?


Question by:bibi92
LVL 15

Accepted Solution

Daniel_PL earned 2000 total points
ID: 35122625
I think you're completly fine.
If, over time, the SQLServer:Memory Manager: Total Server Memory (KB) counter is less than the SQLServer:Memory Manager: Target Server Memory (KB) counter, then this means that SQL Server has enough memory to run efficiently


Author Closing Comment

ID: 35123204

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

MSSQL DB-maintenance also needs implementation of multiple activities. However, unprecedented errors can hamper the database management. In that case, deploying Stellar SQL Database Toolkit ensures fast and accurate database and backup repair as wel…
In this article, we will see two different methods to recover deleted data. The first option will be using the transaction log to identify the operation and restore it in a specified section of the transaction log. The second option is simpler and c…
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

624 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question