Calculate Memory Used by SQL Server Instance

How do I do that
dfr031260Asked:
Who is Participating?
 
QPRCommented:
You provide the magic numbero when you set up the alert.
Alert if counter rises above XXXKbs
0
 
dfr031260Author Commented:
Not Good Enough.
How do I from a query level, calc this.

Please, no more normie's!  I think I cans...
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
QPRCommented:
normies?
Not sure how to show current usage via a query but you could do something fancy with "total server memory" performance counters
0
 
dfr031260Author Commented:
Guys, is this that hard?  I have a SQL Server configured to use a max of 256mb.  I would like to be able to know if it us running out of headroom.  Is there an alert, talk to me?

Dav
0
 
QPRCommented:
You want a query or an alert?
Enterprise manager - sql agent... alerts.
SQL server performance condition alert - > choose your memory option.
Alert if reaches X level.
Response = alert operator.

Not sure if this falls into normie(?) category or I think I cans but looks like I'm the only one offering anything at the moment
0
 
dfr031260Author Commented:
Actually that was rather cool-lala, but I already thought of that.  Questioni is what is the alert calculation, how does it come up with the magic numbero?  Come on GuruFuruMannuTiiiiii, do the VooDoo you do so well BroHammer.  I got a stinking feeling it is an undocumented dbcc thang, but I'll be damned if I can find it.  
Hit me!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.