Skip to content

Instantly share code, notes, and snippets.

@DataSic
Last active December 18, 2017 22:06
Show Gist options
  • Select an option

  • Save DataSic/2780bc5142f96b21dd7babff1dd22c2e to your computer and use it in GitHub Desktop.

Select an option

Save DataSic/2780bc5142f96b21dd7babff1dd22c2e to your computer and use it in GitHub Desktop.
QueryStore Wait Stats duplicates
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