May 20, 2009 at 2:09 pm
hi there..
was hoping someone could help me.. what I was trying to do was using the performance counters in perfmon was to see total memory available on the box, along with how much is currently being used by sql server.
With this information I'd like to calculate some metrics like total percentage used etc, which I can do just fine on my own.. just not sure what performance counters I would use to show each of those values.
Any help would sure be appreciated.
Thanks
--------------------------
I long for a job where my databases dont have any pesky users accessing them 🙂
May 20, 2009 at 2:19 pm
Did you try to type "sql server memory counter" in any search engine? The result will give you excellent articles available on the internet:
http://www.sql-server-performance.com/tips/performance_monitor_memory_counter_p1.aspx
http://sqlserverpedia.com/wiki/Memory_-_Performance_Counters
etc….
These articles will give you much more than anybody could type in a few sentences.
No offense…
Alex Prusakov
May 20, 2009 at 2:26 pm
yep.. actually did that days ago, and I have roughly 20 or so sites bookmarked, none of which answered the exact question I asked. theres plenty of reference material on how things are calculated and why they are calculated and how best to use them, and while thats very good information that I'm going to keep (hence bookmarking them), I haven't found any that tell me the 2 performance counters im asking about, total memory on the box and total memory being used.. maybe my google-fu is just off and im not using the correct search term?
for example, i *think* I can use SQL Server: Memory Manager: Target Server Memory (KB) to get the sql memory used, but I dont know which to use for the total memory on the machine.
So what I was asking for wasn't so much an explanation which would require mutliple sentences about a particular subject, but more just a bit of help to choose the correct counter.
--------------------------
I long for a job where my databases dont have any pesky users accessing them 🙂
May 20, 2009 at 3:02 pm
To be honest, I do not really understand what for you need that information. It is like a question: how many cars are on all highways of the state right now and how many cars can be handled by highway system. Any answer is not giving you any clue if there is a traffic gem in downtown of a city. If I understand you correctly, you’d like to find if there is a memory pressure, right? If I am right, check this place first: http://searchsqlserver.techtarget.com/generic/0,295582,sid87_gci1265209,00.html. If not, do not focus on any counter but try to identify the problem and do search on the problem – not on a counter. I believe it is much productive…
Alex Prusakov
May 20, 2009 at 3:09 pm
I have a little app which will pull a few key metrics for me for different servers on the network.. some of these servers have applications on them, not good design, but they pre-date me, and theres not much I can do about it.
So one of the metrics I'd like to record is total memory on the machine, which I dont know without remoting into the machine and checking, which I'd rather not do. So I need total memory on the machine. Then I'd like to see how much sql is using, just at a glance.
I'm not troubleshooting a particular problem, but if I see that sql is using 95% of the memory on a box, and I have an application which runs intermittently on there.. i know im going to have a problem.. that kinda thing.
Like i say.. i know i can look at how much sql is using, and how much it'd like to use.. the piece of the puzzle im missing is how much physical (and otherwise) memory is available
--------------------------
I long for a job where my databases dont have any pesky users accessing them 🙂
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply