Re:Implementing SQL Server Performance Indicator for Queries...
by BrentOzar on Monday April 03, 2017 @10:16AM
(#14022888)
You don't have to run a trace or capture data to get this stuff - SQL Server already collects most of it in the diagnostic views. You can run the open source sp_BlitzCache to surface this stuff:
Github repo & instructions: https://FirstResponderKit.org
(source: coauthor)