Error sqlservr.exe is using too much memory

    KB ID 0000190 Dtd 01/03/10

    Problem

    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.

    SQL/MSSQL$MICROSOFT##SSEE

    Solution

    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

    VMADMIN Technet

Author: Migrated

Share This Post On