Class QueryStoreSchema.DataContext
- Namespace
- LinqToDB.Tools.DataProvider.SqlServer.Schemas
- Assembly
- linq2db.Tools.dll
public class QueryStoreSchema.DataContext- Inheritance
-
QueryStoreSchema.DataContext
- Extension Methods
Constructors
DataContext(IDataContext)
public DataContext(IDataContext dataContext)Parameters
dataContextIDataContext
Properties
DatabaseQueryStoreOptions
sys.database_query_store_options (Transact-SQL)
Applies to: √ SQL Server 2016 (13.x) and later √ Azure SQL Database √ Azure SQL Managed Instance √ Azure Synapse Analytics
Returns the Query Store options for this database.
Applies to: SQL Server (SQL Server 2016 (13.x) and later), SQL Database.
public ITable<QueryStoreSchema.DatabaseQueryStoreOption> DatabaseQueryStoreOptions { get; }Property Value
QueryContextSettings
sys.query_context_settings (Transact-SQL)
Applies to: √ SQL Server 2016 (13.x) and later √ Azure SQL Database √ Azure SQL Managed Instance √ Azure Synapse Analytics
Contains information about the semantics affecting context settings associated with a query. There are a number of context settings available in SQL Server that influence the query semantics (defining the correct result of the query). The same query text compiled under different settings may produce different results (depending on the underlying data).
public ITable<QueryStoreSchema.QueryContextSetting> QueryContextSettings { get; }Property Value
QueryStorePlans
sys.query_store_plan (Transact-SQL)
Applies to: √ SQL Server 2016 (13.x) and later √ Azure SQL Database √ Azure SQL Managed Instance √ Azure Synapse Analytics
Contains information about each execution plan associated with a query.
See sys.query_store_plan.
public ITable<QueryStoreSchema.QueryStorePlan> QueryStorePlans { get; }Property Value
QueryStoreQueries
sys.query_store_query (Transact-SQL)
Applies to: √ SQL Server 2016 (13.x) and later √ Azure SQL Database √ Azure SQL Managed Instance √ Azure Synapse Analytics
Contains information about the query and its associated overall aggregated runtime execution statistics.
public ITable<QueryStoreSchema.QueryStoreQuery> QueryStoreQueries { get; }Property Value
QueryStoreQueryHints
sys.query_store_query_hints (Transact-SQL)
Applies to: √ Azure SQL Database √ Azure SQL Managed Instance
Contains query hints from the Query Store hints (Preview) feature.
public ITable<QueryStoreSchema.QueryStoreQueryHint> QueryStoreQueryHints { get; }Property Value
QueryStoreQueryTexts
sys.query_store_query_text (Transact-SQL)
Applies to: √ SQL Server 2016 (13.x) and later √ Azure SQL Database √ Azure SQL Managed Instance √ Azure Synapse Analytics
Contains the Transact\-SQL text and the SQL handle of the query.
public ITable<QueryStoreSchema.QueryStoreQueryText> QueryStoreQueryTexts { get; }Property Value
QueryStoreRuntimeStats
sys.query_store_runtime_stats (Transact-SQL)
Applies to: √ SQL Server 2016 (13.x) and later √ Azure SQL Database √ Azure SQL Managed Instance √ Azure Synapse Analytics
Contains information about the runtime execution statistics information for the query.
public ITable<QueryStoreSchema.QueryStoreRuntimeStat> QueryStoreRuntimeStats { get; }Property Value
QueryStoreRuntimeStatsIntervals
sys.query_store_runtime_stats_interval (Transact-SQL)
Applies to: √ SQL Server 2016 (13.x) and later √ Azure SQL Database √ Azure SQL Managed Instance √ Azure Synapse Analytics
Contains information about the start and end time of each interval over which runtime execution statistics information for a query has been collected.
public ITable<QueryStoreSchema.QueryStoreRuntimeStatsInterval> QueryStoreRuntimeStatsIntervals { get; }Property Value
QueryStoreWaitStats
sys.query_store_wait_stats (Transact-SQL)
Applies to: √ SQL Server 2017 (14.x) and later √ Azure SQL Database
Contains information about the wait information for the query.
public ITable<QueryStoreSchema.QueryStoreWaitStat> QueryStoreWaitStats { get; }