QueryStoreOptionKind QueryStoreOptionKind QueryStoreOptionKind Enum

Definition

The possible Query Store Options under 'ALTER DATABASE d1 SET QUERY_STORE = (...)'

public enum QueryStoreOptionKind
type QueryStoreOptionKind = 
Public Enum QueryStoreOptionKind
Inheritance
QueryStoreOptionKindQueryStoreOptionKindQueryStoreOptionKind

Fields

Current_Storage_Size_MB Current_Storage_Size_MB Current_Storage_Size_MB 5
Desired_State Desired_State Desired_State 0
Flush_Interval_Seconds Flush_Interval_Seconds Flush_Interval_Seconds 3
Interval_Length_Minutes Interval_Length_Minutes Interval_Length_Minutes 4
Max_Plans_Per_Query Max_Plans_Per_Query Max_Plans_Per_Query 6
Query_Capture_Mode Query_Capture_Mode Query_Capture_Mode 1
Size_Based_Cleanup_Mode Size_Based_Cleanup_Mode Size_Based_Cleanup_Mode 2
Stale_Query_Threshold_Days Stale_Query_Threshold_Days Stale_Query_Threshold_Days 7

Applies to