Where do I begin?

This is a slow running report sp. It takes about 30 mins even after implementing every missing index (NB: all these databases are overwritten every night - so adding indexes here on 'reporting' is not permanent - just saying).

I post this partly to learn performance tuning.

Step-2 (after looking at indexes) would be ...looking at scans? lookups? spools? sorts? the big picture? its blinding.

avatar image By RichardBrianSmith 97 asked Feb 18, 2016 at 02:48 PM
more ▼
(comments are locked)
avatar image Matak Feb 18, 2016 at 09:51 PM

If it was me i would go and fix the high % key lookups and also fix up the RID lookups (i believe this means you have a Heap). Just remember not all key lookups are an issue.

avatar image RichardBrianSmith Feb 19, 2016 at 01:56 PM

Thanks Matak.

10|10000 characters needed characters left

0 answers: sort voted first
Be the first one to answer this question
toggle preview:

Up to 50 attachments (including images) can be used with a maximum of 209.7 MB each and 209.7 MB total.

Follow this question

Topics:

x641
x455
x89
x39

asked: Feb 18, 2016 at 02:48 PM

Seen: 56 times

Last Updated: Feb 19, 2016 at 02:53 PM