Just an FYI. After installing WSUS 3.0 I needed to throttle back the memory
on the MICROSOFT##SSEE process. anyone else seeing high CPU usage on the SQL
process?
Followed Susan's instructions and cut the CPU time by 2/3.
SBS >> WSUS + Mem Throttle
If you have SQL Server client tools installed, you can use osql.exe or
sqlcmd.exe. But make sure you are comfortable with TSQL
sp_configure 'show advanced options', 1
reconfigure
GO
sp_configure 'max server memory', 512 (or change this to any value you wish)
reconfigure
GO
--
MCP MCDBA MCAD MCSD MCT MCTS MCITP:DBA
"Helping people grow and develop their full potential as God has plan for
them"