{"id":11995,"date":"2019-05-03T14:51:18","date_gmt":"2019-05-03T14:51:18","guid":{"rendered":"https:\/\/dbtut.com\/?p=11995"},"modified":"2019-05-03T14:51:19","modified_gmt":"2019-05-03T14:51:19","slug":"send-email-to-dbas-when-transaction-log-sizes-reachs-the-certain-limit","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2019\/05\/03\/send-email-to-dbas-when-transaction-log-sizes-reachs-the-certain-limit\/","title":{"rendered":"Send Email To DBAs When Transaction Log Sizes Reachs the Certain Limit"},"content":{"rendered":"<p>Sometimes the transaction log file may grow more than normal for some reasons. For example when the transaction logs are not backed up. In the following articles you can find articles about why the log file can be full or grows more than normal.<\/p>\n<p>&#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2018\/05\/25\/sql-server-does-not-truncate-the-transaction-log-after-log-backup-and-can-not-shrink-the-transaction-log\/\" target=\"_blank\" rel=\"noopener noreferrer\">SQL Server Does Not Truncate the Transaction Log After Log Backup and Can Not Shrink the Transaction Log<\/a>&#8220;,<\/p>\n<p>&#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2019\/03\/26\/transaction-log-for-database-is-full-due-to-a-reason-active-transaction-log-backup-replication\/\" target=\"_blank\" rel=\"noopener noreferrer\">Transaction Log is Full Due To a Reason(ACTIVE_TRANSACTION, LOG_BACKUP, REPLICATION)<\/a>&#8221;<\/p>\n<p>If you know in advance that the log file is full and there is a problem, you can create a solution before it is too late. So we prepared the following script for our environment and wanted to share it with you.<\/p>\n<p>Below you can find the script that send email transaction log file informations which log files are over 500 GB(You can change this value in the script if you want) in size and are too full to shrink.<\/p>\n<p>You must configure database mail so that your SQL Server can send mail. The article &#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2018\/07\/07\/how-to-configure-database-mail-on-sql-server\/\" target=\"_blank\" rel=\"noopener noreferrer\">How To Configure Database Mail On SQL Server<\/a>&#8221; can help you.<\/p>\n<pre class=\"lang:default decode:true \">DECLARE @DatabaseName VARCHAR(250)\nDECLARE @LogSize2 DECIMAL(19,2)\nDECLARE @UsedLogSize2 DECIMAL(19,2)\nDECLARE @HTML&nbsp; NVARCHAR(MAX) \nDECLARE @Sql NVARCHAR(MAX) \nDECLARE @Counter tinyint\nSET @HTML =\n    N'&lt;H1&gt;Transaction Log Files That Should Be Checked&lt;\/H1&gt;' +  \n    N'&lt;table border=\"1\"&gt;' +  \n    N'&lt;tr&gt;&lt;td&gt;Database Name&lt;\/td&gt;&lt;td&gt;Log Size&lt;\/td&gt;&lt;td&gt;Used Log Size&lt;\/td&gt;&lt;\/tr&gt;' ;\n\tSET @Counter=0\nDECLARE LogAlertCrs CURSOR\n\nFOR\nSELECT '['+name+']' FROM sys.sysdatabases where dbid&gt;4 and name not in(\nSELECT  DB_NAME(dr_state.database_id) as name\nFROM (( sys.availability_groups AS ag JOIN sys.availability_replicas AS ar ON ag.group_id = ar.group_id )\nJOIN sys.dm_hadr_availability_replica_states AS ar_state ON ar.replica_id = ar_state.replica_id)\nJOIN sys.dm_hadr_database_replica_states dr_state on ag.group_id = dr_state.group_id\nand dr_state.replica_id = ar_state.replica_id\nwhere ar_state.role_desc='SECONDARY' AND ar_state.is_local=1\n)\n\nOPEN LogAlertCrs\nFETCH NEXT FROM LogAlertCrs INTO @DatabaseName\nWHILE @@FETCH_STATUS =0\nBEGIN&nbsp;\n\nSelect @Sql = 'Use ' +@DatabaseName + N';\n\n\n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SELECT \n@LogSize=CAST(sum(size)\/131072.0 AS decimal(19,2)) ,\n@UsedLogSize=CAST(sum(CAST(FILEPROPERTY(name, ''SpaceUsed'') AS INT))\/131072.0 AS DECIMAL(19,2)) from sys.database_files  \nwhere type=1 group by type'\n\nEXEC sp_executesql @Sql,@Params= N'@LogSize DECIMAL(19,2) OUTPUT, @UsedLogSize DECIMAL(19,2) OUTPUT'\n,@LogSize = @LogSize2 OUTPUT\n,@UsedLogSize = @UsedLogSize2 OUTPUT;  \n\n \n\nIF(@LogSize2&gt;=500 AND @LogSize2-@UsedLogSize2&lt;1)\nBEGIN\n\nSET @Counter+=1;\n\tSET @HTML+=N'&lt;tr&gt;&lt;td&gt;'+@DatabaseName+'&lt;\/td&gt;&lt;td&gt;'+CAST(@LogSize2 AS nvarchar(50))+\n\t'&lt;\/td&gt;&lt;td&gt;'+CAST(@UsedLogSize2 AS nvarchar(50))+'&lt;\/td&gt;&lt;\/tr&gt;';\n\t--print @html;\n\nEND\n\n&nbsp;FETCH NEXT FROM LogAlertCrs INTO @DatabaseName\n  \nEND&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\nSET @HTML+=N'&lt;\/table&gt;' ;&nbsp;&nbsp;\nif(@Counter&gt;0)\nBEGIN&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\nEXEC msdb.dbo.sp_send_dbmail\n@recipients='nurullah.cakir@saglik.gov.tr',\n@subject = 'Check Transaction Log File Sizes',\n@body = @HTML,\n@body_format = 'HTML' ;\nEND\nCLOSE LogAlertCrs\nDEALLOCATE LogAlertCrs<\/pre>\n\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_11995\" class=\"pvc_stats all  \" data-element-id=\"11995\" 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>Sometimes the transaction log file may grow more than normal for some reasons. For example when the transaction logs are not backed up. In the following articles you can find articles about why the log file can be full or grows more than normal. &#8220;SQL Server Does Not Truncate the Transaction Log After Log Backup &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_11995\" class=\"pvc_stats all  \" data-element-id=\"11995\" 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":1,"featured_media":11998,"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":[3795,3792,2813,3794,3791,3796,3798,3797,3793],"class_list":["post-11995","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-mssql","tag-estimating-transaction-log-size","tag-finding-log-size-for-all-databases-in-sql-server","tag-how-do-i-find-the-transaction-log-size-in-sql-server","tag-how-to-check-transaction-log-size-in-sql-server","tag-how-to-determine-sql-server-database-transaction-log-usage","tag-monitoring-transaction-log-size","tag-send-email-to-dbas-when-transaction-log-size-reachs-the-certain-limit","tag-send-email-transaction-log-size","tag-sql-server-transaction-log-size"],"aioseo_notices":[],"a3_pvc":{"activated":true,"total_views":124,"today_views":0},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Send Email To DBAs When Transaction Log Sizes Reachs the Certain Limit - Database Tutorials<\/title>\n<meta name=\"description\" content=\"Send Email To DBAs When Transaction Log Sizes Reachs the Certain Limit\" \/>\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\/05\/03\/send-email-to-dbas-when-transaction-log-sizes-reachs-the-certain-limit\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Send Email To DBAs When Transaction Log Sizes Reachs the Certain Limit - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"Send Email To DBAs When Transaction Log Sizes Reachs the Certain Limit\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2019\/05\/03\/send-email-to-dbas-when-transaction-log-sizes-reachs-the-certain-limit\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2019-05-03T14:51:18+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-05-03T14:51:19+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/05\/Ads\u0131z-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"537\" \/>\n\t<meta property=\"og:image:height\" content=\"317\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"dbtut\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"dbtut\" \/>\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\/05\/03\/send-email-to-dbas-when-transaction-log-sizes-reachs-the-certain-limit\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/05\/03\/send-email-to-dbas-when-transaction-log-sizes-reachs-the-certain-limit\/\"},\"author\":{\"name\":\"dbtut\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\"},\"headline\":\"Send Email To DBAs When Transaction Log Sizes Reachs the Certain Limit\",\"datePublished\":\"2019-05-03T14:51:18+00:00\",\"dateModified\":\"2019-05-03T14:51:19+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/05\/03\/send-email-to-dbas-when-transaction-log-sizes-reachs-the-certain-limit\/\"},\"wordCount\":196,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/05\/03\/send-email-to-dbas-when-transaction-log-sizes-reachs-the-certain-limit\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/05\/Ads\u0131z-1.png\",\"keywords\":[\"Estimating transaction log size\",\"Finding Log Size for all Databases in SQL Server\",\"How do I find the transaction log size in SQL Server?\",\"how to check transaction log size in sql server\",\"How to determine SQL Server database transaction log usage\",\"monitoring transaction log size\",\"send email to dbas when transaction log size reachs the certain limit\",\"send email transaction log size\",\"sql server transaction log size\"],\"articleSection\":[\"MSSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/05\/03\/send-email-to-dbas-when-transaction-log-sizes-reachs-the-certain-limit\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/05\/03\/send-email-to-dbas-when-transaction-log-sizes-reachs-the-certain-limit\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2019\/05\/03\/send-email-to-dbas-when-transaction-log-sizes-reachs-the-certain-limit\/\",\"name\":\"Send Email To DBAs When Transaction Log Sizes Reachs the Certain Limit - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/05\/03\/send-email-to-dbas-when-transaction-log-sizes-reachs-the-certain-limit\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/05\/03\/send-email-to-dbas-when-transaction-log-sizes-reachs-the-certain-limit\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/05\/Ads\u0131z-1.png\",\"datePublished\":\"2019-05-03T14:51:18+00:00\",\"dateModified\":\"2019-05-03T14:51:19+00:00\",\"description\":\"Send Email To DBAs When Transaction Log Sizes Reachs the Certain Limit\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/05\/03\/send-email-to-dbas-when-transaction-log-sizes-reachs-the-certain-limit\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/05\/03\/send-email-to-dbas-when-transaction-log-sizes-reachs-the-certain-limit\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/05\/03\/send-email-to-dbas-when-transaction-log-sizes-reachs-the-certain-limit\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/05\/Ads\u0131z-1.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/05\/Ads\u0131z-1.png\",\"width\":537,\"height\":317},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/05\/03\/send-email-to-dbas-when-transaction-log-sizes-reachs-the-certain-limit\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Send Email To DBAs When Transaction Log Sizes Reachs the Certain Limit\"}]},{\"@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\/fc047c39e1e53dce28fc4253529ea408\",\"name\":\"dbtut\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"caption\":\"dbtut\"},\"description\":\"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.\",\"sameAs\":[\"http:\/\/NurullahCAKIR\"],\"url\":\"https:\/\/dbtut.com\/index.php\/author\/dbtut\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Send Email To DBAs When Transaction Log Sizes Reachs the Certain Limit - Database Tutorials","description":"Send Email To DBAs When Transaction Log Sizes Reachs the Certain Limit","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\/05\/03\/send-email-to-dbas-when-transaction-log-sizes-reachs-the-certain-limit\/","og_locale":"en_US","og_type":"article","og_title":"Send Email To DBAs When Transaction Log Sizes Reachs the Certain Limit - Database Tutorials","og_description":"Send Email To DBAs When Transaction Log Sizes Reachs the Certain Limit","og_url":"https:\/\/dbtut.com\/index.php\/2019\/05\/03\/send-email-to-dbas-when-transaction-log-sizes-reachs-the-certain-limit\/","og_site_name":"Database Tutorials","article_published_time":"2019-05-03T14:51:18+00:00","article_modified_time":"2019-05-03T14:51:19+00:00","og_image":[{"width":537,"height":317,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/05\/Ads\u0131z-1.png","type":"image\/png"}],"author":"dbtut","twitter_card":"summary_large_image","twitter_misc":{"Written by":"dbtut","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2019\/05\/03\/send-email-to-dbas-when-transaction-log-sizes-reachs-the-certain-limit\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/05\/03\/send-email-to-dbas-when-transaction-log-sizes-reachs-the-certain-limit\/"},"author":{"name":"dbtut","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408"},"headline":"Send Email To DBAs When Transaction Log Sizes Reachs the Certain Limit","datePublished":"2019-05-03T14:51:18+00:00","dateModified":"2019-05-03T14:51:19+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/05\/03\/send-email-to-dbas-when-transaction-log-sizes-reachs-the-certain-limit\/"},"wordCount":196,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/05\/03\/send-email-to-dbas-when-transaction-log-sizes-reachs-the-certain-limit\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/05\/Ads\u0131z-1.png","keywords":["Estimating transaction log size","Finding Log Size for all Databases in SQL Server","How do I find the transaction log size in SQL Server?","how to check transaction log size in sql server","How to determine SQL Server database transaction log usage","monitoring transaction log size","send email to dbas when transaction log size reachs the certain limit","send email transaction log size","sql server transaction log size"],"articleSection":["MSSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2019\/05\/03\/send-email-to-dbas-when-transaction-log-sizes-reachs-the-certain-limit\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2019\/05\/03\/send-email-to-dbas-when-transaction-log-sizes-reachs-the-certain-limit\/","url":"https:\/\/dbtut.com\/index.php\/2019\/05\/03\/send-email-to-dbas-when-transaction-log-sizes-reachs-the-certain-limit\/","name":"Send Email To DBAs When Transaction Log Sizes Reachs the Certain Limit - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/05\/03\/send-email-to-dbas-when-transaction-log-sizes-reachs-the-certain-limit\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/05\/03\/send-email-to-dbas-when-transaction-log-sizes-reachs-the-certain-limit\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/05\/Ads\u0131z-1.png","datePublished":"2019-05-03T14:51:18+00:00","dateModified":"2019-05-03T14:51:19+00:00","description":"Send Email To DBAs When Transaction Log Sizes Reachs the Certain Limit","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/05\/03\/send-email-to-dbas-when-transaction-log-sizes-reachs-the-certain-limit\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2019\/05\/03\/send-email-to-dbas-when-transaction-log-sizes-reachs-the-certain-limit\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2019\/05\/03\/send-email-to-dbas-when-transaction-log-sizes-reachs-the-certain-limit\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/05\/Ads\u0131z-1.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/05\/Ads\u0131z-1.png","width":537,"height":317},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2019\/05\/03\/send-email-to-dbas-when-transaction-log-sizes-reachs-the-certain-limit\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"Send Email To DBAs When Transaction Log Sizes Reachs the Certain Limit"}]},{"@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\/fc047c39e1e53dce28fc4253529ea408","name":"dbtut","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","caption":"dbtut"},"description":"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.","sameAs":["http:\/\/NurullahCAKIR"],"url":"https:\/\/dbtut.com\/index.php\/author\/dbtut\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/11995","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\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=11995"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/11995\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/11998"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=11995"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=11995"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=11995"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}