WSUS DB and large memory consumption


image 

One of my VM’s is running WSUS 3.0 SP1 on the Windows Internal Database. This VM had a really high Memory Balloon value in vCenter server.

image

To verify the value above, I started a ssh session to the ESX Host and run the esxtop command. When esxtop is loaded, you can see the ballooning values if you press: v m f i

image

For more information about ballooning see Arnim his article here: http://www.van-lieshout.com 

So how can you solve the memory lurking of this VM. Well after looking around in the taskmanager, I found out that the sqlsrv.exe process was eating the memory. So after some searching on Google I found the following solution:

Open the command line (start – run –cmd) on the server with the sql 2005 express database. Go to: C:\Program Files\Microsoft SQL Server\90\Tools\Binn. Now run the following commands to limit the max memory to 256 MB:

osql -E -S <server name>\MICROSOFT##SSEE
1> sp_configure ‘show advanced options’, 1;
2> reconfigure;
3> go
Configuration option ‘show advanced options’ changed from 0 to 1. Run the RECONFIGURE statement to install.
1> sp_configure ‘max server memory’, 512;
2> reconfigure;
3> go
Configuration option ‘max server memory (MB)’ changed from 2147483647 to 512. Run the RECONFIGURE statement to install.
1> exit

Or via SQLCMD.EXE:

SQLCMD.EXE –E -S \MICROSOFT##SSEE
1> sp_configure ’show advanced options’, 1;
2> reconfigure;
3> go
Configuration option ’show advanced options’ changed from 0 to 1. Run the RECONFIGURE statement to install.
1> sp_configure ‘max server memory’, 512;
2> reconfigure;
3> go
Configuration option ‘max server memory (MB)’ changed from 2147483647 to 512. Run the RECONFIGURE statement to install.
1> exit

Sources:

Advertisements

Microsoft: Server 2008 Server Manager to support WSUS 3.0 SP1


An update for Windows Server 2008 Server Manager (KB940518) has been released to integrate Windows Server Update Services 3.0 Service Pack 1 (WSUS 3.0 SP1). This update to Server Manager enables full integration of WSUS 3.0 SP1 into Server Manager, allowing installation, configuration, and management of WSUS 3.0 SP1 using the Server Manager console and wizards.

image

How to determine whether the service pack is installed

Look for Update for Windows (KB940518) in the View installed updates item or in the Programs and Features item in Control Panel. If Update for Windows (KB940518) does not appear, the update is not installed.

 

Installation instructions

To avoid restarting the computer, verify that the Initial Configuration Tasks, Server Manager, and the Servermanagercmd.exe process are not running during the installation process. You must also log on to the computer as an administrator to install this update.

 

1. On a computer that is running Windows Server 2008, download the update package from the Microsoft Web site that is listed in the “Update information” section.

2. Double-click the download package to start the Setup wizard. Follow the instructions in the wizard to complete the installation.

3. Use one of the following methods to open Server Manager:

• Click Start, right-click Computer, and then click Manage.

• Click Start, point to Administrative Tools, and then click Server Manager.

• Click the Quick Launch bar, and then click Server Manager.

Note If WSUS 3.0 SP1 is already installed on your computer, you do not have to complete the remaining steps.

4. On the Server Manager home page, click Add Roles in the Roles Summary section.

5. On the Select Roles page of the Add Roles Wizard, click to select Windows Server Update   Services from the list of available roles.

6. Follow the instructions in the Add Roles Wizard to complete installation.

More information and download locations can be found here: http://support.microsoft.com/kb/940518

Bron: http://windows2008security.com/windows-server-security/update-for-windows-server-2008-server-manager-to-support-windows/

WSUS: WSUS 3.0 SP1 Released


De volgende punten zijn verbeterd:

• Support for Windows Server 2008.
• New Client Servicing API:
• Support client registration.
• Filter of updates by category and classification.
• Provide applicability rule extension mechanism.
• Obtain package metadata and report update status for each client.
• Improvements for local publishing: supports publishing of drivers within the enterprise by using vendor provided catalogs. API include support for bundles and prerequisites.
• All hotfixes: WSUS 3.0 SP1 includes all the changes and hotfixes that have been issued since the release of WSUS 3.0.
• Support for Microsoft SQL Server 2005: WSUS 3.0 SP1 lets you use SQL Server 2005.

Servicepack 1 kun je hier downloaden: http://www.microsoft.com/

WSUS: cannot download large Windows update files in Windows Server 2003


 

De volgende symptomen kunnen optreden:

SYMPTOMS

On a computer that is running Microsoft Windows Server 2003, when you try to use Windows Server Update Services to download Windows update files that are larger than 700 megabytes (MB), the download operation does not succeed.

CAUSE

This problem occurs because the WinVerifyTrust function in Windows Server 2003 cannot verify the certificate validity of the Windows update files.

In het document KB888303 vind je meer informatie.

How To: Upgrade WSUS 2.0 to WSUS 3.0


Hier een quote van Bink.nu

A month earlier then expected WSUS 3.0 is released to web!
Microsoft Windows Server Update Services (WSUS) 3.0 delivers new features including an MMC-based user interface with advanced filtering and reporting, improved performance and operational reliability, flexible deployment options to improve branch office support, and more content access through the Microsoft Update Catalog site.

Download WSUS 3.0 hier: http://go.microsoft.com/fwlink/?LinkId=89379

Hier vindt je meer informatie:
Release notes
Step-by-step: Getting started
WSUS 3.0 Overview
Deploying WSUS 3.0
WSUS 3.0 Operations guide
Script Center

Software requirements voor WSUS 3.0 server installatie

.Net 2.0 http://www.microsoft.com
MMC 3.0 http://www.microsoft.com
Microsoft Report Viewer http://www.microsoft.com

Stap 1: Backup maken

Maak eerst een backup van je database mocht deze extern draaien. Maak daarna een backup van de machine / VM.

Stap 2: requirements installeren

.Net 2.0 installeren, MMC 3.0 (Mocht je laatst SP2 voor Windows Server 2003 hebben geïnstalleerd, dan kun je deze stap overslaan) en Microsoft Report viewer.

Stap 3: WSUS 3.0 installeren

Nadat je de prerequirements hebt geïnstalleerd, kun je beginnen met de upgrade naar WSUS 3.0.

De setup wordt gestart en vindt een bestaande installatie van WSUS 2.0. Deze moet dus worden bijgewerkt naar WSUS 3.0.

upgradewsus.gif

upgradewsus2.gif

De Setup wizard vindt een bestaande installatie van MSDE 2000 deze moet worden bijgwerkt naar Windows Internal Databse.

upgradewsus3.gif

WSUS is bijgewerkt.

upgradewsus5.gif

Herstart de Server.

upgradewsus6.gif

Nadat je het nieuwe console hebt geopent en verbinding hebt gemaakt met de server, kun je beginnen met het inrichten en onderhouden van je WSUS 3.0 server.

Happy Patching!

Er kunnen een aantal EventID’s optreden nadat de upgrade is uitgevoerd. Lees hier hoe je dat kunt oplossen.


Bron: http://bink.nu/Article9992.bink