• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 310
  • Last Modified:

Calculate Memory Used by SQL Server Instance

How do I do that
0
dfr031260
Asked:
dfr031260
  • 4
  • 3
1 Solution
 
dfr031260Author Commented:
Not Good Enough.
How do I from a query level, calc this.

Please, no more normie's!  I think I cans...
0
 
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
Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

 
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
 
QPRCommented:
You provide the magic numbero when you set up the alert.
Alert if counter rises above XXXKbs
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now