Ray Laubert (4/5/2010)
You can query the sys.dm_os_performance_counters for object name = SQLServer:Memory Manager.
It will give you Total Server Memory that SQL is using and Target Server Memory.
I wanted to set an alert system on the actual RAM usage of the server by all the processes, not just the SQL Server process. So that when a particular threshold is reached for the RAM usage by all the process, I get an alert email.
For this purpose, I was looking for any default object in the SQL Alerts itself. SQL server has the alert system for the object SQLServer:Memory Manager, but it looks for the Memory that SQL is using. I needed alert in SQL Server for object "Memory".
Taking the result from the table wont trigger the alert.
I believe, it is not present in SQL Server.
I may have to look into perfmon for this.
Thanks. Please feel free to shout if find anything inside the SQL Server itself to track the "Memory" object.