Re: sqlservr using lots of memory
From: David Copeland [MSFT] (davidcop_at_online.microsoft.com)
Date: 02/03/05
- Next message: IBC: "Re: Rename domain in SBS2003"
- Previous message: Bill Peng [MSFT]: "Re: RWW Problem"
- In reply to: Adam Butler: "Re: sqlservr using lots of memory"
- Next in thread: Adam Butler: "Re: sqlservr using lots of memory"
- Reply: Adam Butler: "Re: sqlservr using lots of memory"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 2 Feb 2005 23:24:21 -0600
Adam,
Are you using the following? If so, what error do you get?
osql -E -S servername\sbsmonitoring
> sp_configure 'show advanced options',1
> reconfigure with override
> go
> sp_configure 'max server memory', nnnn
> reconfigure with override
> go
where nnnn is the maximum amount of ram in mb's you want it to use..
-- 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:emiWm9CCFHA.1264@TK2MSFTNGP12.phx.gbl... > 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. >>> >>> >>> >> >> > >
- Next message: IBC: "Re: Rename domain in SBS2003"
- Previous message: Bill Peng [MSFT]: "Re: RWW Problem"
- In reply to: Adam Butler: "Re: sqlservr using lots of memory"
- Next in thread: Adam Butler: "Re: sqlservr using lots of memory"
- Reply: Adam Butler: "Re: sqlservr using lots of memory"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
