Re: Memory Issue: MSSQL$SBSMonitoring Process

Different commands though

http://msmvps.com/bradley/archive/2005/02/04/34984.aspx

osql -E -S YOURSERVERNAME\sbsmonitoring  [hit enter]

[you'll now enter like a command screen]

sp_configure 'show advanced options',1 [hit enter]

reconfigure with override  [hit enter]]

go  [hit enter]

sp_configure 'max server memory', ### [enter the value of the max... I'm trying 70 ... I just guessed at this from the poster in the newsgroup] [hit enter]

reconfigure with override  [hit enter]

go  [hit enter]



Mariette Knap [SBS MVP] wrote: 
In news:05DC64B5-E202-4984-BE8C-EB370B591B79@xxxxxxxxxxxxx,
Keith Russo <KeithRusso@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:


I've notice a memory leak with MSSQL$SBSMonitoring service. From Task
Manager the sqlservr.exe process grows to more than 680,000 K in a
weeks time.

Restarting the service fails with message that service has started
then stopped and some service will do this if it has no work to do.

This is a SBS2003 Std (pre sp1). 


Same procedure is valid for monitoring:

How to limit the amount of Ram ISA logging takes:
http://www.smallbizserver.net/Default.aspx?tabid=247


.

Relevant Pages

  • RE: Business Contact Manager V2
    ... Thank you for posting to the SBS Newsgroup. ... I understand that you have installed the Business Contact Manager (BCM) on ...
    (microsoft.public.windows.server.sbs)
  • Re: Announcement
    ... Jesus fuck, there is so much wrong with this election campaign ... The XI needs a manager that can do more than paraphrase crappy ... >you, saves this newsgroup. ... >spent posting incoherent profanity to this newsgroup. ...
    (uk.sport.football)
  • RE: Scorecard Manager 2005
    ... Thank you for posting in SBS newsgroup. ... Based on the system requirement of the Microsoft Office Business Scorecard ... Manager 2005, it should be able to be installed on SBS 2003. ...
    (microsoft.public.windows.server.sbs)
  • Re: Remove Access to Work Computer
    ... > but is meeting with a recalcitrant MIS/IT manager. ... > using Windows Server software. ... I see there is a newsgroup for microsoft.public.windowsxp.work_remotely ...
    (microsoft.public.windowsxp.network_web)
  • Re: OT: New Job
    ... >> I've managed to land something a bit more intellectual - manager for ... ITYM Cheap wank mags for the newsgroup? ...
    (uk.rec.cars.modifications)
Loading