Captured information about waits is stored in the sys.query_store_wait_stats system catalog view. To check the output of this view, you will create two connections and execute two queries simultaneously. Before that, ensure that Query Store is enabled and empty by running these statements from previous sections:
USE WideWorldImporters;GOALTER DATABASE WideWorldImporters SET QUERY_STORE CLEAR;ALTER DATABASE WideWorldImporters SET QUER_STORE = OFF;GOALTER DATABASE WideWorldImporters SET QUERY_STORE = ON ( OPERATION_MODE = READ_WRITE, INTERVAL_LENGTH_MINUTES = 1 ); GO
To see how Query Store captures waits, you need to open two connections to a SQL Server 2017 instance. In the first connection, you need ...
