• Run a sample of the dynamic sql queries that run through the front end in Query Analyzer. Look at the execution plan and see what's taking the longest to execute.