Link to home
Start Free TrialLog in
Avatar of dfr031260
dfr031260

asked on

Calculate Memory Used by SQL Server Instance

How do I do that
Avatar of QPR
QPR
Flag of New Zealand image

Avatar of dfr031260
dfr031260

ASKER

Not Good Enough.
How do I from a query level, calc this.

Please, no more normie's!  I think I cans...
normies?
Not sure how to show current usage via a query but you could do something fancy with "total server memory" performance counters
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
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
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!
ASKER CERTIFIED SOLUTION
Avatar of QPR
QPR
Flag of New Zealand image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial