SQL Server Memory

Posted on 2011-05-04
Medium Priority
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
  • 3
  • 2
LVL 32

Assisted Solution

by:Brendt Hess
Brendt Hess earned 2000 total points
ID: 35693550
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

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

Accepted Solution

Brendt Hess earned 2000 total points
ID: 35694933
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

ID: 35695118
SQL Server 2008R2
Enterprise Edition (x64)

How do you increase OS RAM of SQL Server?

Author Closing Comment

ID: 38099096

Featured Post

NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article I will describe the Backup & Restore 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.
This shares a stored procedure to retrieve permissions for a given user on the current database or across all databases on a server.
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
As many of you are aware about Scanpst.exe utility which is owned by Microsoft itself to repair inaccessible or damaged PST files, but the question is do you really think Scanpst.exe is capable to repair all sorts of PST related corruption issues?

807 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