Microsoft has an in-house tool,--pssdiag, that collects very much information, requiring only simple configuration and operation steps.
: http://diagmanager.codeplex.com
Default installation path: C:\Program Files (x86) \microsoft\pssdiag
1. In the interface to set up the information needed to collect, click Save, will pop up a dialog box, display/modify the generated Pssd.cab file storage location, if you do not store the default location, you can click to select a different path.
2. Locate the Pssd.cab file and copy it to the server.
3. Double-click the extracted pssdiag.cmd file, a command-line window pops up and data collection begins. When the problem is tracked down, press CTRL + C to stop the collection.
4. PSSDIAG will generate an output folder in the directory where the Pssdiag.cmd is located, and when opened, you will see all the collected data, and the name is clearly identified.
5. Installing the Readtrace tool
6. Installing the Sqlnexus tool
7. Open Sqlnexus-"Connection instance-" Import imports Pssdiage output folder files, and then you can see the various collection of detailed information, the most important is the form of graphics and tabular data for easy analysis.
Automated analysis Tools PSSDIAG