RE: Database Memory
From: Hari Prasad (HariPrasad_at_discussions.microsoft.com)
Date: 09/23/04
- Next message: Dan Guzman: "Re: service account expiring passwords"
- Previous message: Josephine: "BUILTIN\Administrators help"
- In reply to: Marc: "Database Memory"
- Next in thread: Greg D. Moore \(Strider\): "Re: Database Memory"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Thu, 23 Sep 2004 14:57:02 -0700
Hi,
Steps in creating alerts:
1. Open system monitor
2. Expand the Performace Logs and alerts group
3. Right click above alerts and select New alert
4. Give a Alert name as Memory Monitoring
5. In the counter , click Add
6. Select the performance object "Memory"
7. Select the counter "Available Mbytes"
8. Alert when value is "UNDER" - Give a value based on the physical memory
(if it is 1024 MB (1GB) then
give a value (150 MB)
9. Set the "Sample data every" 20 Mintes (Units)
10. Send the alert to Application error log / Seding Net send to you.
Thanks
Hari
MCDBA
"Marc" wrote:
> 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.
>
> Marc
>
- Next message: Dan Guzman: "Re: service account expiring passwords"
- Previous message: Josephine: "BUILTIN\Administrators help"
- In reply to: Marc: "Database Memory"
- Next in thread: Greg D. Moore \(Strider\): "Re: Database Memory"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
