Hey,
I’ve finally gotten around to doing this. I had so much difficulty getting the video done that I just left in some of the, what should have been, out takes, so apologies for that!
This is a very quick guide to gathering data, and importing it into an app called SQL Nexus. It will give you a clear and concise look at the goings on in your SQL server.
The report I clicked and it threw up an error, I hadn’t connected it up properly, so it’s not the apps fault (It’s not a feature I use so my fault for not checking through).
Anyway, the links for the software you need to perform this work, and the first link is important, because a lot of what SQL Nexus will tell you, is what SQL Server is waiting on from a resource perspective. So knowing what they mean will become important:
SQL Server pedia’s guide to Wait Types – http://sqlserverpedia.com/wiki/Wait_Types
SQL Nexus – http://sqlnexus.codeplex.com/releases/view/31925
PSS Diag – http://diagmanager.codeplex.com/
RML Utilities/ReadTrace – http://sqlnexus.codeplex.com/wikipage?title=ReadTrace&referringTitle=Home
SQL Nexus Home Page – http://sqlnexus.codeplex.com/
If you’re interested in a more in depth tutorial, plus some use cases, here’s a link to the tutorial put together by Amit Banerjee – http://zeollar.cloudapp.net/Session/144
Best of luck!
Stephen