Using SQLDiag and SQL Nexus to Troubleshoot Slowness

Luckily, two of the internal Microsoft tools used in order to diagnose slowdowns is also available for the publics use. These tools are SQLDiag (previously PSSDiag), and SQL Nexus. SQLDiag (short for SQL Diagnostics) monitors all aspects of the system that SQL Server is running on and generates all output needed in order to determine the bottleneck. The difficult challenge that follows is how to interpret that data. This is where SQL Nexus comes in.

SQL Nexus is an application written on the .NET framework, that utilizes a client distribution of Reporting Services in order to give us insight into the output generated from SQLDiag. While it is relatively hopping along on 3 legs, we are still very lucky to have it. This video walks you through the initial process of setting up the traces and gives a brief intro in the data you can expect to find.

In order to download, following this link and read the installation carefully.

[code]
http://sqlnexus.codeplex.com/
[/code]

The installation guide will also walk you through downloading the ReadTrace tool (contained in the Microsoft RML tools download). And it will also tell you to download the PerfStats scripts which are used in order to initiate the SQLDiag trace. These are also important.

3 comments
Ricardo Bezerra 05 Jul 2011 at 11:49 pm

Hi Derek,

Thank for your detailed video. It is very helpful.

Unfortunately I’m not able to import the .trc file. It always failed for me. I tried to import it in a Windows Server 2008 R2 machine and Windows 7 x64 machine.

Do you have any idea on what is wrong?

Thanks,

Ricardo Bezerra

Derek Dieter 08 Jul 2011 at 10:14 pm

Hi Ricardo, unfortunately I don’t. Is there a specific error message you are receiving?

Riandto 29 Aug 2015 at 6:22 am

Hey, I don’t think telling you this on your post Cardio for Weight Loss and a Fitter Body | Cardio Workout Tips is the right place but I coldun’t find a contact form. Are you interested in promoting our new weight loss product and increase you earnings? We can offer you lifetime cookie duration and generous commission. Produced by the same company who are behind other clinically proven brands like Capsiplex and C-plex60, there is no wonder why this brand is suggested to be the number one selling weight loss product for 2011. We are planning a massive PR campaign which should generate thousands of orders, this product WILL convert so make sure you jump on this right away. If you’re interested click on [this link] and find out more about our offer Regards, Jocelyn Vang

Featured Articles

 Site Author

  • Thanks for visiting!