SQL Server Memory

Posted on 2011-05-04
Last Modified: 2012-06-19
Somebody take a look at the following:

My Idera SQLDM report the following errors:
  SQL Server Memory is 93.00%
  OS Memory used is 98.98%
  Disk E is 86.12% full.

How in the world can I get these resolved?
Question by:Favorable
    LVL 32

    Assisted Solution

    Disk E:  This indicates that you are above your monitoring threshold on using disk space on that drive.   If you look at the drive on the server, do you think you have enough room?  If so, increase the threshold for warnings (I increased mine to 95%)

    How to handle the others depends on your server's memory and memory configuration.  You lower the OS % memory used by either removing optional-but-running OS features or allocating more memory to the OS.  You lower the SQL Server % memory used by increasing memory available to SQL Server, or by reducing the usage of memory by, well, by reducing the amount of memory requested by SQL Server to run your queries and code.

    Author Comment

    What are the steps to lower or increasing an OS% memory used?
    LVL 32

    Accepted Solution

    Depends on the server's configuration.  is it x64, x86?  2GB, 4GB, 8GB?  I can't advise specifically, but generically, you increase the OS RAM by decreasing the application RAM usage, e.g. SQL Server in this case.

    Author Comment

    SQL Server 2008R2
    Enterprise Edition (x64)

    How do you increase OS RAM of SQL Server?

    Author Closing Comment


    Featured Post

    What Should I Do With This Threat Intelligence?

    Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

    Join & Write a Comment

    Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
    In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
    This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now