Tuesday, December 29, 2015
sp_server_diagnostics sp is used to capture quick diagnostic data and health information about your SQL Server to detect potential issues. It is a must run sp that I start using recently as a quick check on your SQL server stack. You can even run this procedure when using DAC. For more detailed info visit an article on www.mssqltips.com.