THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Rick Heiges

News about SQL Server and the SQL Server Community

Rick Review: SQLBits7: Consolidating Data Collection with SQLDIAG and SQLNexus

I ran across this recording about 3 months ago.  It is a recording that is open to everyone.  It was recorded at SQLBits 7 with Christian Bolton as the speaker for a session entitled: "Consolidating data collection with SQLDIAG and analysing it all with SQLNexus".  I found it very informative and hope that you will too.

SQLBits is a UK based conference that occurs twice a year and I can't wait to attend one personally from the stories that I have heard.  They record the sessions and make each one available for FREE access - AMAZING!  You can find this session at the following URL:  The imbedded video has both a video of the speaker speaking to the audience as well as a full screen capture of the presentation to make the replay even more vivid.

Christian walks through the basics of using SQLDIAG for Data Collection initially.  He then turns his attention to SQLNEXUS as a tool to analyze the data collected in SQLDIAG.  He goes through how to configure SQLDIAG to collect the necessary data (perfmon and SQLTrace data) with the SQLDIAG process in order to discover the items needed for further analysis.  If you need to perform a relatively quick analysis of a server, check this video out to discover your "pain points" for a particualr server.

After viewing this webcast, I am positive that you will find that using SQLDIAG along with SQLNEXUS will make your job easier.


Published Thursday, January 5, 2012 10:54 PM by RickHeiges

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS



Christian Bolton said:

Hi Rick,

Thanks for the review, I'm flattered that you took the time to write it :)

We're well underway with planning for SQLBits10 in London at the end of March to help launch SQL Server 2012. It would be great to see you there but if not all the sessions are being recorded and will be available for free as usual soon afterwards!



January 10, 2012 5:13 PM

RickHeiges said:

@Christian - Good Luck with SQL Bits 10!  Not sure if I can make it there or not, but I'll definitely keep my eye open for the recordings when they come out.

January 11, 2012 11:15 AM

Leave a Comment

Privacy Statement