• Assuming it's a regular problem and not suddenly today it's slow when it's usually fine...

    I'd run a server-side trace and do the analysis that was described in the article you mentioned in your initial post. I wrote that article for a reason.... 😀

    Or, if the person coming to me was the developer of this page and its slow during their development phase, get them to walk me through what the page does, step by step

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass