SQL Server's "Flight Recorder"

SQL Server has a 'black-box' trace, similar to an aircraft flight-recorder. It's an internal trace that has the last 5MB of various trace events and it's dumped to a file when SQL Server crashes. This can be really useful if you're troubleshooting an issue that is causing SQL Server to crash or someone or something is telling SQL Server to shutdown and its unclear who or what is doing it.

Reply

The content of this field is kept private and will not be shown publicly.
  • Allowed HTML tags: <a> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd> <hr> <sup> <!-- --> <blockquote>
  • Lines and paragraphs break automatically.
  • You can use context links in the text to create context-related links to pages or sites that provide additional information about a word or phrase.
  • Glossary terms will be automatically marked with links to their descriptions
  • Web and e-mail addresses are automatically converted into links.
  • Textual smileys will be replaced with graphical ones.
  • Scripture references will be linked automatically to an online Bible. E.g. John 3:16, Eph 2:8-9 (ESV).
  • You may link to webpages through the weblinks registry
More information about formatting options