Hall of Fame
July 2, 2019 at 4:06 pm
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.
July 3, 2019 at 4:10 pm
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
July 3, 2019 at 6:14 pm
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
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply