I’ve always been a big fan of analysing the SQL workload to find expensive and long duration queries, the best tool by far that I regularly use is RML utilities http://www.microsoft.com/downloads/en/details.aspx?FamilyId=7EDFA95A-A32F-440F-A3A8-5160C8DBE926&displaylang=en The toolset is just plain amazing in the wealth of details that it can give. i have yet to be on a performance tuning gig … Continue reading Using xPath and XML to Interrogate Query Plans