Tuesday, December 29, 2015

sp_server_diagnostics

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.

No comments: