Solved

Question about TARGET SERVER Memory and TOTAL SERVER Memory

Posted on 2011-03-13
2
298 Views
Last Modified: 2012-05-11
Hello

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?

Thanks

bibi
0
Comment
Question by:bibi92
2 Comments
 
LVL 14

Accepted Solution

by:
Daniel_PL earned 500 total points
Comment Utility
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

http://www.sql-server-performance.com/tips/performance_monitor_memory_counter_p1.aspx
0
 

Author Closing Comment

by:bibi92
Comment Utility
Thanks
0

Featured Post

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

I wrote this interesting script that really help me find jobs or procedures when working in a huge environment. I could I have written it as a Procedure but then I would have to have it on each machine or have a link to a server-related search that …
Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

763 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now