Last active
December 18, 2017 22:06
-
-
Save DataSic/2780bc5142f96b21dd7babff1dd22c2e to your computer and use it in GitHub Desktop.
QueryStore Wait Stats duplicates
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| USE [WWI] | |
| GO | |
| ALTER DATABASE CURRENT SET QUERY_STORE (OPERATION_MODE = READ_WRITE, | |
| QUERY_CAPTURE_MODE = ALL, | |
| INTERVAL_LENGTH_MINUTES = 60) | |
| ALTER DATABASE CURRENT SET QUERY_STORE CLEAR; | |
| GO | |
| SELECT * | |
| FROM [Sales].[CustomerTransactions] | |
| ORDER BY [TaxAmount] DESC | |
| OPTION(MAXDOP 1); | |
| EXEC sp_query_store_flush_db; | |
| GO | |
| SELECT * | |
| FROM [Sales].[CustomerTransactions] | |
| ORDER BY [TaxAmount] DESC | |
| OPTION(MAXDOP 1); | |
| GO 2 | |
| SELECT * | |
| FROM sys.query_store_wait_stats |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment