SQL Server Performance Forum – Threads Archive

How Much Memory Is Using

Hello Guys I am running SQL Server 2000 with 8 GB of memory out of which 7 GB is reserved for SQL Server through AWE. Now if I go through the windows performance counters, I can only see the total memory allocated i.e 7 GB, My need is to see that out of this 7 GB how much SQL Server is utilizing at some instance.
If anyone can tell me the query than it would be great help for me. Mani

In performance monitor: SQL Server:Memory Manager
Total Server Memory(KB)
Also, note that if the Target Server Memory is higher, you will want to look at the Cache Hit Ratio also. Generally, you will see a correllation that if Target Server Memory is higher, the cache hit ratio will begin to fall, performance will begin to degrade, and you’ll need to tune or buy more RAM to fix the issue. Also, are you using Enterprise Edition? MeanOldDBA
[email protected] When life gives you a lemon, fire the DBA.

This thing I already checked. Look in performance monitor the Total SErver Memory will always show you the memory which you set through AWE which is 7 GB in my case.
I want to know that at some instance how much in actual the SQL SERver is utilizing from this 7 GB i.e. may be SQL is using the whole memory or may be he is using the part for memory from 7 GB. This is what i want to know.
I dont think that any performance monitor counter can tell you this thing. Mani

Performance Monitor should. Try task manager.
Luis Martin
Moderator
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.

if performance monitor than what counter? Task Manager is not showing.

In Performance Monitor, Derrick counters.
With task manager you can see sqlsrv, but you have to choosee columns from menu to see real memory and swap memory. Other idea: in Forum Announcements you can find two free tools witch help: QUEST CENTRAL and IDERA. Luis Martin
Moderator
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.

Quest Central is really good at showing exactly how much is being used and what it’s being used for. I can’t believe that tool is freeware. MeanOldDBA
[email protected] When life gives you a lemon, fire the DBA.

Alongwith SQL Server:memory counters collect Process, processor, SQL Server<img src=’/community/emoticons/emotion-2.gif’ alt=’

‘ />atabase -Trnasaction/sec and Memory counters. <hr noshade size="1">Satya SKJ Moderator http://www.SQL-Server-Performance.Com/forum</a> <center>This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.</center>

don’t know if this will help you, but I had to do the same thing and this is what I did. I ran DBCC MEMORYSTATUS then you’ll see in the 2nd section, committed, target and hashed buffers. In you case, with AWE enabled, you should see 7 GB for both ‘committed’ and ‘target’ (u have to multiply by 8 becoz these pages are 8K pages). Then ‘Hashed’ is the number of pages that are actually being used to store data and indexes, which I think is what you mean by how much SQL Server is utilizing.

DBCC MEMUSAGE will also tell the top 20 objects that’s taking up your memory. Will give u the object_ids and index_ids.

]]>