Tag Archives: Windows Server 2012

WSUS – Limit SQL (Windows Internal Database) memory

You may discover your WSUS servers SQL instance using most of the available memory – to limit its maximum memory usage, you can either do it via command line or via gui. Configure via GUI Open SQL Management Studio Connect to \\.\pipe\Microsoft##WID\tsql\query for WSUS 4 (Server 2012) or \\.\pipe\mssql$microsoft##ssee\sql\query for WSUS 3 using Windows Authentication Right click the server in Object Explorer and choose Properties

Posted in Technology | Tagged , , , | 14 Comments

Manage 2008 from 2012 Server Manager

NB. Don’t install this on Exchange or SharePoint servers – see comment from Chris below One of the biggest improvements to Windows Server 2012 is the (almost) all encompassing Server Manager. From any 2012 server you can now manage any other 2012 server through WinRM – but if you add a 2008 or 2008 R2 server to Server Manager, you will get a manageability warning of “Online – Verify WinRM 3.0 service is installed, running, and required firewall ports are open“. To get this working, there are 3 main steps to perform: Install Windows Management Framework 3.0 Allow remote server management through WinRM (preferred method is via Group Policy) Create firewall rules 1. Install Windows Management Framework 3.0 Go and get the appropriate .msu from here: http://www.microsoft.com/en-us/download/details.aspx?id=34595 Windows Server 2008 R2 SP1 WINDOWS6.1-KB2506143-x64.MSU Windows Server 2008 SP2 64-bit versions: WINDOWS6.0-KB2506146-x64.MSU 32-bit versions: WINDOWS6.0-KB2506146-x86.MSU As you can see, there are some slight caveats. 2008 … Continue reading

Posted in Technology | Tagged , , , , | 5 Comments