10/04/2013

First Try SQL Diag Configuration Tool (SDCT)

Today I decided to learn more about troubleshooting performance issues with SQL Server.

Which led me to a product called SQL Diag Configuration Tool (SDCT).

To download the product, I went to this URL on CodePlex.



Clicking on the Download button, saving the Zip file, extracting it, I began the Installation process...





To load the application in Windows 8, type SQL Diag, find the icon, and click.  The following application will appear...


Next I clicked on the SQL Server 2008 R2 button...

Began to enter Computer Name...


Then clicked Save, to store off the Confix XML files for later retrieval.

Then poked around in some of the window settings...

Clicked on "Enable SQL Tracing"...


Enabled "PerfMon Counters"...


Didn't modify the Producers Page...


Selected all entries on the Analyzer Page...


Then opened a Command Prompt.. Typed SQLDiag...


Magically, the program launched...

 

Ran a simple query for AdventureWorks2012 database... Pressed Cntrl-C to shutdown the Collector...

 
It created a folder called SQLDiag with some files...
 
I selected the file with .TXT extension... JONT530_MSINFO32.TXT... Holy smackers, a bunch of data captured....


It captures A-LOT of data.  Only thing, I don't see any metrics for the Query I ran during the Data Collections.

So to summarize, if you'd like to capture tons of metrics on your PC/Server, you can use this Command Line utility to assist in your efforts.



 

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.

Thoughts to Ponder