Query Store for SQL Server 2019 by Tracy Boggiano & Grant Fritchey

Query Store for SQL Server 2019 by Tracy Boggiano & Grant Fritchey

Author:Tracy Boggiano & Grant Fritchey
Language: eng
Format: epub
ISBN: 9781484250044
Publisher: Apress


size_based_cleanup_mode_desc

nvarchar(60)

Description of size-based cleanup. Valid values are as follows:

OFF

AUTO

wait_stats_capture_mode

smallint

Tells Query Store to capture wait statistics or not. Valid values are as follows:

0 = OFF

1 = ON

Applies to SQL Server 2017 and up

wait_stats_capture_mode_desc

nvarchar(60)

Description of rather wait statistics are captured or not. Valid values are as follows:

OFF

ON (default)

Applies to SQL Server 2017 and up

actual_state_additional_info

nvarchar(8000)

Additional information on how Query Store ended up in the current state. Usually populated when in the state is not in the expected state



Download



Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.