Re: Database Memory

From: Greg D. Moore \(Strider\) (mooregr_deleteth1s_at_greenms.com)
Date: 09/25/04 

Date: Sat, 25 Sep 2004 16:06:23 GMT

"Marc" <anonymous@discussions.microsoft.com> wrote in message
news:1b6901c4a19e$22887750$a401280a@phx.gbl...
> Hi,
>
> I'm wondering, is there any option/tool that could let me
> monitor a database's memory. There's a maximum amount
> that we can allow, and it would be nice to have some kind
> of alarm/warning message that would tell us we're at our
> maximum, or close to it.

You can also set SQL Server to limit its use of memory.

That may be the best way of doing it.

>
> Thank you kindly.
>
> Marc

Relevant Pages

  • understanding ulimit -r -m -v
    ... -the maximum amount of virtual memory ... fputs("mallocating 4 gigs...\n", stderr); ...
    (Debian-User)
  • 2 or 4GB memory?
    ... A friend whose judgment I normally trust says I'll never need more than ... the 2.0GB memory that comes with the computer. ... maximum amount of memory? ...
    (microsoft.public.windowsxp.hardware)
  • Re: memory allocation in unix
    ... "We" would be the people you're aksing for help, i.e., the people ... > determine the amount of memory it can give a program? ... The kernel doesn't arbitrarily allocate some maximum amount ... Rich Teer, SCNA, SCSA, author of "Solaris Systems Programming" ...
    (comp.unix.programmer)
  • Re: Software manuals [was: Re: App sought that issues mouse codes...]
    ... more RAM. ... I recently did some work on my sister's 2001 vintage Windows ... Unfortunately, the maximum amount ... markedly with that amount of memory. ...
    (comp.sys.acorn.apps)
  • Re: Database Memory Tool
    ... There's a maximum amount ... You can use performance monitor to watch memory used by the SQL Server ...
    (microsoft.public.sqlserver.tools)