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.


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 





Свойства

Номер статьи: 2128005 — последний просмотр: 2 apr 2012 — редакция: 1

Rəy