{"id":11994,"date":"2018-11-19T08:56:43","date_gmt":"2018-11-19T07:56:43","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/is-there-too-much-memory-for-my-sql-server-instance\/"},"modified":"2023-07-17T15:14:25","modified_gmt":"2023-07-17T13:14:25","slug":"is-there-too-much-memory-for-my-sql-server-instance","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/is-there-too-much-memory-for-my-sql-server-instance\/","title":{"rendered":"Is there too much memory for my SQL Server instance?"},"content":{"rendered":"<p>Is there too much memory for my SQL Server instance? This is definitely an uncommon question I had to\u00a0deal\u00a0with of my customers a couple of weeks ago. Usually DBAs complain when they don\u2019t have enough memory for environments they have to manage and the fact is SQL Server (like other SGBDRs) provides a plenty of tools for memory pressure troubleshooting. But what about of the opposite? This question raised in a context of an environment that includes a lot of virtual database servers (&gt; 100) on the top of VMWare where my customer was asked for lowering the SQL Server instance memory reservations when possible in order to free memory from ESX hosts.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-29371\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-147-0-banner.jpg\" alt=\"blog 147 - 0 - banner\" width=\"475\" height=\"275\" \/><\/p>\n<p>Let\u2019s start with the sys.dm_os_sys_memory. This is the first one that my customer wanted to dig into. This DMV may be helpful to get a picture of the overall system state including external memory conditions at the operating system level and the physical limits of the underlying hardware.<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">select \n\tavailable_physical_memory_kb \/ 1024 AS available_physical_memory_MB,\n\ttotal_physical_memory_kb \/ 1024 AS total_physical_memory_MB,\n\ttotal_page_file_kb \/ 1024 AS total_page_file_MB,\n\tavailable_page_file_kb \/ 1024 AS available_page_file_MB,\n\tsystem_cache_kb \/ 1024 AS system_cache_MB\nfrom sys.dm_os_sys_memory;<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-29364 size-full\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-147-1-sys.dm_os_memory-e1542615450202.jpg\" alt=\"blog 147 - 1 - sys.dm_os_memory\" width=\"800\" height=\"380\" \/><\/p>\n<p>But in the context of my customer, it partially helped to figure out SQL Server memory consumption instances because we didn\u2019t really face any environments under pressure here.<\/p>\n<p>However, another interesting DMV we may rely on is sys.dm_os_sys_info. We may also use their counterparts with perfmon counters \\Memory Manager\\Target Server Memory (KB) and \\Memory Manager\\Total Server Memory (KB) as shown below:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">select \n\tphysical_memory_kb \/ 1024 AS physical_memory_MB,\n\tvisible_target_KB,\n\tcommitted_kb,\n\tcommitted_target_kb\nfrom sys.dm_os_sys_info;<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-29365\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-147-9-sys.dm_os_sys_info.jpg\" alt=\"blog 147 - 9 - sys.dm_os_sys_info\" width=\"562\" height=\"213\" \/><\/p>\n<p>The concept of committed and Target commit memory are important here to figure out how SQL Server deals with memory space. The commit memory represents the physical memory allocated by the SQL Server process whereas the Target memory is the amount of memory SQL Server tries to maintain as committed memory regarding different factors described in the <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/system-dynamic-management-views\/sys-dm-os-sys-info-transact-sql?view=sql-server-2017\" target=\"_blank\" rel=\"noopener noreferrer\">BOL<\/a>. Chances are the latter is closed to the max server memory value in most of scenarios from my experience by the way.<\/p>\n<p>But relying blindly on the committed memory may contribute to misinterpretation about what SQL Server is really consuming for a specific period of time. Indeed, let\u2019s say my SQL Server instance is capped to 2GB and after the daily business workload here the corresponding figures. Let\u2019s say the values in the context of my customer were of a different order of magnitude but this demo will help to figure out the issue that motivated this write-up:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">select \n\tphysical_memory_kb \/ 1024 AS physical_memory_MB,\n\tvisible_target_KB,\n\tcommitted_kb,\n\tcommitted_target_kb\nfrom sys.dm_os_sys_info;<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-29366\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-147-10-sys.dm_os_sys_info_after_daily_workload.jpg\" alt=\"blog 147 - 10 - sys.dm_os_sys_info_after_daily_workload\" width=\"688\" height=\"57\" \/><\/p>\n<p>The committed memory is about 365MB and by far from the configured max server memory parameter value \u2013 2GB. But now let\u2019s the database maintenance kicks-in. Usually this is a nightly and a daily or weekly basis job that includes generally a rebuilding index task that consists in reading generally all the data structures to get external fragmentation values through the DMF <em>sys.dm_db_index_physical_stats().<\/em> This operation can touch structures that are not used during daily business and may have a huge impact on the buffer pool. In my case here the new memory state after executing this maintenance task:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-29367\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-147-11-sys.dm_os_sys_info_after_maintenance.jpg\" alt=\"blog 147 - 11 - sys.dm_os_sys_info_after_maintenance\" width=\"497\" height=\"55\" \/><\/p>\n<p>The game has changed here because SQL Server has committed all the memory until reaching the max server memory value. This time we may go through the <em>sys.dm_os_memory_clerks<\/em> DMV to get details from different memory clerks of my SQL Server instance. pages_kb column is used because\u00a0SQL instances run with\u00a0SQL 2014 version.<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">SELECT\n\t[type],\n\tpages_kb \/ 1024 AS size_MB\nFROM sys.dm_os_memory_clerks\nWHERE memory_node_id = 0\nORDER BY size_MB DESC<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-29368\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-147-12-sys.dm_os_memory_clerks.jpg\" alt=\"blog 147 - 12 - sys.dm_os_memory_clerks\" width=\"409\" height=\"212\" \/><\/p>\n<p>So, from now the committed memory has good chance to keep closed from the max server memory value while in fact the daily business workload won\u2019t probably need all this memory allocated to the SQL Server process. This exactly why my customer asked me for a way to get a more realistic picture of memory consumption of its SQL Server instances during daily business by excluding the nightly database maintenance workload.<\/p>\n<p>We went through a solution that consisted in freeing up the committed memory before starting the journey and to leave the memory grow up gradually until reaching its maximum usage. It is worth noting that there is no easy way. as far as I know, to free up the committed memory and SQL Server may decrease it only if the corresponding target server memory value is lower. From my experience this situation is more an exception than the rule of thumbs and therefore it is difficult to rely on it. One potential workaround might be to restart the SQL Server instance(s) but in the case of my customer restarting the database servers was not an option and we looked into a solution that forced SQL Server making room by setting up the max server memory closed to the min server memory value. Don\u2019t get me wrong, I don\u2019t consider this as a best practice but more as an emergency procedure because as restarting a SQL Server instance, it may lead to a temporary impact but in a high number of magnitudes especially whether the workload performance is directly tied to the buffer cache state (warm vs cold). In addition, I would say that scaling the max server memory value with only the daily business workload may be controversial in many ways and in fact we have to consider some tradeoffs here. In the context of my customer, the main goal was to release \u201cunused memory\u201d from SQL Server instances during daily business to free up memory from VMWare ESX hosts but there is no free lunch. For instance, the nightly basis workload execution may become suddenly higher in duration if there is less room to work in memory. Another direct side effect of working with less memory might be the increase of I\/O operations from the storage layout. In a nutshell, there is no black or white solution and we have to deal with what we consider at the best solution for the specific\u00a0context.<\/p>\n<p>See you!<\/p>\n<p><span style=\"float: none; background-color: #ffffff; color: #333333; cursor: text; font-family: Georgia,'Times New Roman','Bitstream Charter',Times,serif; font-size: 16px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacing: normal; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none;\">By David Barbarin<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Is there too much memory for my SQL Server instance? This is definitely an uncommon question I had to\u00a0deal\u00a0with of my customers a couple of weeks ago. Usually DBAs complain when they don\u2019t have enough memory for environments they have to manage and the fact is SQL Server (like other SGBDRs) provides a plenty of [&hellip;]<\/p>\n","protected":false},"author":26,"featured_media":11996,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229,99],"tags":[1495,644],"type_dbi":[],"class_list":["post-11994","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-administration-monitoring","category-sql-server","tag-memory-consumption","tag-performance-tuning"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.5) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Is there too much memory for my SQL Server instance?<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/is-there-too-much-memory-for-my-sql-server-instance\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Is there too much memory for my SQL Server instance?\" \/>\n<meta property=\"og:description\" content=\"Is there too much memory for my SQL Server instance? This is definitely an uncommon question I had to\u00a0deal\u00a0with of my customers a couple of weeks ago. Usually DBAs complain when they don\u2019t have enough memory for environments they have to manage and the fact is SQL Server (like other SGBDRs) provides a plenty of [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/is-there-too-much-memory-for-my-sql-server-instance\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2018-11-19T07:56:43+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-07-17T13:14:25+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-147-1-sys.dm_os_memory-e1542615450202.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"800\" \/>\n\t<meta property=\"og:image:height\" content=\"380\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Microsoft Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Microsoft Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/is-there-too-much-memory-for-my-sql-server-instance\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/is-there-too-much-memory-for-my-sql-server-instance\\\/\"},\"author\":{\"name\":\"Microsoft Team\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/bfab48333280d616e1170e7369df90a4\"},\"headline\":\"Is there too much memory for my SQL Server instance?\",\"datePublished\":\"2018-11-19T07:56:43+00:00\",\"dateModified\":\"2023-07-17T13:14:25+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/is-there-too-much-memory-for-my-sql-server-instance\\\/\"},\"wordCount\":980,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/is-there-too-much-memory-for-my-sql-server-instance\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/blog-147-1-sys.dm_os_memory-e1542615450202.jpg\",\"keywords\":[\"memory consumption\",\"Performance Tuning\"],\"articleSection\":[\"Database Administration &amp; Monitoring\",\"SQL Server\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/is-there-too-much-memory-for-my-sql-server-instance\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/is-there-too-much-memory-for-my-sql-server-instance\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/is-there-too-much-memory-for-my-sql-server-instance\\\/\",\"name\":\"Is there too much memory for my SQL Server instance?\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/is-there-too-much-memory-for-my-sql-server-instance\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/is-there-too-much-memory-for-my-sql-server-instance\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/blog-147-1-sys.dm_os_memory-e1542615450202.jpg\",\"datePublished\":\"2018-11-19T07:56:43+00:00\",\"dateModified\":\"2023-07-17T13:14:25+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/bfab48333280d616e1170e7369df90a4\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/is-there-too-much-memory-for-my-sql-server-instance\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/is-there-too-much-memory-for-my-sql-server-instance\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/is-there-too-much-memory-for-my-sql-server-instance\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/blog-147-1-sys.dm_os_memory-e1542615450202.jpg\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/blog-147-1-sys.dm_os_memory-e1542615450202.jpg\",\"width\":800,\"height\":380},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/is-there-too-much-memory-for-my-sql-server-instance\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Is there too much memory for my SQL Server instance?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/bfab48333280d616e1170e7369df90a4\",\"name\":\"Microsoft Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/c44a1a792c059f24055763aa77d80a244467f6eef724a8bd13db8d4a350b7a4c?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/c44a1a792c059f24055763aa77d80a244467f6eef724a8bd13db8d4a350b7a4c?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/c44a1a792c059f24055763aa77d80a244467f6eef724a8bd13db8d4a350b7a4c?s=96&d=mm&r=g\",\"caption\":\"Microsoft Team\"},\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/author\\\/microsoft-team\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Is there too much memory for my SQL Server instance?","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/is-there-too-much-memory-for-my-sql-server-instance\/","og_locale":"en_US","og_type":"article","og_title":"Is there too much memory for my SQL Server instance?","og_description":"Is there too much memory for my SQL Server instance? This is definitely an uncommon question I had to\u00a0deal\u00a0with of my customers a couple of weeks ago. Usually DBAs complain when they don\u2019t have enough memory for environments they have to manage and the fact is SQL Server (like other SGBDRs) provides a plenty of [&hellip;]","og_url":"https:\/\/www.dbi-services.com\/blog\/is-there-too-much-memory-for-my-sql-server-instance\/","og_site_name":"dbi Blog","article_published_time":"2018-11-19T07:56:43+00:00","article_modified_time":"2023-07-17T13:14:25+00:00","og_image":[{"width":800,"height":380,"url":"http:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-147-1-sys.dm_os_memory-e1542615450202.jpg","type":"image\/jpeg"}],"author":"Microsoft Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Microsoft Team","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/is-there-too-much-memory-for-my-sql-server-instance\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/is-there-too-much-memory-for-my-sql-server-instance\/"},"author":{"name":"Microsoft Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/bfab48333280d616e1170e7369df90a4"},"headline":"Is there too much memory for my SQL Server instance?","datePublished":"2018-11-19T07:56:43+00:00","dateModified":"2023-07-17T13:14:25+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/is-there-too-much-memory-for-my-sql-server-instance\/"},"wordCount":980,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/is-there-too-much-memory-for-my-sql-server-instance\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-147-1-sys.dm_os_memory-e1542615450202.jpg","keywords":["memory consumption","Performance Tuning"],"articleSection":["Database Administration &amp; Monitoring","SQL Server"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/is-there-too-much-memory-for-my-sql-server-instance\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/is-there-too-much-memory-for-my-sql-server-instance\/","url":"https:\/\/www.dbi-services.com\/blog\/is-there-too-much-memory-for-my-sql-server-instance\/","name":"Is there too much memory for my SQL Server instance?","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/is-there-too-much-memory-for-my-sql-server-instance\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/is-there-too-much-memory-for-my-sql-server-instance\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-147-1-sys.dm_os_memory-e1542615450202.jpg","datePublished":"2018-11-19T07:56:43+00:00","dateModified":"2023-07-17T13:14:25+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/bfab48333280d616e1170e7369df90a4"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/is-there-too-much-memory-for-my-sql-server-instance\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/is-there-too-much-memory-for-my-sql-server-instance\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/is-there-too-much-memory-for-my-sql-server-instance\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-147-1-sys.dm_os_memory-e1542615450202.jpg","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-147-1-sys.dm_os_memory-e1542615450202.jpg","width":800,"height":380},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/is-there-too-much-memory-for-my-sql-server-instance\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Is there too much memory for my SQL Server instance?"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/bfab48333280d616e1170e7369df90a4","name":"Microsoft Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/c44a1a792c059f24055763aa77d80a244467f6eef724a8bd13db8d4a350b7a4c?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/c44a1a792c059f24055763aa77d80a244467f6eef724a8bd13db8d4a350b7a4c?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c44a1a792c059f24055763aa77d80a244467f6eef724a8bd13db8d4a350b7a4c?s=96&d=mm&r=g","caption":"Microsoft Team"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/microsoft-team\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/11994","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/26"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=11994"}],"version-history":[{"count":1,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/11994\/revisions"}],"predecessor-version":[{"id":26751,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/11994\/revisions\/26751"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/11996"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=11994"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=11994"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=11994"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=11994"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}