Chatta subito con l'assistenza

Ottieni assistenza in tempo reale
Completa la registrazione

Accedi

Richiedi prezzo

Contatta il supporto vendite

VERSIONI DI PROVA GRATUITA

Foglight for SQL Server 5.7.5.41 - PI Schema Reference Guide

Table of Contents

SQL PI Repository Schema

About the SQL PI repository Connecting to the SQL PI repository Understanding Time Ranges and Data Intervals SQL Server Dimensions Collected Metrics

Schema Tables Samples queries General Tables Dimension Tables Performance Metric (Fact) Tables

Unique Combinations Instance Activity Sessions Activity

Change Tracking Data

Change Tracking Tables Change Tracking Snapshots Tables

Table Data dictionary

pass_batch_dim pass_change_tracking_item pass_ct_constraints_state pass_ct_database_properties_state pass_ct_disks_state pass_ct_file_group_state pass_ct_files_state pass_ct_network_interface_state pass_ct_partitions_state pass_ct_swap_space_allocation_state pass_ct_user_account_state pass_ct_version_info_state pass_general_config pass_file_dim pass_instance_dim pass_instance_lock_fact pass_instance_stat_fact pass_instance_wevent_fact pass_object_dim pass_plan_dim pass_plan_syntax_history pass_request_lock_fact pass_request_stat_fact_1m pass_syntax_dim pass_unique_file_io_stat_fact pass_unique_lock_fact pass_unique_object_io_stat_fact pass_unique_stat_fact pass_unique_wevent_fact pass_wait_event_dim

SQL PI Repository Cold Backup Procedure

SSAS SQL PI Repository Schema

About the SSAS SQL PI repository Connecting to the SSAS SQL PI repository General tables Performance Metric (Fact) tables Dimension tables Change Tracking Data Table Data dictionary

pa_repository ssas_instance_dim ssas_general_config ssas_instance_stat_fact ssas_instance_object_fact ssas_instance_perfmon_fact ssas_unique_stat_fact ssas_unique_object_fact ssas_sessions_stat_fact ssas_sessions_object_fact ssas_sessions_lock_fact ssas_command_dim ssas_change_tracking_item ssas_ct_devices_state ssas_ct_disks_state ssas_ct_network_interface_state ssas_ct_schema_state ssas_ct_server_properties_state ssas_ct_resources_state

pass_ct_constraints_state

Table 5. pass_ct_constraints_state
Name	Data type	Not Null?	Primary Key?	Default	Comment
instance_key	Smallint	No	No
inserted_time	timestamp with time zone	No	No
dbname	character varying (16383)	No	No
table_name	character varying (16383)	No	No
constraint_schema	character varying (16383)	No	No
constraint_name	character varying (16383)	No	No
column_name	character varying (16383)	No	No
check_clause	character varying (16383)	No	No

pass_ct_database_properties_state

Table 6. pass_ct_database_properties_state
Name	Data type	Not Null?	Primary Key?	Default	Comment
instance_key	Smallint	No	No
inserted_time	timestamp with time zone	No	No
dbid	integer	No	No
db_name	character varying (16383)	No	No
ansi_null_default	integer	No	No
ansi_nulls	integer	No	No
ansi_padding	integer	No	No
ansi_warnings	integer	No	No
arithmetic_abort	integer	No	No
auto_close	integer	No	No
auto_create_statistics	integer	No	No
auto_shrink	integer	No	No
bulk_copy	integer	No	No
auto_update_statistics	integer	No	No
close_cursors_on_commit	integer	No	No
t_collation	character varying (16383)	No	No
fulltext	integer	No	No
local_cursors_default	integer	No	No
merge_published	integer	No	No
null_concat	integer	No	No
numeric_round_abort	integer	No	No
quoted_identifiers	integer	No	No
recovery	character varying (16383)	No	No
recursive_triggers	integer	No	No
t_status	character varying (16383)	No	No
subscribed	integer	No	No
page_verify_option_desc	character varying (16383)	No	No
trunc_log	integer	No	No
updateability	character varying (16383)	No	No
user_access	character varying (16383)	No	No

pass_ct_disks_state

Table 7. pass_ct_disks_state
Name	Data type	Not Null?	Primary Key?	Default	Comment
instance_key	smallint	No	No
inserted_time	timestamp with time zone	No	No
name	character varying(16383)	No	No
caption	character varying(16383)	No	No

pass_ct_file_group_state

Table 8. pass_ct_file_group_state
Name	Data type	Not Null?	Primary Key?	Default	Comment
instance_key	smallint	No	No
inserted_time	timestamp with time zone	No	No
db_name	character varying(16383)	No	No
file_group_name	character varying(16383)	No	No
dbid	integer	No	No
t_type	character varying(16383)	No	No
can_grow	character varying(16383)	No	No
is_read_only	integer	No	No

Related Documents

The document was helpful.

Seleziona valutazione

I easily found the information I needed.

Seleziona valutazione