May 8, 2002 at 11:10 am
[sql server 2000 enterprise edition
windows 2000 advanced server]
How can I find out exactly how much memory each Instance is consuming ? (i have 6 instances)
May 8, 2002 at 3:12 pm
I beleive that the performance monitor counters have objects for each instance so you can look at them individually.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
May 9, 2002 at 6:47 am
I have looked but none of these match up with the Task Manager "sqlserver.exe" process and the memory it is consuming ?????
May 9, 2002 at 9:45 am
I know of no other tool to see this off hand. Not sure where you could find anything to tell you which server instance is what PID in Task Manager but if I find something I will try to pass along.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
May 9, 2002 at 3:10 pm
I'm not sure if that what you are looking for, but check the system stored proc MS_sqlctrs_users, it will give some info including memory usage by processes.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply