Solved

Error on FlightRecorderCurrent.trc.

Posted on 2009-05-19
8
5,083 Views
Last Modified: 2012-05-07
I am encountering the following error filling up the Event Viewer log
The SQL Server is a cluster system clustered on the OS side
"
An error occurred while writing a trace event to the file, \\?\\Microsoft SQL Server\MSSQL.2\OLAP\Log\FlightRecorderCurrent.trc.
"
Any idea why I am getting the error. Any help will be appreciated

Thanks
0
Comment
Question by:Greens8301
  • 4
  • 3
8 Comments
 
LVL 6

Expert Comment

by:bull_rider
ID: 24423116
0
 

Author Comment

by:Greens8301
ID: 24423592
Hi

The following snippet of .ini, could you tell me how to disable the flightrecorder which I like to try

Thanks

<FlightRecorder>
                  <Enabled>1</Enabled>
                  <FileSizeMB>10</FileSizeMB>
                  <LogDurationSec>3600</LogDurationSec>
                  <SnapshotFrequencySec>120</SnapshotFrequencySec>
                  <TraceDefinitionFile/>
                  <SnapshotDefinitionFile/>
            </FlightRecorder>

0
 
LVL 6

Accepted Solution

by:
bull_rider earned 500 total points
ID: 24423745
You just have to replace the 1 with 0

<Enabled>1</Enabled>

to

<Enabled>0</Enabled>
0
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 

Author Comment

by:Greens8301
ID: 24424379
Thanks Thats what I thought

Do I need to bounce the service to take effect
0
 
LVL 6

Expert Comment

by:bull_rider
ID: 24424610
restart the service
0
 

Author Comment

by:Greens8301
ID: 24424887
Before restarting services to check if this fix resolves the issue, is there anything else you could think of that I can try/modify  before bouncing the services
Thanks
0
 

Author Comment

by:Greens8301
ID: 24427171
Thanks for the help
0
 
LVL 1

Expert Comment

by:Connecter
ID: 26272422
hi
i have the same problem could any one help and explain how to solve it and how to disable the flightrecorder

and also my c: drive is runing out of space
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

This article will describe one method to parse a delimited string into a table of data.   Why would I do that you ask?  Let's say that you need to pass multiple parameters into a stored procedure to search for.  For our sake, we'll say that we wa…
Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…

829 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question