Summary

SQL Server Analysis Services Flight Recorder provides a mechanism to record server activity into a short-term log. Information captured by Flight Recorder can be helpful for troubleshooting specific issues, however the load placed on the server when capturing the snapshots and trace events can have a small impact on overall performance.  For optimal performance the flight recorder should be disabled unless attempting to capture diagnostic information relevant to troubleshooting a specific problem.


More Information

For more information about the products or tools that automatically check for this condition on your instance of SQL Server and on the versions of the SQL Server product, see the following table:

Rule software

Rule title

Rule description

Product versions against which the rule is evaluated

SQL Server 2008 R2 Best Practice Analyzer (SQL Server 2008 R2 )

Flight Recorder Enabled for SQL Server Analysis Services

The SQL Server 2008 R2 Best Practice Analyzer (SQL Server 2008 R2 BPA) provides a rule to detect the status of the Flight Recorder. If you run the BPA tool and get the warning message "Flight Recorder Enabled for SQL Server Analysis Services", you should consider disabling the Flight Recorder on the server.

SQL Server 2008
SQL Server 2008 R2

SQL Server 2012 Best Practice Analyzer (SQL Server 2012 BPA)

Flight Recorder Enabled for SQL Server Analysis Services

The SQL Server 2012 Best Practice Analyzer (SQL Server 2012 BPA) provides a rule to detect the status of the Flight Recorder. If you run the BPA tool and get the warning message "Flight Recorder Enabled for SQL Server Analysis Services", you should consider disabling the Flight Recorder on the server.

SQL Server 2012 





Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

What affected your experience?

Thank you for your feedback!

×