Performance Monitoring - Memory

Hi,
We have a SQL Server with various databases running. Is there a way to do
performance monitoring for Memory used by each database? We would like to
know which database is taking most memory. Currently it's using 1.4Gb Mem
& 1.4Gb VMem.
Thanks
Nich
Using Opera's revolutionary e-mail client: http://www.opera.com/m2/
Assuming that most of the memory is used by the data cache (which is usually
the case), running DBCC MEMUSAGE (names, 100) will display the 100 largest
objects in the data cache, identified by database and name.
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backup files? Use MiniSQLBackup Lite, free!
"Nicholas Aquilina" <nickaquilina@.hotmail.com> wrote in message
news:opsfsr0bwy73zl9p@.nicka.gfimalta.com...
> Hi,
> We have a SQL Server with various databases running. Is there a way to do
> performance monitoring for Memory used by each database? We would like to
> know which database is taking most memory. Currently it's using 1.4Gb Mem
> & 1.4Gb VMem.
> Thanks
> Nich
> --
> Using Opera's revolutionary e-mail client: http://www.opera.com/m2/