Tag Archives: diagnostics

SQL Server “Denali” has introduced a new way to capture SQL Server health and diagnostic information with the sp_server_diagnostics stored procedure: sp_server_diagnostics [@repeat_interval =] ‘repeat_interval_in_seconds’ The stored procedure runs in “repeat mode” and periodically returns results.  Specifying 0 as the … Continue reading →