{"id":2401,"date":"2023-07-10T13:10:10","date_gmt":"2023-07-10T11:10:10","guid":{"rendered":"https:\/\/leeryanrs.com\/?p=2401"},"modified":"2023-07-10T13:10:10","modified_gmt":"2023-07-10T11:10:10","slug":"find-memory-in-use-by-sql-databases","status":"publish","type":"post","link":"https:\/\/leeryanrs.com\/?p=2401","title":{"rendered":"Find memory in use by sql databases"},"content":{"rendered":"\n<p>Run this query in SSMS to show how much memory the DB&#8217;s are currently using.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>DECLARE @total_buffer INT;\n\nSELECT @total_buffer = cntr_value\nFROM sys.dm_os_performance_counters \nWHERE RTRIM(&#91;object_name]) LIKE '%Buffer Manager'\nAND counter_name = 'Database Pages';\n\n;WITH src AS\n(\nSELECT \ndatabase_id, db_buffer_pages = COUNT_BIG(*)\nFROM sys.dm_os_buffer_descriptors\n--WHERE database_id BETWEEN 5 AND 32766\nGROUP BY database_id\n)\nSELECT\n&#91;db_name] = CASE &#91;database_id] WHEN 32767 \nTHEN 'Resource DB' \nELSE DB_NAME(&#91;database_id]) END,\ndb_buffer_pages,\ndb_buffer_MB = db_buffer_pages \/ 128,\ndb_buffer_percent = CONVERT(DECIMAL(6,3), \ndb_buffer_pages * 100.0 \/ @total_buffer)\nFROM src\nORDER BY db_buffer_MB DESC;<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Run this query in SSMS to show how much memory the DB&#8217;s are currently using.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[46,49,51],"class_list":["post-2401","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-sql","tag-ssms","tag-windows"],"_links":{"self":[{"href":"https:\/\/leeryanrs.com\/index.php?rest_route=\/wp\/v2\/posts\/2401","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/leeryanrs.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/leeryanrs.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/leeryanrs.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/leeryanrs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2401"}],"version-history":[{"count":0,"href":"https:\/\/leeryanrs.com\/index.php?rest_route=\/wp\/v2\/posts\/2401\/revisions"}],"wp:attachment":[{"href":"https:\/\/leeryanrs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2401"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/leeryanrs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2401"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/leeryanrs.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2401"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}