Database Memory

Hi,
I'm wondering, is there any option/tool that could let me
monitor a database's memory. There's a maximum amount
that we can allow, and it would be nice to have some kind
of alarm/warning message that would tell us we're at our
maximum, or close to it.
Thank you kindly.
MarcIf your DB is SQL Server, take a look at or
http://msdn.microsoft.com/library/en-us/adminsql/ad_mon_perf_76cm.asp. (or
in Books On-Line under Administering SQL Server .. Choosing a Monitoring
Tool). System Monitor (formerly PerfMon) supports sending alerts if a
threshold is exceeded. If you want to home grow your own, take a look at
the sp_monitor stored proc (in master DB) by running sp_helptext
"sp_monitor" .
--
-- "This posting is provided 'AS IS' with no warranties, and confers no
rights."
jhmiller@.online.microsoft.com
"Marc" <anonymous@.discussions.microsoft.com> wrote in message
news:1b6601c4a19e$0f77f140$a401280a@.phx.gbl...
> Hi,
> I'm wondering, is there any option/tool that could let me
> monitor a database's memory. There's a maximum amount
> that we can allow, and it would be nice to have some kind
> of alarm/warning message that would tell us we're at our
> maximum, or close to it.
> Thank you kindly.
> Marcsql