{"id":6853,"date":"2016-01-14T15:16:27","date_gmt":"2016-01-14T14:16:27","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/sql-server-tips-default-trace-enabled-but-no-file-is-active\/"},"modified":"2016-01-14T15:16:27","modified_gmt":"2016-01-14T14:16:27","slug":"sql-server-tips-default-trace-enabled-but-no-file-is-active","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/sql-server-tips-default-trace-enabled-but-no-file-is-active\/","title":{"rendered":"SQL Server Tips: Default trace enabled but no file is active\u2026"},"content":{"rendered":"<p>I discover a strange error with a customer about the default trace.<br \/>\nAs you know, SQL Server has a default trace with a lot of events like the data and log file growth.<br \/>\nThis trace is enabled by default and you have five .trc files located in the installation directory of SQL Server.<\/p>\n<p><!--more--><\/p>\n<p>In my case, I search through the trace file, the growth history of data files with this query:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">DECLARE @filename NVARCHAR(1000);\nDECLARE @bc INT;\nDECLARE @ec INT;\nDECLARE @bfn VARCHAR(1000);\nDECLARE @efn VARCHAR(10);\n \n-- Get the name of the current default trace\nSELECT @filename = CAST(value AS NVARCHAR(1000))\nFROM ::fn_trace_getinfo(DEFAULT)\nWHERE traceid = 1 AND property = 2;\n\n-- rip apart file name into pieces\nSET @filename = REVERSE(@filename);\nSET @bc = CHARINDEX('.',@filename);\nSET @ec = CHARINDEX('_',@filename)+1;\nSET @efn = REVERSE(SUBSTRING(@filename,1,@bc));\nSET @bfn = REVERSE(SUBSTRING(@filename,@ec,LEN(@filename)));\n\n-- set filename without rollover number\nSET @filename = @bfn + @efn\nIF EXISTS (SELECT * FROM ::fn_trace_gettable(@filename, DEFAULT) AS ftg \n               WHERE (EventClass = 92  -- Date File Auto-grow\n                   OR EventClass = 93) -- Log File Auto-grow\n                  AND StartTime &gt; DATEADD(dy,-7,GETDATE())) \n\n  BEGIN -- If there are autogrows in the last day \n\tSELECT * INTO #temp_trc FROM ::fn_trace_gettable(@filename, DEFAULT) AS ftg \n\tWHERE (EventClass = 92  -- Date File Auto-grow\n        OR EventClass = 93) -- Log File Auto-grow\n       AND StartTime &gt; DATEADD(dy,-7,GETDATE())\n\n\tSelect  CONVERT(varchar,StartTime,102) as grow_date,DatabaseName as database_name,FileName as file_name,te.name as event_class,Duration\/1000  as Duration,(tmp.IntegerData*8)\/1024.0 as size_MB into #temp_trc2 from #temp_trc AS tmp \n               INNER JOIN sys.trace_events AS te ON tmp.EventClass = te.trace_event_id  \n\n\tSELECT grow_date,event_class,database_name,file_name,Count(Duration),Convert(int,Sum(size_MB)) , Sum(Duration) \n\tfrom #temp_trc2 GROUP BY grow_date,database_name,file_name,event_class\t\t\n    ORDER BY grow_date, database_name\n\t\n\tDROP TABLE #temp_trc2\n\tDROP TABLE #temp_trc\n  END\n\n<\/pre>\n<p>But I got no result\u2026<br \/>\nThe first step was to verify if the default trace is enabled with the command:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">SELECT * FROM sys.configurations WHERE name=\u2019default trace enable\u2019<\/pre>\n<p>It is enabled, then I check the current running trace with the view sys.traces<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">SELECT * FROM sys.traces<\/pre>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/TraceEnableButNotActivate01.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-6575 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/TraceEnableButNotActivate01.png\" alt=\"TraceEnableButNotActivate01\" width=\"300\" height=\"78\" \/><\/a><\/p>\n<p>As you can see, I have no file returned by the view.<br \/>\nIf I check directly the installation directory, I see the five trace files.<br \/>\nThis situation is very strange\u2026.<br \/>\nThe real question is \u201cWhat can I do?\u201d<br \/>\nThe solution was very simple.<br \/>\nI disable and re-enable the default trace with the sp_configure:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">EXEC sp_configure \u2018show advanced options\u2019,1;\nGO\nRECONFIGURE WITH OVERRIDE;\nGO\nEXEC sp_configure \u2018default trace enabled,0;\nGO\nRECONFIGURE WITH OVERRIDE;\nGO\nEXEC sp_configure \u2018default trace enabled,1;\nGO\nRECONFIGURE WITH OVERRIDE;\nGO\nEXEC sp_configure \u2018show advanced options\u2019,0;\nGO\nRECONFIGURE WITH OVERRIDE;\nGO<\/pre>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/TraceEnableButNotActivate02.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-6576 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/TraceEnableButNotActivate02.png\" alt=\"TraceEnableButNotActivate02\" width=\"300\" height=\"135\" \/><\/a><\/p>\n<p>After this, I re-run the query with the view sys.traces and I see that I have a current running trace file with a start_time from now.<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/TraceEnableButNotActivate03.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-6577 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/TraceEnableButNotActivate03.png\" alt=\"TraceEnableButNotActivate03\" width=\"300\" height=\"75\" \/><\/a><\/p>\n<p>To be sure, I use the function fr_trace_getinfo to find the current running trace file<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/TraceEnableButNotActivate04.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-6578 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/TraceEnableButNotActivate04.png\" alt=\"TraceEnableButNotActivate04\" width=\"300\" height=\"138\" \/><\/a><\/p>\n<p>To prevent this problem, I add a condition:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">IF (select count(*) FROM sys.traces ) &gt;0<\/pre>\n<p>The entire query:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">DECLARE @filename NVARCHAR(1000);\nDECLARE @bc INT;\nDECLARE @ec INT;\nDECLARE @bfn VARCHAR(1000);\nDECLARE @efn VARCHAR(10);\n\nIF (select count(*) FROM sys.traces ) &gt;0\nBEGIN\n \n-- Get the name of the current default trace\nSELECT @filename = CAST(value AS NVARCHAR(1000))\nFROM ::fn_trace_getinfo(DEFAULT)\nWHERE traceid = 1 AND property = 2;\n\n-- rip apart file name into pieces\nSET @filename = REVERSE(@filename);\nSET @bc = CHARINDEX('.',@filename);\nSET @ec = CHARINDEX('_',@filename)+1;\nSET @efn = REVERSE(SUBSTRING(@filename,1,@bc));\nSET @bfn = REVERSE(SUBSTRING(@filename,@ec,LEN(@filename)));\n\n-- set filename without rollover number\nSET @filename = @bfn + @efn\nIF EXISTS (SELECT * FROM ::fn_trace_gettable(@filename, DEFAULT) AS ftg \n               WHERE (EventClass = 92  -- Date File Auto-grow\n                   OR EventClass = 93) -- Log File Auto-grow\n                  AND StartTime &gt; DATEADD(dy,-7,GETDATE())) \n\n  BEGIN -- If there are autogrows in the last day \n\tSELECT * INTO #temp_trc FROM ::fn_trace_gettable(@filename, DEFAULT) AS ftg \n\tWHERE (EventClass = 92  -- Date File Auto-grow\n        OR EventClass = 93) -- Log File Auto-grow\n       AND StartTime &gt; DATEADD(dy,-7,GETDATE())\n\n\tSelect  CONVERT(varchar,StartTime,102) as grow_date,DatabaseName as database_name,FileName as file_name,te.name as event_class,Duration\/1000  as Duration,(tmp.IntegerData*8)\/1024.0 as size_MB into #temp_trc2 from #temp_trc AS tmp \n               INNER JOIN sys.trace_events AS te ON tmp.EventClass = te.trace_event_id  \n\n\tSELECT grow_date,event_class,database_name,file_name,Count(Duration),Convert(int,Sum(size_MB)) , Sum(Duration) \n\tfrom #temp_trc2 GROUP BY grow_date,database_name,file_name,event_class\t\t\n    ORDER BY grow_date, database_name\n\t\n\tDROP TABLE #temp_trc2\n\tDROP TABLE #temp_trc\n  END\n  END\n<\/pre>\n<p>After that, I can read the trace file to find all grows (Event Class 92 and 93) without an error due to the missing current running trace file.<br \/>\nTo be sure, I add a policy to check every day if a current running trace file is in place.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I discover a strange error with a customer about the default trace. As you know, SQL Server has a default trace with a lot of events like the data and log file growth. This trace is enabled by default and you have five .trc files located in the installation directory of SQL Server.<\/p>\n","protected":false},"author":15,"featured_media":6858,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229,198],"tags":[49,51,339,44],"type_dbi":[],"class_list":["post-6853","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-administration-monitoring","category-database-management","tag-microsoft","tag-sql-server","tag-trace","tag-troubleshooting"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>SQL Server Tips: Default trace enabled but no file is active\u2026<\/title>\n<meta name=\"description\" content=\"SQL Server has a default trace with a lot of events like the data and log file growth. The current running trace is missing with a default trace enable.\" \/>\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-tips-default-trace-enabled-but-no-file-is-active\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server Tips: Default trace enabled but no file is active\u2026\" \/>\n<meta property=\"og:description\" content=\"SQL Server has a default trace with a lot of events like the data and log file growth. The current running trace is missing with a default trace enable.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/sql-server-tips-default-trace-enabled-but-no-file-is-active\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2016-01-14T14:16:27+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/TraceEnableButNotActivate01-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1213\" \/>\n\t<meta property=\"og:image:height\" content=\"315\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"St\u00e9phane Haby\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\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=\"4 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-tips-default-trace-enabled-but-no-file-is-active\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-tips-default-trace-enabled-but-no-file-is-active\/\"},\"author\":{\"name\":\"St\u00e9phane Haby\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b\"},\"headline\":\"SQL Server Tips: Default trace enabled but no file is active\u2026\",\"datePublished\":\"2016-01-14T14:16:27+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-tips-default-trace-enabled-but-no-file-is-active\/\"},\"wordCount\":273,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-tips-default-trace-enabled-but-no-file-is-active\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/TraceEnableButNotActivate01-1.png\",\"keywords\":[\"Microsoft\",\"SQL Server\",\"Trace\",\"Troubleshooting\"],\"articleSection\":[\"Database Administration &amp; Monitoring\",\"Database management\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/sql-server-tips-default-trace-enabled-but-no-file-is-active\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-tips-default-trace-enabled-but-no-file-is-active\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-tips-default-trace-enabled-but-no-file-is-active\/\",\"name\":\"SQL Server Tips: Default trace enabled but no file is active\u2026\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-tips-default-trace-enabled-but-no-file-is-active\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-tips-default-trace-enabled-but-no-file-is-active\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/TraceEnableButNotActivate01-1.png\",\"datePublished\":\"2016-01-14T14:16:27+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b\"},\"description\":\"SQL Server has a default trace with a lot of events like the data and log file growth. The current running trace is missing with a default trace enable.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-tips-default-trace-enabled-but-no-file-is-active\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/sql-server-tips-default-trace-enabled-but-no-file-is-active\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-tips-default-trace-enabled-but-no-file-is-active\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/TraceEnableButNotActivate01-1.png\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/TraceEnableButNotActivate01-1.png\",\"width\":1213,\"height\":315},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-tips-default-trace-enabled-but-no-file-is-active\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server Tips: Default trace enabled but no file is active\u2026\"}]},{\"@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\/d0bfb7484ae81c8980fc2b11334f803b\",\"name\":\"St\u00e9phane Haby\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g\",\"caption\":\"St\u00e9phane Haby\"},\"description\":\"St\u00e9phane Haby has more than ten years of experience in Microsoft solutions. He is specialized in SQL Server technologies such as installation, migration, best practices, and performance analysis etc. He is also an expert in Microsoft Business Intelligence solutions such as SharePoint, SQL Server and Office. Futhermore, he has many years of .NET development experience in the banking sector and other industries. In France, he was one of the first people to have worked with Microsoft Team System. He has written several technical articles on this subject. St\u00e9phane Haby is Microsoft Most Valuable Professional (MVP) as well as Microsoft Certified Solutions Associate (MCSA) and\u00a0Microsoft Certified Solutions Expert (MCSE) for SQL Server 2012. He is also Microsoft Certified Technology Specialist (MCTS) and Microsoft Certified IT Professional (MCITP) for SQL Server 2008 as well as ITIL Foundation V3 certified. He holds a Engineer diploma in industrial computing and automation from France. His branch-related experience covers Chemicals &amp; Pharmaceuticals, Banking \/ Financial Services, and many other industries.\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/stephane-haby\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"SQL Server Tips: Default trace enabled but no file is active\u2026","description":"SQL Server has a default trace with a lot of events like the data and log file growth. The current running trace is missing with a default trace enable.","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-tips-default-trace-enabled-but-no-file-is-active\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server Tips: Default trace enabled but no file is active\u2026","og_description":"SQL Server has a default trace with a lot of events like the data and log file growth. The current running trace is missing with a default trace enable.","og_url":"https:\/\/www.dbi-services.com\/blog\/sql-server-tips-default-trace-enabled-but-no-file-is-active\/","og_site_name":"dbi Blog","article_published_time":"2016-01-14T14:16:27+00:00","og_image":[{"width":1213,"height":315,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/TraceEnableButNotActivate01-1.png","type":"image\/png"}],"author":"St\u00e9phane Haby","twitter_card":"summary_large_image","twitter_misc":{"Written by":"St\u00e9phane Haby","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-tips-default-trace-enabled-but-no-file-is-active\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-tips-default-trace-enabled-but-no-file-is-active\/"},"author":{"name":"St\u00e9phane Haby","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b"},"headline":"SQL Server Tips: Default trace enabled but no file is active\u2026","datePublished":"2016-01-14T14:16:27+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-tips-default-trace-enabled-but-no-file-is-active\/"},"wordCount":273,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-tips-default-trace-enabled-but-no-file-is-active\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/TraceEnableButNotActivate01-1.png","keywords":["Microsoft","SQL Server","Trace","Troubleshooting"],"articleSection":["Database Administration &amp; Monitoring","Database management"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-tips-default-trace-enabled-but-no-file-is-active\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-tips-default-trace-enabled-but-no-file-is-active\/","url":"https:\/\/www.dbi-services.com\/blog\/sql-server-tips-default-trace-enabled-but-no-file-is-active\/","name":"SQL Server Tips: Default trace enabled but no file is active\u2026","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-tips-default-trace-enabled-but-no-file-is-active\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-tips-default-trace-enabled-but-no-file-is-active\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/TraceEnableButNotActivate01-1.png","datePublished":"2016-01-14T14:16:27+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b"},"description":"SQL Server has a default trace with a lot of events like the data and log file growth. The current running trace is missing with a default trace enable.","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-tips-default-trace-enabled-but-no-file-is-active\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-tips-default-trace-enabled-but-no-file-is-active\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-tips-default-trace-enabled-but-no-file-is-active\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/TraceEnableButNotActivate01-1.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/TraceEnableButNotActivate01-1.png","width":1213,"height":315},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-tips-default-trace-enabled-but-no-file-is-active\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL Server Tips: Default trace enabled but no file is active\u2026"}]},{"@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\/d0bfb7484ae81c8980fc2b11334f803b","name":"St\u00e9phane Haby","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g","caption":"St\u00e9phane Haby"},"description":"St\u00e9phane Haby has more than ten years of experience in Microsoft solutions. He is specialized in SQL Server technologies such as installation, migration, best practices, and performance analysis etc. He is also an expert in Microsoft Business Intelligence solutions such as SharePoint, SQL Server and Office. Futhermore, he has many years of .NET development experience in the banking sector and other industries. In France, he was one of the first people to have worked with Microsoft Team System. He has written several technical articles on this subject. St\u00e9phane Haby is Microsoft Most Valuable Professional (MVP) as well as Microsoft Certified Solutions Associate (MCSA) and\u00a0Microsoft Certified Solutions Expert (MCSE) for SQL Server 2012. He is also Microsoft Certified Technology Specialist (MCTS) and Microsoft Certified IT Professional (MCITP) for SQL Server 2008 as well as ITIL Foundation V3 certified. He holds a Engineer diploma in industrial computing and automation from France. His branch-related experience covers Chemicals &amp; Pharmaceuticals, Banking \/ Financial Services, and many other industries.","url":"https:\/\/www.dbi-services.com\/blog\/author\/stephane-haby\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/6853","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=6853"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/6853\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/6858"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=6853"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=6853"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=6853"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=6853"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}