Error sqlservr.exe is using too much memory

    KB ID 0000190 Dtd 01/03/10


    Seen on SBS 2008 with WSUS.

    The Windows internal database (the one used by WSUS) has no memory reservation limit, so it can use as much as it wants, this is a BAD thing!

    Your server will struggle because the following consumes to much memory.



    1. Click Start > In the search/run box type CMD {enter}.

    2. At command line issue the following commands,

     sqlcmd -S .pipemssql$microsoft##sseesqlquery -E sp_configure ’show advanced options’, 1; reconfigure; go sp_configure ‘max server memory’, 512; reconfigure; go exit

    Related Articles, References, Credits, or External Links



Author: Migrated

Share This Post On