How to check SQL database actual Memory usage

• santosh.mane

  SSChasing Mays

  Points: 611

  More actions

  November 29, 2018 at 10:21 pm

  #380951

  Hi,

  We are facing performance issue on one of the DB server.
  I had increased the memory from 32 GB to 64 GB but still the database is very slow.
  Once the memory is used cannot find how much memory currently utilized by SQL server.

  Is there any query to check actual Memory used by database?

  Please can you share the script/link to check actual Memory used by database.

  Also please check DB Healthcheck queries.

  Thanks & Regards,
  Santosh 

• muthukkumaran Kaliyamoorthy

  SSCoach

  Points: 19026

  More actions

  November 30, 2018 at 5:02 am

  #2015088

  santosh.mane - Thursday, November 29, 2018 10:21 PM

  Hi,

  We are facing performance issue on one of the DB server.
  I had increased the memory from 32 GB to 64 GB but still the database is very slow.
  Once the memory is used cannot find how much memory currently utilized by SQL server.

  Is there any query to check actual Memory used by database?

  Please can you share the script/link to check actual Memory used by database.

  Also please check DB Healthcheck queries.

  Thanks & Regards,
  Santosh 

  https://docs.microsoft.com/en-us/sql/relational-databases/in-memory-oltp/monitor-and-troubleshoot-memory-usage?view=sql-server-2017
  https://www.mssqltips.com/sqlservertip/2393/determine-sql-server-memory-use-by-database-and-object/

  Increase memory will not solve the performance problem, the high amount of memory will be good to cache the data.
  Try find what is being running.

  Muthukkumaran Kaliyamoorthy
  https://www.sqlserverblogforum.com/

• Sue_H

  SSC Guru

  Points: 90860

  More actions

  November 30, 2018 at 11:47 am

  #2015163

  santosh.mane - Thursday, November 29, 2018 10:21 PM

  Hi,

  We are facing performance issue on one of the DB server.
  I had increased the memory from 32 GB to 64 GB but still the database is very slow.
  Once the memory is used cannot find how much memory currently utilized by SQL server.

  Is there any query to check actual Memory used by database?

  Please can you share the script/link to check actual Memory used by database.

  Also please check DB Healthcheck queries.

  Thanks & Regards,
  Santosh 

  For health check queries, Glenn Berry has a set of diagnostic queries which would be a great start. You can find links to the queries based on your SQL version at this site:
  SQL Server Diagnostic Information Queries for November 2018

  Sue