How to Check the Query Performance in an SQL Server

Enabling the Query Store

1. 
   Open the SQL Server Management Studio. You can use the Query Store feature of SQL Server to monitor your database for performance issues. This feature is included with SQL Server 2016 and later, but you'll need to enable it manually.^{[1] X Research source}
2. 
   Open Object Explorer. If you don't see Object Explorer already, click the View menu at the top of the screen, then click Object Explorer.^{[2] X Research source}
3. 
   Right-click the database you want to check. A menu will appear.^{[3] X Research source}

   1. The Query Store can't be used to monitor the master or tempdb databases.
4. 
   Click Properties.
5. 
   Click Query Store. It's on the Properties dialog box.
6. 
   Select On under ″Operation Mode (Requested).″ The Query Store will begin tracking all queries.
7. 
   Refresh the database in the Object Explorer panel. This adds the Query Store folder to the panel.
8. 
   Customize when the Query Store aggregates new data. The Query Store will aggregate new stats every 60 minutes by default. Here's how to change the interval (using 15 minutes as an example):^{[4] X Research source}

   1. ALTER DATABASE
   2. SET QUERY_STORE (INTERVAL_LENGTH_MINUTES = 15);.