Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

Flight Recorder eanbled for SQL Server Analysis Services


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.


↑ Back to the top


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 softwareRule titleRule descriptionProduct 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 





↑ Back to the top


Keywords: kb

↑ Back to the top

Article Info
Article ID : 2128005
Revision : 1
Created on : 1/7/2017
Published on : 4/2/2012
Exists online : False
Views : 129