locked
limit WID memory RRS feed

  • Question

  • Hi,

    for years I used couple of commands for limiting WID (SQL) memory use.

    I upgraded in place server 2012 (with WSUS) to 2019.

    It started to behave... Found that IIS ate memory.

    I added the server memory and put higher limit for IIS. Everything works fine.

    My WSUS on 2012 worked fine for last couple of years with 6GB of RAMtotal, tweaked with 1GB max for IIS and 2GB for WID.

    After upgrade to 2019 I set 12GB total. Limited IIS to 4GB (it helped to fix failures) and I took this memory limit from the articles described the same errors as I had.

    What I see now... IIS in quiet state takes 2GB. WID - 4 GB.

    I would like to limit SQL as I did previously in order to eliminate a potential jump.

    Can somebody provide commands lines for WID memory limiting that actually work with prerequisites if necessary.

    It was a bit a tricky syntax from 2008 to 2012. So, don't want even to try it on 2019.

    Thanks.


    --- When you hit a wrong note its the next note that makes it good or bad. --- Miles Davis

    Monday, September 9, 2019 1:22 PM

Answers

  • Hi,
       

    Have you tried using the osql command to limit the maximum memory usage of WID?
    The steps are as follows:
      

    1. In the elevated CMD, enter the following command to connect to WSUS:
      osql -E -S \\.\pipe\Microsoft##WID\tsql\query
    2. Enter the following commands:
      exec sp_configure 'show advanced option', '1';
      reconfigure;
    3. To view currently set max server memory:
      exec sp_configure;
      go
    4. To reconfigure:
      exec sp_configure 'max server memory', 4096;
      reconfigure with override;
      go
    5. Exit the adjustment.
      quit
        

    Hope the above can help you.
       

    Regards,
    Yic

    Please remember to mark as answers if they help.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    • Marked as answer by pob579 Friday, September 13, 2019 11:45 AM
    Tuesday, September 10, 2019 3:05 AM
  • what is the command for checking current limit without reconfigure entries?

    Is the result displayed after running this command not what you need?

    exec sp_configure;
    go

      

    Regards,
    Yic

    Please remember to mark as answers if they help.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    • Marked as answer by pob579 Friday, September 13, 2019 11:45 AM
    Thursday, September 12, 2019 2:38 AM

All replies

  • https://www.ajtek.ca/wsus/how-do-i-connect-to-the-windows-internal-database-wid/

    Right click the database and go to properties. The information you're looking for is in there.

    Easier to run it in the GUI.

    Also take a look at:

    https://www.ajtek.ca/wsus/wsus-system-requirements-what-should-i-plan-for/


    Adam Marshall, MCSE: Security
    https://www.ajtek.ca
    Microsoft MVP - Windows and Devices for IT

    Monday, September 9, 2019 8:13 PM
  • Hi,
       

    Have you tried using the osql command to limit the maximum memory usage of WID?
    The steps are as follows:
      

    1. In the elevated CMD, enter the following command to connect to WSUS:
      osql -E -S \\.\pipe\Microsoft##WID\tsql\query
    2. Enter the following commands:
      exec sp_configure 'show advanced option', '1';
      reconfigure;
    3. To view currently set max server memory:
      exec sp_configure;
      go
    4. To reconfigure:
      exec sp_configure 'max server memory', 4096;
      reconfigure with override;
      go
    5. Exit the adjustment.
      quit
        

    Hope the above can help you.
       

    Regards,
    Yic

    Please remember to mark as answers if they help.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    • Marked as answer by pob579 Friday, September 13, 2019 11:45 AM
    Tuesday, September 10, 2019 3:05 AM
  • I have SQLcmd (SQL utilities) installed on the server that is upgraded in place from  2012 to 2019.

    what is the command for checking current limit without reconfigure entries?

    I think that it keeps the limit assigned before in place upgrade of my WSUS on 2012.

    Currently shows 4,437.3 MB. But I want to be sure that the limit actually set.

    Thanks.


    --- When you hit a wrong note its the next note that makes it good or bad. --- Miles Davis


    • Edited by pob579 Wednesday, September 11, 2019 3:06 PM
    Wednesday, September 11, 2019 2:39 PM
  • what is the command for checking current limit without reconfigure entries?

    Is the result displayed after running this command not what you need?

    exec sp_configure;
    go

      

    Regards,
    Yic

    Please remember to mark as answers if they help.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    • Marked as answer by pob579 Friday, September 13, 2019 11:45 AM
    Thursday, September 12, 2019 2:38 AM
  • Yic,

    this is the screenshot from my WSUS.

    Looks like maximum was set to 2GB. Very possible before I in place upgraded to 2019.

    How to explain that it takes 4.5GB even limit is set to 2GB.

    IIS is set now to 4GB max that looks OK.

    Thx.


    --- When you hit a wrong note its the next note that makes it good or bad. --- Miles Davis

    Friday, September 13, 2019 11:48 AM