November 3, 2003 at 8:18 am
Does anybody know which third party tool is good on monitoring the memory usage per database?
November 6, 2003 at 8:00 am
This was removed by the editor as SPAM
November 6, 2003 at 8:21 am
I am still very new to this entire arena of db administration and programming as well. However, i thought you could do this using perfmon? If i am wrong, please help to clarify as this would be good information for me to know as well?
Think great, be great!
November 6, 2003 at 8:33 am
There is no way to know the memory consumption on each database as I konw if multiple databases are in same instance. The performance monitor porvides memory usage at instance level only.
November 6, 2003 at 9:28 am
You can dig through the dbcc commands and see what's in the procedure cache, but not the database cache.
Perf mon will only give you total server memory.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply