Re: WSUS

JJ wrote:

Hi:

Is there anyway to uninstall WSUS from a SBS installation? It's SQL Server
instance uses way too much memory.

How do you know that it's "too much"?
Is your server exhibiting significant performance problems, and if so, how do you know that it's down to excessive memory usage by the WSUS SQL instance?

And why didn't Microsoft build SBS in a way that is uses a single SQL Server
instance for WSUS, MSFW, SharePoint and SBS Monitoring?

There are a number of factors involved in deciding whether to use multiple instances of SQL Server or not. Not least in the case of SBS is that it's a number of pre-canned applications stitched together and there's limited room for changing installation methodologies for the individual products without making them unsupportable. Another significant angle is which versions of SQL are supported by each application, and the consequent variation in SQL features available to each application.

In the grand scheme of things, it really doesn't matter much anyway. The major difference is in visibility and manageability - you can tell which SQL instance(s) are busier or working harder than the others, something that would be impossible if they were all running together.

No wonder SBS brings servers with 4GB of RAM to their knees. And to top it
all, SBS can't use more than 4GB of RAM due to the 32-bit architecture.

I don't see SBS servers with 4Gb RAM "on their knees". They're running nicely, and making use of all that RAM, just as I expected them to. If an SBS server with 4Gb RAM really is suffering, then it's underspecified for the given workload.

SBS2003 can't use more than 4Gb RAM because it's essentially WS2003 Standard, which also can only use 4Gb RAM.

The next version of SBS is going to be 64-bit, and I speculate that the RAM limit is likely to rise significantly. If it remains consistent with WS2003 standard, that would be 32Gb.

I can't imagine I'm the only person to request this.

You do seem to be, at least so far.

--
Steve Foster [SBS MVP]
---------------------------------------
MVPs do not work for Microsoft. Please reply only to the newsgroups.
.

Relevant Pages

  • Re: how do I change the user install wizard to create user folder in different location?
    ... Les Connor [SBS Community Member] ... >> Regarding SQL and Sharepoint, ... >> file where I'm suppose to register the SHAREPOINT instance of SQL Server ... another install which is on just Windows 2003 server and SQL2000 ...
    (microsoft.public.windows.server.sbs)
  • Re: SQL service pack 4 & SBS 2003 premimum version
    ... Thank you for posting in the SBS newsgroup. ... SBS SharePoint with SQL ... whether SQL server is being installed or not. ... it will install the sixteenth instance of MSDE ...
    (microsoft.public.windows.server.sbs)
  • Re: WSUS
    ... I'm not seeing performance issues with the full enchilada installed, and 25 users busy hitting SQL. ... WSUS isn't difficult to uninstall - if you have WSUS v2 (installed with SBS R2) uninstall R2 from add/remove programs. ... How can anyone work with 4 instances of SQL Server on the same box? ...
    (microsoft.public.windows.server.sbs)
  • Re: WSUS
    ... Les Connor [SBS MVP] ... Is your server exhibiting significant performance problems, and if so, how ... SQL Server: ... >No wonder SBS brings servers with 4GB of RAM to their knees. ...
    (microsoft.public.windows.server.sbs)
  • Re: Outlook for MAPI on SBS
    ... I wound up looking at another thread here on installing SQL 2005 which I ... I have noticed something interesting here in SBS ... agent from the SBS Monitoring Agent to the 2005 agent instance. ... Is there an easy way to set up notifications from SQL Server ...
    (microsoft.public.windows.server.sbs)
Loading