{"id":46040,"date":"2026-07-30T08:30:38","date_gmt":"2026-07-30T06:30:38","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/?p=46040"},"modified":"2026-07-30T08:30:38","modified_gmt":"2026-07-30T06:30:38","slug":"green-sql-server-dba-tips-2-when-logs-and-history-records-cause-your-database-to-growth-and-crash","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/green-sql-server-dba-tips-2-when-logs-and-history-records-cause-your-database-to-growth-and-crash\/","title":{"rendered":"Green SQL Server DBA Tips #2 \u2013 When logs and history records cause your database to growth and crash"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">How often do I come across this sort of problem when visiting clients? Even more with our customers\u2019 service desk (support) SLAs.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">We turn up on a Monday morning and there are alerts from the weekend saying<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em>[MSSQL] &#8211; Instance Dark_Vador-Data(F:): Disk space in GB on server Death_Star is critical<\/em><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em>Info: NOT OK &#8211; Free space: 20 MB out of 200 GB<\/em><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The storage is almost full and:<br> &#8211; no projects were deployed over the weekend<br> &#8211; no exceptional data loads were scheduled<br> &#8211; nobody works at the weekend<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">A strange phenomenon to come across on a Monday morning&#8230;.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">On closer inspection, the findings are surprising; we can see that a database within the instance has been undergoing regular autogrowth for weeks&#8230;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Every day, there are several regular autogrowth on the data file for this database until the saturation of the disk.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Who is the culprit?<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Not the business data, but one or more tables named xxxxLog or Historyxxx, or the combination of both HistoryLog!<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">PS: It\u2019s an example but in the reality before the weekend, we will have Warnings and in the majority of the cases we react before the critical alert of course!<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Data created to diagnose a problem, track an activity or maintain a history, which is then never cleaned up or has a default retention period that is too long and unsuitable for the context, is not always easy to detect.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">On the other hand, it\u2019s always easier to expand disk capacity without too much effort, and everything runs smoothly in an ideal world\u2026<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">We, however, are Green SQL Server DBA; we\u2019ll look deeper.<br>Our curiosity will lead us to challenge the business on these points.<\/p>\n\n\n\n<h2 id=\"h-the-audit\" class=\"wp-block-heading\">The AUDIT<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">First, you need to know the autogrowth settings for these databases and how the data file growth. <br>Here is a simple script that shows the settings:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT\n    DB_NAME(database_id) AS DatabaseName,\n    name AS LogicalFileName,\n    type_desc AS FileType,\n    physical_name AS PhysicalFileName,\n    size \/ 128.0 AS CurrentSizeMB,\n    CASE\n        WHEN is_percent_growth = 1\n            THEN CAST(growth AS VARCHAR(10)) + ' %'\n        ELSE CAST(growth \/ 128 AS VARCHAR(10)) + ' MB'\n    END AS AutoGrowth,\n    max_size,\n    CASE\n        WHEN max_size = -1 THEN 'Unlimited'\n        ELSE CAST(max_size \/ 128 AS VARCHAR(20)) + ' MB'\n    END AS MaxSize\nFROM sys.master_files where type_desc='ROWS' AND database_id &gt; 4\nORDER BY\n    DatabaseName,\n    FileType,\n    LogicalFileName;\n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Like for my precedent blog \u201c<strong><a href=\"https:\/\/www.dbi-services.com\/blog\/green-sql-server-dba-tips-1-are-unnecessary-indexes-cluttering-up-your-database\/\">Green SQL Server DBA Tips \u00a0#1 \u2013 Are unnecessary indexes cluttering up your database?<\/a><\/strong>\u201d, I use the Dynamics database as example:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/07\/autogrowth01.png\" alt=\"\" class=\"wp-image-46041\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">In my script, I exclude all system databases and the Log File to be concentrated to the Data File.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Now, I need to have the data file growth. This is through the default trace file and the event 92:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>DECLARE @TraceFile NVARCHAR(500);\n\nSELECT @TraceFile = path\nFROM sys.traces\nWHERE is_default = 1;\n\nIF @TraceFile IS NULL\nBEGIN\n    RAISERROR('Default Trace is disabled.',16,1);\n    RETURN;\nEND\n\n;WITH GrowthEvents AS\n(\n    SELECT\n        DB_NAME(DatabaseID) AS DatabaseName, FileName, CAST(StartTime AS DATE) AS GrowthDate,\n        DATEPART(YEAR, StartTime) AS YearNum, DATEPART(WEEK, StartTime) AS WeekNum,\n        DATEPART(MONTH, StartTime) AS MonthNum, IntegerData * 8.0 \/ 1024 AS GrowthMB\n    FROM fn_trace_gettable(@TraceFile, DEFAULT)\n    WHERE EventClass IN (92) -- 92 is data growth\n)\n\nSELECT DatabaseName,FileName,GrowthDate,COUNT(*) AS GrowthEvents,SUM(GrowthMB) AS TotalGrowthMB\nFROM GrowthEvents GROUP BY DatabaseName,FileName,GrowthDate ORDER BY DatabaseName, GrowthDate\n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">As I don\u2019t have any growth on the dynamicsBC database, I switch to the M-Files database for my example:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/07\/autogrowth02.png\" alt=\"\" class=\"wp-image-46042\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">We have here some daily growth&#8230;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Go to see if we have historical or log tables in M-Files with this simple script who give us\u00a0 the table and the row count and MB:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT s.name AS Schema_Name,t.name AS Table_Name,\n    SUM(p.rows) AS Row_Count, CAST(SUM(a.total_pages) * 8.0 \/ 1024 AS DECIMAL(18,2)) AS SizeMB\nFROM sys.tables t INNER JOIN sys.schemas s     ON t.schema_id = s.schema_id\nINNER JOIN sys.indexes i ON t.object_id = i.object_id\nINNER JOIN sys.partitions p ON i.object_id = p.object_id  AND i.index_id = p.index_id\nINNER JOIN sys.allocation_units a ON p.partition_id = a.container_id\nWHERE t.name LIKE 'Histor%' OR t.name LIKE '%Log'\nGROUP BY s.name, t.name ORDER BY SizeMB DESC;\n<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/07\/autogrowth03.png\" alt=\"\" class=\"wp-image-46043\" \/><\/figure>\n\n\n\n<h2 id=\"h-the-analisys\" class=\"wp-block-heading\">The ANALISYS<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">In my case, we can see that we have 383550 lignes (19.73Mb) on the table named OBJECTTYPECHANGELOG for a M-Files database.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">It\u2019s only ~20MB here but in few months perhaps 20 GB or more&#8230;<br><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">As a Green SQL Server DBA, I will contact the owner of M-Files project otherwise don&#8217;t forget that dbi services has also the expertise in ECM tools like M-Files.<\/p>\n\n\n\n<h2 id=\"h-the-impact\" class=\"wp-block-heading\">The IMPACT<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Like in my precedent post, we will have the same impacts<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>The first impact is on DML INSERT operations.<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">With every insertion, the log or historical information is written to the table and update perhaps also index and at the end is never used by a query.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>The second impact is the storage and the backup<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">If the log table represents ~20 GB of the database.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">It\u2019s 20 GB backed up unnecessarily, 20 GB restored unnecessarily and, above all, 20 GB stored unnecessarily and just for one environment.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">If you have Dev, Test, PreProd &amp; Prod and all in HA\u2026 I let you do the calculation but it\u2019s more 100 GB!<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>The third impact is on the maintenance plan<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The following operations must also handle the log\/historical tables:<br>\u2013 Rebuild Index<br>\u2013 Reorganise Index<br>\u2013 CheckDB<br>\u2013 Backups<br>\u2013 Restores<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Each growth of log\/historical tables extends the maintenance windows\u2026<\/p>\n\n\n\n<h2 id=\"h-the-advise\" class=\"wp-block-heading\">The ADVISE<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">You really need to be careful before deleting anything in these table.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Don\u2019t Truncate the table because you see it!<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">First see with the vendor if a purge or a retention parameter exists through the application.&nbsp;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">In my case with M-Files and the table OBJECTTYPECHANGELOG, in the administration interface, you can configure the retention. Go to challenge your M-Files team on it! \ud83d\ude09<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Finally, for every large log or historical table, you need to ask yourself the following questions:<br>\u2013 Who uses it?<br>\u2013 How often?<br>\u2013 Is there a legal obligation?<br>\u2013 What retention period is required?<br>\u2013 Can it be archived?<br>\u2013 Can it be purged?<\/p>\n\n\n\n<h2 id=\"h-the-green-sql-server-dba-score\" class=\"wp-block-heading\">The Green SQL Server DBA Score<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Like for my precedent post, I setup a \u2018SQL Server DBA Score\u2019 to use for my tips on the subject:<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><td><strong>Data growth per month<\/strong><\/td><td><strong>Score<\/strong><\/td><\/tr><tr><td>0 to 2<\/td><td>10<\/td><\/tr><tr><td>3 to 5<\/td><td>8<\/td><\/tr><tr><td>6 to 10<\/td><td>5<\/td><\/tr><tr><td>11 to 20<\/td><td>2<\/td><\/tr><tr><td>&gt; 20<\/td><td>0<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h2 id=\"h-conclusion\" class=\"wp-block-heading\">Conclusion<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">A traditional SQL Server DBA or system administrator will see a data disk full and says:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>&#8220;How much GB need we to extend the disk?&#8221;<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">A Green SQL Server DBA sees a data disk full and says:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>&#8220;Why is my disk full and what can I do?&#8221;<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Just like adding a larger trunk doesn&#8217;t make a car more efficient, adding more GB doesn&#8217;t make a database healthier.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The greenest SQL Server DBA is not the one with the largest disks but it&#8217;s the one that keeps only data that continues to deliver value. \ud83d\ude80<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Think about it and begin now to see if you have cases!<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">See you soon for the next one!&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>How often do I come across this sort of problem when visiting clients? Even more with our customers\u2019 service desk (support) SLAs. We turn up on a Monday morning and there are alerts from the weekend saying [MSSQL] &#8211; Instance Dark_Vador-Data(F:): Disk space in GB on server Death_Star is critical Info: NOT OK &#8211; Free&hellip;&nbsp;<\/p>\n","protected":false},"author":15,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"neve_meta_sidebar":"","neve_meta_container":"","neve_meta_enable_content_width":"","neve_meta_content_width":0,"neve_meta_title_alignment":"","neve_meta_author_avatar":"","neve_post_elements_order":"","neve_meta_disable_header":"","neve_meta_disable_footer":"","neve_meta_disable_title":"","neve_meta_reading_time":"","_themeisle_gutenberg_block_has_review":false,"footnotes":""},"categories":[4133,99],"tags":[],"class_list":["post-46040","post","type-post","status-publish","format-standard","hentry","category-database","category-sql-server"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v28.4 (Yoast SEO v28.7) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Green SQL Server DBA Tips #2 \u2013 When logs and history records cause your database to growth and crash - dbi services | 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\/green-sql-server-dba-tips-2-when-logs-and-history-records-cause-your-database-to-growth-and-crash\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Green SQL Server DBA Tips #2 \u2013 When logs and history records cause your database to growth and crash\" \/>\n<meta property=\"og:description\" content=\"How often do I come across this sort of problem when visiting clients? Even more with our customers\u2019 service desk (support) SLAs. We turn up on a Monday morning and there are alerts from the weekend saying [MSSQL] &#8211; Instance Dark_Vador-Data(F:): Disk space in GB on server Death_Star is critical Info: NOT OK &#8211; Free&hellip;&nbsp;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/green-sql-server-dba-tips-2-when-logs-and-history-records-cause-your-database-to-growth-and-crash\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi services | Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/dbiservices\/\" \/>\n<meta property=\"article:published_time\" content=\"2026-07-30T06:30:38+00:00\" \/>\n<meta name=\"author\" content=\"St\u00e9phane Haby\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@dbiservices\" \/>\n<meta name=\"twitter:site\" content=\"@dbiservices\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"St\u00e9phane Haby\" \/>\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\\\/green-sql-server-dba-tips-2-when-logs-and-history-records-cause-your-database-to-growth-and-crash\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/green-sql-server-dba-tips-2-when-logs-and-history-records-cause-your-database-to-growth-and-crash\\\/\"},\"author\":{\"name\":\"St\u00e9phane Haby\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/7980252d7d7a521e285e7c66114cf82a\"},\"headline\":\"Green SQL Server DBA Tips #2 \u2013 When logs and history records cause your database to growth and crash\",\"datePublished\":\"2026-07-30T06:30:38+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/green-sql-server-dba-tips-2-when-logs-and-history-records-cause-your-database-to-growth-and-crash\\\/\"},\"wordCount\":913,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/green-sql-server-dba-tips-2-when-logs-and-history-records-cause-your-database-to-growth-and-crash\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/07\\\/autogrowth01.png\",\"articleSection\":[\"Database\",\"SQL Server\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/green-sql-server-dba-tips-2-when-logs-and-history-records-cause-your-database-to-growth-and-crash\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/green-sql-server-dba-tips-2-when-logs-and-history-records-cause-your-database-to-growth-and-crash\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/green-sql-server-dba-tips-2-when-logs-and-history-records-cause-your-database-to-growth-and-crash\\\/\",\"name\":\"Green SQL Server DBA Tips #2 \u2013 When logs and history records cause your database to growth and crash - dbi services | Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/green-sql-server-dba-tips-2-when-logs-and-history-records-cause-your-database-to-growth-and-crash\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/green-sql-server-dba-tips-2-when-logs-and-history-records-cause-your-database-to-growth-and-crash\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/07\\\/autogrowth01.png\",\"datePublished\":\"2026-07-30T06:30:38+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/green-sql-server-dba-tips-2-when-logs-and-history-records-cause-your-database-to-growth-and-crash\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/green-sql-server-dba-tips-2-when-logs-and-history-records-cause-your-database-to-growth-and-crash\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/green-sql-server-dba-tips-2-when-logs-and-history-records-cause-your-database-to-growth-and-crash\\\/#primaryimage\",\"url\":\"\",\"contentUrl\":\"\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/green-sql-server-dba-tips-2-when-logs-and-history-records-cause-your-database-to-growth-and-crash\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Green SQL Server DBA Tips #2 \u2013 When logs and history records cause your database to growth and crash\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\",\"name\":\"dbi services Blog\",\"description\":\"#BeSharing\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#organization\"},\"alternateName\":\"dbi Blog\",\"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\":\"Organization\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#organization\",\"name\":\"dbi services\",\"alternateName\":\"dbi\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/dbi-services-logo.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/dbi-services-logo.png\",\"width\":512,\"height\":512,\"caption\":\"dbi services\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/dbiservices\\\/\",\"https:\\\/\\\/x.com\\\/dbiservices\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/dbi-services\\\/\",\"https:\\\/\\\/www.youtube.com\\\/user\\\/dbiservices\"],\"description\":\"Swiss IT consulting and services company specialised in efficient data infrastructures and platforms: databases, application servers, cloud, DevOps, digitalization, analytics, data quality and monitoring. Headquartered in Del\u00e9mont with offices in Nyon, Basel, Bern and Zurich.\",\"email\":\"info@dbi-services.com\",\"telephone\":\"+41 32 422 96 00\",\"legalName\":\"dbi services SA\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/7980252d7d7a521e285e7c66114cf82a\",\"name\":\"St\u00e9phane Haby\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/08\\\/STH_web-min-scaled.jpg\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/08\\\/STH_web-min-scaled.jpg\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/08\\\/STH_web-min-scaled.jpg\",\"caption\":\"St\u00e9phane Haby\"},\"description\":\"St\u00e9phane Haby has more than 20 years of experience in Microsoft solutions, specializing in the installation, migration, best practices, and performance analysis of Microsoft SQL Server, as well as Microsoft Business Intelligence solutions (SharePoint, Office) and .NET development for the banking sector. A former Microsoft Most Valuable Professional (MVP) and early adopter of Microsoft Team System in France, he has authored several technical articles. He holds Microsoft Certified Solutions Associate (MCSA) and Expert (MCSE) for SQL Server, MCTS, MCITP for SQL Server 2008, and ITIL V3 Foundation certifications. His industry experience covers chemicals and pharma, banking, and financial services.\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/author\\\/stephane-haby\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Green SQL Server DBA Tips #2 \u2013 When logs and history records cause your database to growth and crash - dbi services | 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\/green-sql-server-dba-tips-2-when-logs-and-history-records-cause-your-database-to-growth-and-crash\/","og_locale":"en_US","og_type":"article","og_title":"Green SQL Server DBA Tips #2 \u2013 When logs and history records cause your database to growth and crash","og_description":"How often do I come across this sort of problem when visiting clients? Even more with our customers\u2019 service desk (support) SLAs. We turn up on a Monday morning and there are alerts from the weekend saying [MSSQL] &#8211; Instance Dark_Vador-Data(F:): Disk space in GB on server Death_Star is critical Info: NOT OK &#8211; Free&hellip;&nbsp;","og_url":"https:\/\/www.dbi-services.com\/blog\/green-sql-server-dba-tips-2-when-logs-and-history-records-cause-your-database-to-growth-and-crash\/","og_site_name":"dbi services | Blog","article_publisher":"https:\/\/www.facebook.com\/dbiservices\/","article_published_time":"2026-07-30T06:30:38+00:00","author":"St\u00e9phane Haby","twitter_card":"summary_large_image","twitter_creator":"@dbiservices","twitter_site":"@dbiservices","twitter_misc":{"Written by":"St\u00e9phane Haby","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/green-sql-server-dba-tips-2-when-logs-and-history-records-cause-your-database-to-growth-and-crash\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/green-sql-server-dba-tips-2-when-logs-and-history-records-cause-your-database-to-growth-and-crash\/"},"author":{"name":"St\u00e9phane Haby","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/7980252d7d7a521e285e7c66114cf82a"},"headline":"Green SQL Server DBA Tips #2 \u2013 When logs and history records cause your database to growth and crash","datePublished":"2026-07-30T06:30:38+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/green-sql-server-dba-tips-2-when-logs-and-history-records-cause-your-database-to-growth-and-crash\/"},"wordCount":913,"commentCount":0,"publisher":{"@id":"https:\/\/www.dbi-services.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/green-sql-server-dba-tips-2-when-logs-and-history-records-cause-your-database-to-growth-and-crash\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/07\/autogrowth01.png","articleSection":["Database","SQL Server"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/green-sql-server-dba-tips-2-when-logs-and-history-records-cause-your-database-to-growth-and-crash\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/green-sql-server-dba-tips-2-when-logs-and-history-records-cause-your-database-to-growth-and-crash\/","url":"https:\/\/www.dbi-services.com\/blog\/green-sql-server-dba-tips-2-when-logs-and-history-records-cause-your-database-to-growth-and-crash\/","name":"Green SQL Server DBA Tips #2 \u2013 When logs and history records cause your database to growth and crash - dbi services | Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/green-sql-server-dba-tips-2-when-logs-and-history-records-cause-your-database-to-growth-and-crash\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/green-sql-server-dba-tips-2-when-logs-and-history-records-cause-your-database-to-growth-and-crash\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/07\/autogrowth01.png","datePublished":"2026-07-30T06:30:38+00:00","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/green-sql-server-dba-tips-2-when-logs-and-history-records-cause-your-database-to-growth-and-crash\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/green-sql-server-dba-tips-2-when-logs-and-history-records-cause-your-database-to-growth-and-crash\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/green-sql-server-dba-tips-2-when-logs-and-history-records-cause-your-database-to-growth-and-crash\/#primaryimage","url":"","contentUrl":""},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/green-sql-server-dba-tips-2-when-logs-and-history-records-cause-your-database-to-growth-and-crash\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Green SQL Server DBA Tips #2 \u2013 When logs and history records cause your database to growth and crash"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi services Blog","description":"#BeSharing","publisher":{"@id":"https:\/\/www.dbi-services.com\/blog\/#organization"},"alternateName":"dbi Blog","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":"Organization","@id":"https:\/\/www.dbi-services.com\/blog\/#organization","name":"dbi services","alternateName":"dbi","url":"https:\/\/www.dbi-services.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/09\/dbi-services-logo.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/09\/dbi-services-logo.png","width":512,"height":512,"caption":"dbi services"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/dbiservices\/","https:\/\/x.com\/dbiservices","https:\/\/www.linkedin.com\/company\/dbi-services\/","https:\/\/www.youtube.com\/user\/dbiservices"],"description":"Swiss IT consulting and services company specialised in efficient data infrastructures and platforms: databases, application servers, cloud, DevOps, digitalization, analytics, data quality and monitoring. Headquartered in Del\u00e9mont with offices in Nyon, Basel, Bern and Zurich.","email":"info@dbi-services.com","telephone":"+41 32 422 96 00","legalName":"dbi services SA"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/7980252d7d7a521e285e7c66114cf82a","name":"St\u00e9phane Haby","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/08\/STH_web-min-scaled.jpg","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/08\/STH_web-min-scaled.jpg","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/08\/STH_web-min-scaled.jpg","caption":"St\u00e9phane Haby"},"description":"St\u00e9phane Haby has more than 20 years of experience in Microsoft solutions, specializing in the installation, migration, best practices, and performance analysis of Microsoft SQL Server, as well as Microsoft Business Intelligence solutions (SharePoint, Office) and .NET development for the banking sector. A former Microsoft Most Valuable Professional (MVP) and early adopter of Microsoft Team System in France, he has authored several technical articles. He holds Microsoft Certified Solutions Associate (MCSA) and Expert (MCSE) for SQL Server, MCTS, MCITP for SQL Server 2008, and ITIL V3 Foundation certifications. His industry experience covers chemicals and pharma, banking, and financial services.","url":"https:\/\/www.dbi-services.com\/blog\/author\/stephane-haby\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/46040","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\/15"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=46040"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/46040\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=46040"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=46040"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=46040"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}