Re: WSUS



Hi JJ,

You need to learn how to limit the memory use of the SQL/MSDE instances. A google search of this newsgroup should turn up some hits.

--
Les Connor [SBS MVP]


"JJ" <JJ@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:8CA9A03C-E479-4BA0-9E72-95CB92E3532B@xxxxxxxxxxxxxxxx
"Steve Foster [SBS MVP]" wrote:
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?

You're actually defending Microsoft on this? Try this on a server running
SQL Server:
tasklist /svc /fi "IMAGENAME eq sqlservr.exe"

That gives you the process ids, instance names, etc. of all SQL Server
instances on the PC. Using the process id in Task Manager, you can find which
SQL Server instance is using what amount of memory.

I guess since you do not know these basic things, it's pointless to try to
convince you of anything - it would just bounce off you.

And how do you know my server is not exhibiting performance problems?

Plus, how can you speak for every possible installation of SBS, even with
4GB of RAM?

JJ

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: SBS 2003 Std - SQL Eval expired...will un-installing break SBS fun
    ... I agree with Claus that you're able to remove SQL 2005 instances if you did ... you can get SBS R2 which already contains SQL Server 2005 ... Workgroup Edition, and upgrade Sharepoint instance, and install other ...
    (microsoft.public.windows.server.sbs)
  • Re: sharepoint error
    ... If you are using SBS 2003 Premium Edition the easiest way is to follow ... to upgrade the SharePoint named instance. ... and search on "Migrating from WMSDE to SQL Server" ... Microsoft Small Business Server Support ...
    (microsoft.public.windows.server.sbs)
  • Re: Best practice on virtualizing SBS
    ... Would the /3GB switch give me problems if I only have 3 GB of ram and not 4? ... If you do install a full HostOS, then make the HostOS a Standalone Server ... and install SBS with any other OS as Guests. ... At the moment my SBS is running on 1GB of ram, the host box will get 3GB ...
    (microsoft.public.windows.server.sbs)
  • Re: Virtual Server on SBS
    ... SBS) won't be able to recognise it. ... can only use 4 GB of RAM. ... Since you're 2800 is running your SBS server, you are in 32 bit mode, ... So I'd need a device CAL for Virtual Server? ...
    (microsoft.public.windows.server.sbs)
  • RE: SQL
    ... you can install SQL 2005 workgroup edition on SBS ... 2003 standard server without causing any issue. ...
    (microsoft.public.windows.server.sbs)