SQLs Black Box Recorder – sp_server_diagnostics

The diagnostics process will trap various server related health (diagnostics) information related to the SQL Server instance in an effort to try and detect potential failures and errors.