Category : Key Lookups - SentryOne Team Blog

Category: Key Lookups

When Troubleshooting Performance Start with the Big Picture

When Troubleshooting Performance Start with the Big Picture

Allen White blogs about one of the great benefits of SQL Sentry: it presents you with an overall picture of the server's performance, allowing you to see what's going on as a whole, and then allowing you to drill into the areas that may be of concern.

Resolving Key Lookup Deadlocks with Plan Explorer

Resolving Key Lookup Deadlocks with Plan Explorer

Greg Gonzalez (@SQLsensei) uses Plan Explorer to walk through troubleshooting a very common type of deadlock : updates conflicting with key lookups.

Is a RID Lookup faster than a Key Lookup?

For T-SQL Tuesday #78, Aaron Bertrand (@AaronBertrand) takes a look at whether RID Lookups are faster than Key Lookups, with a small battery of fairly simple duration tests.