Cadzow Knowledgebase


Welcome
Contact Us
Professional
Services

Consulting
Knowledgebase/
Site Search

Remote Support

Print Friendly

Sqlservr.exe Consumes Most of Memory in SBS 2008

  1. Open an Administrative command prompt.

  2. Type:

    osql -E -S \\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query

  3. At the prompt, type:

    1> sp_configure 'show advanced options',1

    2> reconfigure with override

    3> go

    The screen displays:

    Configuration option 'show advanced options' changed from 0 to 1. Run the
    RECONFIGURE statement to install.

  4. Type:

    1> sp_configure 'max server memory', 512

    2> go

    (NB The RAM usage of 512Mb is a suggestion, use whatever is appropriate in your environment.)

    The screen displays:

    Configuration option 'max server memory (MB)' changed from 2147483647 to 512.
    Run the RECONFIGURE statement to install.

  5. Type:

    1> exit

  6. Restart the service, or reboot the server. The database instance may be opened in the management applet using the above notation.

Copyright © 1996-2019 Cadzow TECH Pty. Ltd. All rights reserved.
Information and prices contained in this website may change without notice. Terms of use.


Question/comment about this page? Please email webguru@cadzow.com.au