Re: WSUS



"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: Redundancy design in SBS Domain
    ... But virtualization was not on my radar, and Exchange and SQL need more with each iteration. ... I originally went the SBS route because it was by far the cheapest was to get a server up and running with SQL Server at the time. ...
    (microsoft.public.windows.server.sbs)
  • 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: 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: SQL-SERVER 2005 SP2 und Microsoft Dynamics 5.0 (ehem. Navision
    ... Wert ist immer zwischen 84,7 -99,8 akt. ... es geht darum wieviel % der Daten, die der SQL Server wollte bereits in seinem Workspace waren. ... 16 GB 2 GB RAM ...
    (microsoft.public.de.sqlserver)

Loading