Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Alert for Memory Consumption Expand / Collapse
Posted Monday, August 31, 2009 8:17 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, November 24, 2016 6:01 PM
Points: 43, Visits: 1,006
Can somebody provide some suggestions on how to configure an email alert for SQL Server memory consumption using counters like Total Server Memory(KB),Working Set or the SQL DMV counters?

I would prefer if this alert can be configured from inside SQL Server as I have DB mail configured.Example:It would send me an email if the Total Server Memory(KB) reaches 2GB.

Any help is appreciated.
Post #779920
Posted Monday, August 31, 2009 9:18 AM



Group: General Forum Members
Last Login: 2 days ago @ 5:18 AM
Points: 45,619, Visits: 44,147
Duplicate post. No replies to this thread please. Direct replies to:

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #779982
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse