Calculate Memory Used by SQL Server Instance

How do I do that
dfr031260Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
QPRConnect With a Mentor Commented:
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
What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

 
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.