Add Key Lookups to the SQL Server metrics
Though Page Splits and Full scans are useful metrics for index's, key lookups can be handy in finding areas where covering indexes are required and have been helpful in seeing where there is a regressed query from a bad plan - this would be a handy metric to have within the SQL Server metrics part of the main dashboard next to the other 2 mentioned.
19
votes