Hi Craig, thank you for your response. I don't think it is really terribly difficult, but I guess the big disappointment is that it isn't a hard and fast answer 🙁 But it is the start of a more targeted investigation - specifically focusing on the worst tables.

Assuming that there are issues with queries or index design, focus on the points that scatter out from the rest and start to look at the most expensive queries and the indexes on those tables. You will only have to do this a few times to start to see common patterns that you will quickly begin to recognise.

Regards,

Nick