Re: sqlservr using lots of memory

From: Adam Butler (adambutler100_at_hotmail.com)
Date: 02/01/05 

Date: Tue, 1 Feb 2005 01:26:52 -0600

Yep,
Did your commands and:
MSSQL$SBSMONITORING

This seems to be the one eating memory.

"David Copeland [MSFT]" <davidcop@online.microsoft.com> wrote in message
news:OBM4UlBCFHA.3908@TK2MSFTNGP12.phx.gbl...
> Adam,
>
> Can you run the following command from a command prompt to find out the
> process id's to the different instances..
>
> tasklist /svc
>
> Then open up Task Manager, click on the Processes tab (note that you may
> need to click on the View/Select Columns option to make sure that the PID
> (process identifier) option is selected), the look for the different
> process id's to see which process id is using the memory.
>
>
> --
>
> Hope that helps,
> David Copeland
> Microsoft Small Business Server Support
>
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> Newsgroups:
> SBS v4.x : microsoft.public.backoffice.smallbiz
> SBS 2000: microsoft.public.backoffice.smallbiz2000
> SBS 2003: microsoft.public.windows.server.sbs
>
>
> "Adam Butler" <adambutler100@hotmail.com> wrote in message
> news:uV9sBVBCFHA.2180@TK2MSFTNGP12.phx.gbl...
>> Hi,
>>
>> Been running SBS 2003 for a year and a half now.
>> All of a sudden my memory usage by sqlservr.exe has shot from 70 to over
>> 500 Mb.
>>
>> I have always had three instances of sqlservr running and at most I'd see
>> maybe 70 Mb on the highest one. Now, I see over 500 Mb for the high one
>> and the other two are still normal at 38 and 19 Mb or so each.
>>
>> I read some old posts and they had a command to limit the memory usage
>> but I get an error and I assume it is from the fact that I'm running
>> Standard edition.
>>
>> Can I do anything to reduce the memory usage?
>> I did reboot the server and it has helped but the usage is slowly
>> creeping back up over 100 Mb after only 24 hours.
>>
>>
>>
>
>

Relevant Pages

  • Re: avoiding glTranslatef*
    ... that "vertex" would be a internal hardware-level command. ... The modern 3D chip has hundreds of ALU's and a _LOT_ of processing ... What they need is more memory bandwidth, ...
    (comp.graphics.api.opengl)
  • Re: Isnt Command Rate a "memory setting?"
    ... If I set the command rate to 2T, ... spec for your memory says 2.75v. ... is telling me that it's NOT a memory setting. ... PSU problems are not out of ...
    (alt.comp.periphs.mainboard.asus)
  • Re: open command failing on serial port
    ... >>I tried changing the pci slot, it gets assigned the same base ... Command: 0x0106 Memory Enabled, I/O Disabled ... AGP Status: 0x00000200 ...
    (comp.unix.sco.misc)
  • 2924 XL: Insufficient memory when booting
    ... The "version" command showed it had 8 meg of memory. ... This switch is to replace the one partially damaged by lightning. ... The TAR command when expanding the html files due to lack of space. ...
    (comp.dcom.sys.cisco)
  • Re: Append to char *
    ... > That's a pretty good way to make demons fly out your nose, ... invokes undefined behavior. ... command similarly points to 8 bytes of memory. ...
    (comp.lang.c)