I had done a blog series on the different tools that Microsoft SQL CSS uses to troubleshoot different SQL Server related issues.
Read this post on troubleshootingsql.com