dfr031260
asked on
Calculate Memory Used by SQL Server Instance
How do I do that
http://www.mssqltips.com/tip.asp?tip=1268
ASKER
Not Good Enough.
How do I from a query level, calc this.
Please, no more normie's! I think I cans...
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
Not sure how to show current usage via a query but you could do something fancy with "total server memory" performance counters
ASKER
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
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
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
ASKER
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!
Hit me!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.