SQL Server Memory

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?
FavorableAsked:
Who is Participating?
 
Brendt HessConnect With a Mentor Senior DBACommented:
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.
0
 
Brendt HessConnect With a Mentor Senior DBACommented:
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.
0
 
FavorableAuthor Commented:
What are the steps to lower or increasing an OS% memory used?
0
 
FavorableAuthor Commented:
SQL Server 2008R2
Enterprise Edition (x64)
4GB

How do you increase OS RAM of SQL Server?
0
 
FavorableAuthor Commented:
thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.