SP; search Query plan cache for issues, like table scans, missingindexes or stats

SP; search Query plan cache for issues, like table scans, missing indexes or stats, or any other command