• Home
  • General
  • MSSQL $MICROSOFT ##SSEE Using All System Memory
IT tutorials

MSSQL $MICROSOFT ##SSEE Using All System Memory

Problem

In SBS 2003 or SBS 2008 you will experience system hangs, general slowdowns with users logging in and slow authentication times. You may also see a large proportion of system memory consumed by SQL/MSSQL$MICROSOFT##SSEE service running in task manager.

By default this database is set to use whatever memory is available and can cause various problems.

Resolution

Follow this simple guide put a limit on what memory this database can use..

  1. First we need to conect to the database so we can modify it. To do this launch SQL management studio express.

    MSSQL $MICROSOFT ##SSEE Using All System Memory

  2. We need to connect to\\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query3. When connected you will see this screen.

    MSSQL $MICROSOFT ##SSEE Using All System Memory

    4. Right click over the “top level” of the tree and select properties.

    sql using memory

    5. You will now see the properties section. Select memory , you will see its at 2TB, restrict it to whatever memory you want it to use, in my case its 4GB.

    sql using memory

    6.Apply these changes and give the server a reboot.

Tags: MSSQL$MICROSOFT##SSEE, Server 2008, sql

Allen White

Allen is a Consultant for ITPS in the North East of England and holds the following accreditations. MCSA, MCSE, MCTS, MCITP, CCA, CCSP, VCP 4,5 and HP ASE, AIS - Network Infrastructure.

Comments (3)

  • Avatar

    Kieran Donnelly

    |

    Thanks for this, helped me resolve a memory leak on a SBS2008 server. For anyone with security set high on Server 2008 box, don’t forget to right click and run as administrator, even if already logged in as admin.

    Reply

    • Avatar

      admin

      |

      Thanks for the input Kieran 🙂

      Allen.

      Reply

  • Avatar

    Lyle Epstein

    |

    Thanks Allen for this blog post. I had a SBS 2008 server that was eating away the memory. Once I made this change the server is performing better.
    Keep up the excellent blogs.

    Lyle Epstein
    Kortek Solutions – Las Vegas, NV

    Reply

Leave a comment

Categories

Vote!

What Web Browser Do You Use?

View Results

Loading ... Loading ...

Vote!

What do you prefer..VMware or Hyper-V?

View Results

Loading ... Loading ...