Key Lookups

  • ericwenger1

    Hall of Fame

    Points: 3368

    I'm trying to come up with a script that will identify key lookups that have a certain percentage of the query cost. Like if the key lookup is 50% of the query cost then I want the result set.

  • Site Owners

    SSC Guru

    Points: 80378

    Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • Sue_H

    SSC Guru

    Points: 90424

    I'd probably not go down the route of looking at the costs and just look for Key lookups . But the following should help you get started on putting something together:

    Can You Dig It? – Find Estimated Cost

    This has a great explanation and is focused on just getting the key lookups:

    Finding Key Lookups inside the Plan Cache

    Sue

     

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply