SQLPerf: Measuring anything has an effect on it

I’ve been back doing SQL performance tuning work this week. This morning I had a good reminder that whenever you measure something you have an effect on it. The procedure I was working on was at the head of 46% of all blocking chains on the site yesterday. When I looked into it, the #1 reason it was blocking was the call: — DEV ENV ONLY : Log this query call EXEC p_XXX_DAF_LogQueryRequest ‘p_XXX_DAF_L2M_CTSGetGroup’  (name modified to keep details private). This call is at the beginning of every procedure on the site. It counts the number of times the proc has … Continue reading SQLPerf: Measuring anything has an effect on it

TechEd US – Orlando – Done and dusted

TechEd US is now done and dusted. It was a great event. I really enjoyed the chance to catch up with so many people from the SQL MVP community, the RD community and others. I ended up doing a series of interviews at Virtual TechEd (www.virtualteched.com). Not sure when they’ll get posted up but there’s some great material on that site for those that couldn’t make it to the event in person. Thanks to the INETA and Culminis folk for organising the Birds of a Feather session on user groups. I was one of a panel of five organising that … Continue reading TechEd US – Orlando – Done and dusted