{"id":14479,"date":"2020-08-13T18:09:21","date_gmt":"2020-08-13T16:09:21","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/sql-server-high-sqlconnectionpool-memory-clerk-consumption\/"},"modified":"2025-10-01T11:46:57","modified_gmt":"2025-10-01T09:46:57","slug":"sql-server-high-sqlconnectionpool-memory-clerk-consumption","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/sql-server-high-sqlconnectionpool-memory-clerk-consumption\/","title":{"rendered":"SQL Server: High SQLCONNECTIONPOOL Memory Clerk consumption"},"content":{"rendered":"

In this blog post, I will show you what I did to troubleshoot an interesting problem with Memory on SQL Server.<\/p>\n

It all started with a job performing DBCC CHECKDB on all databases taking hours to complete instead of 10 minutes.
\nSo the Job ran outside of its maintenance window, still running in the morning when users come back to the office. They immediately complained about poor application performance.<\/p>\n

While running the CHECKDB we could see many sessions in a SUSPENDED state with SELECT queries waiting on “RESOURCE_SEMAPHORE”.<\/p>\n

\"\"<\/a>The instance seemed to be starving on Memory.
\nWe tried to increase the “Max Server Memory” by 2GB. This solved the issue.\u00a0 Temporarily.
\nAround a week later the same issue occurred again with users complaining of very bad performance. The CHECKDB Job was running again for hours.<\/p>\n

I did more analysis of the memory usage for this instance. Identifying the biggest memory consumers is key to proceeding with investigation.
\nThe amount of memory allocated to each memory clerk can be found using the sys.dm_os_memory_clerks<\/a> DMV.
\nWe can notice a very high value for the Memory clerk “SQLCONNECTIONPOOL”.\"\"<\/a><\/p>\n

The “Max Server Memory” value of this instance is configured to 14GB. So half of it is allocated to the SQLCONNECTIONPOOL Memory Clerk. This is obviously not a normal situation.<\/p>\n

We decided to perform a Failover of the Availability Group to clear all the memory on the instance to perform the CHECKDB.
\nFrom there I created a Job monitoring the Memory Clerk usage. The query is from one of Glenn Berry’s diagnostic queries<\/a>.
\nHere is the SQL.<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n
16<\/div>\n
17<\/div>\n<\/td>\n
\n
\n
-- The monitoring Table<\/code><\/div>\n
use dbi_tools<\/code><\/div>\n
go<\/code><\/div>\n
create<\/code> table<\/code> monitoring.memoryClerkType (<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>mct_id <\/code>int<\/code> identity <\/code>not<\/code> null<\/code> primary<\/code> key<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>, mct_logdate datetime2 <\/code>default<\/code> getdate()<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>, mct_MemoryClerkType nvarchar(256) <\/code>not<\/code> null<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>, mct_memoryUsageMB <\/code>DECIMAL<\/code>(15,2)<\/code><\/div>\n
);<\/code><\/div>\n
<\/div>\n
-- The query inside an SQL Server Agent Job<\/code><\/div>\n
insert<\/code> into<\/code> dbi_tools.monitoring.memoryClerkType(mct_MemoryClerkType, mct_memoryUsageMB)<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>SELECT<\/code> TOP<\/code>(10) mc.[type] <\/code>AS<\/code> [Memory Clerk Type], <\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>CAST<\/code>((<\/code>SUM<\/code>(mc.pages_kb)\/1024.0) <\/code>AS<\/code> DECIMAL<\/code> (15,2)) <\/code>AS<\/code> [Memory Usage (MB)] <\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>FROM<\/code> sys.dm_os_memory_clerks <\/code>AS<\/code> mc <\/code>WITH<\/code> (NOLOCK)<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>GROUP<\/code> BY<\/code> mc.[type]\u00a0 <\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>ORDER<\/code> BY<\/code> SUM<\/code>(mc.pages_kb) <\/code>DESC<\/code> OPTION<\/code> (RECOMPILE);<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

This allowed me to confirm that the Memory allocated to SQLCONNECTIONPOOL is increasing over time.
\n\"\"<\/a><\/p>\n

This causes internal Memory pressure on the instance. As more and more memory is allocated to this Memory Clerk the memory available for the Buffer Pool slowly decreases. Any event that requires a lot of memory like a DBCC CHECKDB would flush memory from the Buffer Pool but the memory allocated to SQLCONNECTIONPOOL is be flushed. This is a real issue.<\/p>\n

\"\"<\/a><\/p>\n

This issue is described in an SQL Server CAT article: Watch out those prepared SQL statements<\/a><\/p>\n

Basically, some application server is calling sp_prepare<\/a> system procedure through an ODBC driver and do not call sp_unprepare<\/a>.
\nThis seems to be a bug in the ODBC driver. There’s not much to do on the MSSQL server.<\/p>\n

My instance has dozens of databases for different applications. I need to identify which database, and so which application server needs an ODBC driver update.
\nTo do so I created an Extended Event session. There are events for sp_prepare and sp_unprepare in the “execution” category.
\n\"\"<\/a><\/p>\n

Here is the T-SQL for this XE session:<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n<\/td>\n
\n
\n
CREATE<\/code> EVENT SESSION [dbi_sna_memory] <\/code>ON<\/code> SERVER <\/code><\/div>\n
ADD<\/code> EVENT sqlserver.prepare_sql(<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>ACTION<\/code>(sqlserver.client_app_name,sqlserver.client_hostname<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>,sqlserver.database_name,sqlserver.session_id,sqlserver.username)),<\/code><\/div>\n
ADD<\/code> EVENT sqlserver.unprepare_sql(<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>ACTION<\/code>(sqlserver.client_app_name,sqlserver.client_hostname<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>,sqlserver.database_name,sqlserver.session_id,sqlserver.username))<\/code><\/div>\n
ADD<\/code> TARGET package0.event_file(<\/code>SET<\/code> filename=N<\/code>'dbi_sna_memory'<\/code>,max_file_size=(500))<\/code><\/div>\n
WITH<\/code> (STARTUP_STATE=<\/code>ON<\/code>)<\/code><\/div>\n
GO<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

Looking at the live data I could see a lot of sp_prepare without any sp_unprepare for one of the databases.<\/p>\n

\"\"<\/a><\/p>\n

Sessions to the database in blue color doesn’t seem to call the sp_unprepare system procedure.
\nLooking at the Extended Event data with SQL I get a better view of the situation.<\/p>\n

\"\"<\/a><\/p>\n

Based on a sample of approximately 1 Million events, it’s obvious that the first database is the one doing the most sp_prepare events. There are only 1% of sp_unprepare calls which is clearly abnormal compared to the other databases with an expected value of 99%-100%.
\nJust for information here is the query I did to get the result above:<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n<\/td>\n
\n
\n
select<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>SUM<\/code>(IIF(eventName=<\/code>'prepare_sql'<\/code>, 1, 0)) <\/code>AS<\/code> Prepare<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>, <\/code>SUM<\/code>(IIF(eventName=<\/code>'unprepare_sql'<\/code>, 1, 0)) <\/code>AS<\/code> Unpepare<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>, ROUND(<\/code>CAST<\/code>(<\/code>SUM<\/code>(IIF(eventName=<\/code>'unprepare_sql'<\/code>, 1, 0)) <\/code>AS<\/code> FLOAT<\/code>)\/<\/code>SUM<\/code>(IIF(eventName=<\/code>'prepare_sql'<\/code>, 1, 0))*100, 2) <\/code>AS<\/code> unPreparePct<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>, dbName<\/code><\/div>\n
from<\/code> dbi_tools.dbo.xe_Memory_data <\/code>-- Table with data from the XE session file<\/code><\/div>\n
group<\/code> by<\/code> dbName<\/code><\/div>\n
order<\/code> by<\/code> 1 <\/code>desc<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

The culprit is now identified. We can update the client layer on the application server and look for improvement in memory usage.<\/p>\n

Written by Steven Naudet<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

In this blog post, I will show you what I did to troubleshoot an interesting problem with Memory on SQL Server. It all started with a job performing DBCC CHECKDB on all databases taking hours to complete instead of 10 minutes. So the Job ran outside of its maintenance window, still running in the morning […]<\/p>\n","protected":false},"author":26,"featured_media":14480,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229,99],"tags":[1495,2550,2059],"type_dbi":[],"class_list":["post-14479","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-administration-monitoring","category-sql-server","tag-memory-consumption","tag-sql-server-2","tag-sqlconnectionpool"],"acf":[],"yoast_head":"\nSQL Server: High SQLCONNECTIONPOOL Memory Clerk consumption - dbi Blog<\/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\/sql-server-high-sqlconnectionpool-memory-clerk-consumption\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server: High SQLCONNECTIONPOOL Memory Clerk consumption\" \/>\n<meta property=\"og:description\" content=\"In this blog post, I will show you what I did to troubleshoot an interesting problem with Memory on SQL Server. It all started with a job performing DBCC CHECKDB on all databases taking hours to complete instead of 10 minutes. So the Job ran outside of its maintenance window, still running in the morning […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/sql-server-high-sqlconnectionpool-memory-clerk-consumption\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2020-08-13T16:09:21+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-10-01T09:46:57+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/ressource_semaphore.png\" \/>\n\t<meta property=\"og:image:width\" content=\"517\" \/>\n\t<meta property=\"og:image:height\" content=\"254\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\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=\"5 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\/sql-server-high-sqlconnectionpool-memory-clerk-consumption\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-high-sqlconnectionpool-memory-clerk-consumption\/\"},\"author\":{\"name\":\"Microsoft Team\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/bfab48333280d616e1170e7369df90a4\"},\"headline\":\"SQL Server: High SQLCONNECTIONPOOL Memory Clerk consumption\",\"datePublished\":\"2020-08-13T16:09:21+00:00\",\"dateModified\":\"2025-10-01T09:46:57+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-high-sqlconnectionpool-memory-clerk-consumption\/\"},\"wordCount\":602,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-high-sqlconnectionpool-memory-clerk-consumption\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/ressource_semaphore.png\",\"keywords\":[\"memory consumption\",\"SQL Server\",\"SQLCONNECTIONPOOL\"],\"articleSection\":[\"Database Administration & Monitoring\",\"SQL Server\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/sql-server-high-sqlconnectionpool-memory-clerk-consumption\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-high-sqlconnectionpool-memory-clerk-consumption\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-high-sqlconnectionpool-memory-clerk-consumption\/\",\"name\":\"SQL Server: High SQLCONNECTIONPOOL Memory Clerk consumption - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-high-sqlconnectionpool-memory-clerk-consumption\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-high-sqlconnectionpool-memory-clerk-consumption\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/ressource_semaphore.png\",\"datePublished\":\"2020-08-13T16:09:21+00:00\",\"dateModified\":\"2025-10-01T09:46:57+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/bfab48333280d616e1170e7369df90a4\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-high-sqlconnectionpool-memory-clerk-consumption\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/sql-server-high-sqlconnectionpool-memory-clerk-consumption\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-high-sqlconnectionpool-memory-clerk-consumption\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/ressource_semaphore.png\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/ressource_semaphore.png\",\"width\":517,\"height\":254},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-high-sqlconnectionpool-memory-clerk-consumption\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server: High SQLCONNECTIONPOOL Memory Clerk consumption\"}]},{\"@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":"SQL Server: High SQLCONNECTIONPOOL Memory Clerk consumption - dbi Blog","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\/sql-server-high-sqlconnectionpool-memory-clerk-consumption\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server: High SQLCONNECTIONPOOL Memory Clerk consumption","og_description":"In this blog post, I will show you what I did to troubleshoot an interesting problem with Memory on SQL Server. It all started with a job performing DBCC CHECKDB on all databases taking hours to complete instead of 10 minutes. So the Job ran outside of its maintenance window, still running in the morning […]","og_url":"https:\/\/www.dbi-services.com\/blog\/sql-server-high-sqlconnectionpool-memory-clerk-consumption\/","og_site_name":"dbi Blog","article_published_time":"2020-08-13T16:09:21+00:00","article_modified_time":"2025-10-01T09:46:57+00:00","og_image":[{"width":517,"height":254,"url":"http:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/ressource_semaphore.png","type":"image\/png"}],"author":"Microsoft Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Microsoft Team","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-high-sqlconnectionpool-memory-clerk-consumption\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-high-sqlconnectionpool-memory-clerk-consumption\/"},"author":{"name":"Microsoft Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/bfab48333280d616e1170e7369df90a4"},"headline":"SQL Server: High SQLCONNECTIONPOOL Memory Clerk consumption","datePublished":"2020-08-13T16:09:21+00:00","dateModified":"2025-10-01T09:46:57+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-high-sqlconnectionpool-memory-clerk-consumption\/"},"wordCount":602,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-high-sqlconnectionpool-memory-clerk-consumption\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/ressource_semaphore.png","keywords":["memory consumption","SQL Server","SQLCONNECTIONPOOL"],"articleSection":["Database Administration & Monitoring","SQL Server"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-high-sqlconnectionpool-memory-clerk-consumption\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-high-sqlconnectionpool-memory-clerk-consumption\/","url":"https:\/\/www.dbi-services.com\/blog\/sql-server-high-sqlconnectionpool-memory-clerk-consumption\/","name":"SQL Server: High SQLCONNECTIONPOOL Memory Clerk consumption - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-high-sqlconnectionpool-memory-clerk-consumption\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-high-sqlconnectionpool-memory-clerk-consumption\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/ressource_semaphore.png","datePublished":"2020-08-13T16:09:21+00:00","dateModified":"2025-10-01T09:46:57+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/bfab48333280d616e1170e7369df90a4"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-high-sqlconnectionpool-memory-clerk-consumption\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-high-sqlconnectionpool-memory-clerk-consumption\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-high-sqlconnectionpool-memory-clerk-consumption\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/ressource_semaphore.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/ressource_semaphore.png","width":517,"height":254},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-high-sqlconnectionpool-memory-clerk-consumption\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL Server: High SQLCONNECTIONPOOL Memory Clerk consumption"}]},{"@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\/14479","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=14479"}],"version-history":[{"count":2,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/14479\/revisions"}],"predecessor-version":[{"id":40593,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/14479\/revisions\/40593"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/14480"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=14479"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=14479"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=14479"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=14479"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}