Hi @jed ,
Yes, you can use the Query Store to help you quickly find performance differences caused by query plan changes, it can collect the data set that accurately represents your workload
https://learn.microsoft.com/en-us/sql/relational-databases/performance/monitoring-performance-by-using-the-query-store?view=sql-server-ver15
Except profiler and Extended Events, you also can use Activity Monitor, when you expand the recent expensive queries pane, it will monitor and show the query cost. Activity Monitor is available without any additional setup, it provides a list of recently used queries and so on, and these queries are shown in real-time.
Although Activity Monitor provides sufficient information about expensive queries for query analysis and troubleshooting, other performance parameters necessary in a complete monitoring solution are not available.
Data collector also can provide performance metrics monitoring and a list of expensive queries, it keeps history data and that it collects information continuoulsy after it is been started, but this feature is useful only for basic performance monitoring, and may affect overall SQL Server performance
https://solutioncenter.apexsql.com/monitor-sql-server-queries-find-poor-performers-activity-monitor-and-data-collection/#:~:text=1%20Right-click%20the%20SQL%20Server%20instance%20node%20and,Click%20the%20Activity%20Monitor%20icon%20in%20the%20menu
-------------
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.