{"id":13307,"date":"2019-10-24T11:31:40","date_gmt":"2019-10-24T11:31:40","guid":{"rendered":"https:\/\/dbtut.com\/?p=13307"},"modified":"2019-10-24T11:34:20","modified_gmt":"2019-10-24T11:34:20","slug":"send-email-when-the-blocked-session-count-exceeds-a-certain-number-in-sql-server","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2019\/10\/24\/send-email-when-the-blocked-session-count-exceeds-a-certain-number-in-sql-server\/","title":{"rendered":"Send Email When the Blocked Session Count Exceeds a Certain Number in SQL Server"},"content":{"rendered":"<p>In some cases, sessions are blocked in databases. There are many reasons for blocking. In this article, I will not go into details of this topic.<\/p>\n<p>In this article, I will explain how to send mail when the blocked session count in a database exceeds a certain number. Because if we do not know about this situation, the application will be locked and will not work. So we need to create a warning mechanism to intervene before the application becomes inaccessible.<\/p>\n<p>We have written a script for this process as follows. I want to briefly explain what is happening in this script.<\/p>\n<p>It checks the blocked session count in the instance you are working in every minute. If the blocked session count is greater than the number we have specified, it sends it to the mail address specified in the script by using the Database Mail profile specified in the script. If you did not configure database mail before, you may want to read the article named &#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2018\/07\/07\/how-to-configure-database-mail-on-sql-server\/\" target=\"_blank\" rel=\"bookmark noopener noreferrer\">How To Configure Database Mail On SQL Server<\/a>&#8221;<\/p>\n<h1>Script To Send Email When the Blocked Session Count Exceeds a Certain Number<\/h1>\n<p>You need to change the following parameters for the Script to work properly.<\/p>\n<p>@your_email_address ==&gt; The e-mail address to which you would like to send an email about Lock<\/p>\n<p>@lockcount\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0==&gt; If the blocked session count exceeds this value, an email will be sent to the above email address. (default value is 100)<\/p>\n<pre class=\"lang:default decode:true \">USE [msdb]\nGO\n\nBEGIN TRANSACTION\nDECLARE @ReturnCode INT\nSELECT @ReturnCode = 0\nIF NOT EXISTS (SELECT name FROM msdb.dbo.syscategories WHERE name=N'[Uncategorized (Local)]' AND category_class=1)\nBEGIN\nEXEC @ReturnCode = msdb.dbo.sp_add_category @class=N'JOB', @type=N'LOCAL', @name=N'[Uncategorized (Local)]'\nIF (@@ERROR &lt;&gt; 0 OR @ReturnCode &lt;&gt; 0) GOTO QuitWithRollback\nEND\nDECLARE @jobId BINARY(16)\nEXEC @ReturnCode =\u00a0 msdb.dbo.sp_add_job @job_name=N'lock alert',\n@enabled=1,\n@notify_level_eventlog=0,\n@notify_level_email=0,\n@notify_level_netsend=0,\n@notify_level_page=0,\n@delete_level=0,\n@description=N'No description available.',\n@category_name=N'[Uncategorized (Local)]',\n@owner_login_name=N'sa', @job_id = @jobId OUTPUT\nIF (@@ERROR &lt;&gt; 0 OR @ReturnCode &lt;&gt; 0) GOTO QuitWithRollback\nEXEC @ReturnCode = msdb.dbo.sp_add_jobstep @job_id=@jobId, @step_name=N'lock_script',\n@step_id=1,\n@cmdexec_success_code=0,\n@on_success_action=1,\n@on_success_step_id=0,\n@on_fail_action=2,\n@on_fail_step_id=0,\n@retry_attempts=0,\n@retry_interval=0,\n@os_run_priority=0, @subsystem=N'TSQL',\n@command=N'declare @lockcount int,\n@your_email_address nvarchar(max) =''farukerdemm@outlook.com.tr'',\n@msj nvarchar(max) = (select @@SERVERNAME+'' Blocked session count exceeds the specified value. Check the instance!''),\n@profle nvarchar(max) =(select name from msdb.dbo.sysmail_profile)\nset @lockcount=( select count(t1.resource_type)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\nfrom\nsys.dm_tran_locks t1,\nsys.dm_os_waiting_tasks t2\nwhere\nt1.lock_owner_address = t2.resource_address)\nif @lockcount&gt;100\u00a0 --Blocked Session Count\nbegin\nEXEC msdb.dbo.sp_send_dbmail\n@profile_name =@profle,\u00a0 --Profile Name\n@recipients = @your_email_address,\n@subject = ''Lock Alert'', --Subject Title\n@body=@msj\u00a0 --Mail Content\nend',\n@database_name=N'master',\n@flags=0\nIF (@@ERROR &lt;&gt; 0 OR @ReturnCode &lt;&gt; 0) GOTO QuitWithRollback\nEXEC @ReturnCode = msdb.dbo.sp_update_job @job_id = @jobId, @start_step_id = 1\nIF (@@ERROR &lt;&gt; 0 OR @ReturnCode &lt;&gt; 0) GOTO QuitWithRollback\nEXEC @ReturnCode = msdb.dbo.sp_add_jobserver @job_id = @jobId, @server_name = N'(local)'\nIF (@@ERROR &lt;&gt; 0 OR @ReturnCode &lt;&gt; 0) GOTO QuitWithRollback\nCOMMIT TRANSACTION\nGOTO EndSave\nQuitWithRollback:\n\u00a0\u00a0\u00a0 IF (@@TRANCOUNT &gt; 0) ROLLBACK TRANSACTION\nEndSave:\nGO<\/pre>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_13307\" class=\"pvc_stats all  \" data-element-id=\"13307\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>In some cases, sessions are blocked in databases. There are many reasons for blocking. In this article, I will not go into details of this topic. In this article, I will explain how to send mail when the blocked session count in a database exceeds a certain number. Because if we do not know about &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_13307\" class=\"pvc_stats all  \" data-element-id=\"13307\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"author":366,"featured_media":13308,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[3],"tags":[5008,5009,5007],"class_list":["post-13307","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-mssql","tag-blocked-session-count","tag-blocked-session-count-exceeds","tag-send-email-alert-when-blocked-session-count-exceeds-a-certain-number"],"aioseo_notices":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Send Email When the Blocked Session Count Exceeds a Certain Number in SQL Server - Database Tutorials<\/title>\n<meta name=\"description\" content=\"Send Email When the Blocked Session Count Exceeds a Certain Number in SQL Server\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2019\/10\/24\/send-email-when-the-blocked-session-count-exceeds-a-certain-number-in-sql-server\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Send Email When the Blocked Session Count Exceeds a Certain Number in SQL Server - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"Send Email When the Blocked Session Count Exceeds a Certain Number in SQL Server\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2019\/10\/24\/send-email-when-the-blocked-session-count-exceeds-a-certain-number-in-sql-server\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2019-10-24T11:31:40+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-10-24T11:34:20+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/10\/Ads\u0131z-19.png\" \/>\n\t<meta property=\"og:image:width\" content=\"734\" \/>\n\t<meta property=\"og:image:height\" content=\"449\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Faruk Erdem\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Faruk Erdem\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/10\/24\/send-email-when-the-blocked-session-count-exceeds-a-certain-number-in-sql-server\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/10\/24\/send-email-when-the-blocked-session-count-exceeds-a-certain-number-in-sql-server\/\"},\"author\":{\"name\":\"Faruk Erdem\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/a7dfc5684c116e536b4e93ee214ccbfb\"},\"headline\":\"Send Email When the Blocked Session Count Exceeds a Certain Number in SQL Server\",\"datePublished\":\"2019-10-24T11:31:40+00:00\",\"dateModified\":\"2019-10-24T11:34:20+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/10\/24\/send-email-when-the-blocked-session-count-exceeds-a-certain-number-in-sql-server\/\"},\"wordCount\":256,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/10\/24\/send-email-when-the-blocked-session-count-exceeds-a-certain-number-in-sql-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/10\/Ads\u0131z-19.png\",\"keywords\":[\"Blocked Session Count\",\"Blocked Session Count Exceeds\",\"send email alert when blocked session count Exceeds a Certain Number\"],\"articleSection\":[\"MSSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/10\/24\/send-email-when-the-blocked-session-count-exceeds-a-certain-number-in-sql-server\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/10\/24\/send-email-when-the-blocked-session-count-exceeds-a-certain-number-in-sql-server\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2019\/10\/24\/send-email-when-the-blocked-session-count-exceeds-a-certain-number-in-sql-server\/\",\"name\":\"Send Email When the Blocked Session Count Exceeds a Certain Number in SQL Server - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/10\/24\/send-email-when-the-blocked-session-count-exceeds-a-certain-number-in-sql-server\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/10\/24\/send-email-when-the-blocked-session-count-exceeds-a-certain-number-in-sql-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/10\/Ads\u0131z-19.png\",\"datePublished\":\"2019-10-24T11:31:40+00:00\",\"dateModified\":\"2019-10-24T11:34:20+00:00\",\"description\":\"Send Email When the Blocked Session Count Exceeds a Certain Number in SQL Server\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/10\/24\/send-email-when-the-blocked-session-count-exceeds-a-certain-number-in-sql-server\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/10\/24\/send-email-when-the-blocked-session-count-exceeds-a-certain-number-in-sql-server\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/10\/24\/send-email-when-the-blocked-session-count-exceeds-a-certain-number-in-sql-server\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/10\/Ads\u0131z-19.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/10\/Ads\u0131z-19.png\",\"width\":734,\"height\":449},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/10\/24\/send-email-when-the-blocked-session-count-exceeds-a-certain-number-in-sql-server\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Send Email When the Blocked Session Count Exceeds a Certain Number in SQL Server\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/a7dfc5684c116e536b4e93ee214ccbfb\",\"name\":\"Faruk Erdem\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ad1e61fb5a7c9a590e765f7cad8f2dc8332090f1ceb9a5ee2aa95c69213f0c50?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/ad1e61fb5a7c9a590e765f7cad8f2dc8332090f1ceb9a5ee2aa95c69213f0c50?s=96&d=mm&r=g\",\"caption\":\"Faruk Erdem\"},\"url\":\"https:\/\/dbtut.com\/index.php\/author\/farukerdem\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Send Email When the Blocked Session Count Exceeds a Certain Number in SQL Server - Database Tutorials","description":"Send Email When the Blocked Session Count Exceeds a Certain Number in SQL Server","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:\/\/dbtut.com\/index.php\/2019\/10\/24\/send-email-when-the-blocked-session-count-exceeds-a-certain-number-in-sql-server\/","og_locale":"en_US","og_type":"article","og_title":"Send Email When the Blocked Session Count Exceeds a Certain Number in SQL Server - Database Tutorials","og_description":"Send Email When the Blocked Session Count Exceeds a Certain Number in SQL Server","og_url":"https:\/\/dbtut.com\/index.php\/2019\/10\/24\/send-email-when-the-blocked-session-count-exceeds-a-certain-number-in-sql-server\/","og_site_name":"Database Tutorials","article_published_time":"2019-10-24T11:31:40+00:00","article_modified_time":"2019-10-24T11:34:20+00:00","og_image":[{"width":734,"height":449,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/10\/Ads\u0131z-19.png","type":"image\/png"}],"author":"Faruk Erdem","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Faruk Erdem","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2019\/10\/24\/send-email-when-the-blocked-session-count-exceeds-a-certain-number-in-sql-server\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/10\/24\/send-email-when-the-blocked-session-count-exceeds-a-certain-number-in-sql-server\/"},"author":{"name":"Faruk Erdem","@id":"https:\/\/dbtut.com\/#\/schema\/person\/a7dfc5684c116e536b4e93ee214ccbfb"},"headline":"Send Email When the Blocked Session Count Exceeds a Certain Number in SQL Server","datePublished":"2019-10-24T11:31:40+00:00","dateModified":"2019-10-24T11:34:20+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/10\/24\/send-email-when-the-blocked-session-count-exceeds-a-certain-number-in-sql-server\/"},"wordCount":256,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/10\/24\/send-email-when-the-blocked-session-count-exceeds-a-certain-number-in-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/10\/Ads\u0131z-19.png","keywords":["Blocked Session Count","Blocked Session Count Exceeds","send email alert when blocked session count Exceeds a Certain Number"],"articleSection":["MSSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2019\/10\/24\/send-email-when-the-blocked-session-count-exceeds-a-certain-number-in-sql-server\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2019\/10\/24\/send-email-when-the-blocked-session-count-exceeds-a-certain-number-in-sql-server\/","url":"https:\/\/dbtut.com\/index.php\/2019\/10\/24\/send-email-when-the-blocked-session-count-exceeds-a-certain-number-in-sql-server\/","name":"Send Email When the Blocked Session Count Exceeds a Certain Number in SQL Server - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/10\/24\/send-email-when-the-blocked-session-count-exceeds-a-certain-number-in-sql-server\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/10\/24\/send-email-when-the-blocked-session-count-exceeds-a-certain-number-in-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/10\/Ads\u0131z-19.png","datePublished":"2019-10-24T11:31:40+00:00","dateModified":"2019-10-24T11:34:20+00:00","description":"Send Email When the Blocked Session Count Exceeds a Certain Number in SQL Server","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/10\/24\/send-email-when-the-blocked-session-count-exceeds-a-certain-number-in-sql-server\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2019\/10\/24\/send-email-when-the-blocked-session-count-exceeds-a-certain-number-in-sql-server\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2019\/10\/24\/send-email-when-the-blocked-session-count-exceeds-a-certain-number-in-sql-server\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/10\/Ads\u0131z-19.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/10\/Ads\u0131z-19.png","width":734,"height":449},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2019\/10\/24\/send-email-when-the-blocked-session-count-exceeds-a-certain-number-in-sql-server\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"Send Email When the Blocked Session Count Exceeds a Certain Number in SQL Server"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/a7dfc5684c116e536b4e93ee214ccbfb","name":"Faruk Erdem","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/ad1e61fb5a7c9a590e765f7cad8f2dc8332090f1ceb9a5ee2aa95c69213f0c50?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ad1e61fb5a7c9a590e765f7cad8f2dc8332090f1ceb9a5ee2aa95c69213f0c50?s=96&d=mm&r=g","caption":"Faruk Erdem"},"url":"https:\/\/dbtut.com\/index.php\/author\/farukerdem\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/13307","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/366"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=13307"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/13307\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/13308"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=13307"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=13307"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=13307"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}