Results 1 to 4 of 4

Thread: how to reduce the memory useage of the sqlserver.exe process

  1. #1
    Join Date
    Sep 2005
    Posts
    21

    how to reduce the memory useage of the sqlserver.exe process

    We are having a SBS 2003 with about 30 users. I just wanted to know how can I reduce the memory usage of the sqlserver.exe process?

    Please let me know as soon as possible. Thank you.

  2. #2
    Join Date
    Jan 2006
    Posts
    278

    Re: how to reduce the memory useage of the sqlserver.exe process

    You need a tool called as Microsoft SQL Server Management Studio Express, aka SSMSE. It is a free easy-to-use graphical management tool for managing SQL Server. You can download it from here http://www.microsoft.com/downloads/d...displaylang=en

  3. #3
    Join Date
    Sep 2004
    Posts
    133

    Re: how to reduce the memory useage of the sqlserver.exe process

    To determine which processes and applications are using the most memory, use Task Manager. Monitor the activity of these resources over a few days. If they continue to use a high level of memory and are less critical processes or services, try stopping and then restarting them. You can disable this alert or change its threshold by using the Change Alert Notifications task in the Server Management Monitoring and Reporting taskpad.

  4. #4
    Join Date
    Jun 2006
    Posts
    206

    RE: how to reduce the memory useage of the sqlserver.exe process

    Open Performance in Administrative Tools.Add the followoing counters:

    Performance object: MSSQL$MSFW-Memory Manager
    Counter: Total Server Memory (KB)
    Performance object: MSSQL$MONITORING-Memory Manager
    Counter: Total Server Memory (KB)
    Performance object: MSSQL$SHAREPOINT-Memory Manager
    Counter: Total Server Memory (KB)

    This will allow you to analyze which instance uses high memory.

Similar Threads

  1. how to reduce runtime memory in windows 8 operating system.
    By Garsen's in forum Operating Systems
    Replies: 5
    Last Post: 18-10-2011, 11:07 PM
  2. Avgcsrvx.exe process using so much of CPU and memory
    By Daksha90 in forum Networking & Security
    Replies: 6
    Last Post: 10-08-2011, 09:32 AM
  3. Replies: 4
    Last Post: 25-12-2010, 08:33 AM
  4. How to reduce Linux memory overhead
    By Galbraith in forum Operating Systems
    Replies: 5
    Last Post: 27-03-2010, 12:51 AM
  5. Reduce Firefox Memory Usage
    By Computer_Freak in forum Tips & Tweaks
    Replies: 3
    Last Post: 16-03-2009, 03:35 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,711,628,132.84464 seconds with 16 queries