In this blog you will find various tools and articles that are useful to any DBAs. I will try to put more practical articles while at the same time post any database software bugs and some important tips on internals of sql server and optimization. Address cons and pros of different relational database management in use and new developments. This blog will also cover the market perception of different database system including some hard facts, reviews and benchmarks. Teshome Asfaw
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.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment