Foglight for SQL Server 5.7.5.41 - PI Schema Reference Guide

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

Table Data dictionary

Table 38. List of table names
Table Names
pa_repository
ssas_change_tracking_item
ssas_command_dim
ssas_command_dim_1m_YYYYMMHH0000
ssas_command_dim_1m_YYYYMMHH0600
ssas_command_dim_1m_YYYYMMHH1200
ssas_command_dim_1m_YYYYMMHH1800
ssas_ct_devices_state
ssas_ct_disks_state
ssas_ct_network_interface_state
ssas_ct_schema_state
ssas_ct_server_properties_state
ssas_ct_swap_space_allocation_state
ssas_general_config
ssas_instance_dim
ssas_instance_object_fact_15m
ssas_instance_object_fact_1d
ssas_instance_object_fact_1h
ssas_instance_object_fact_1m_YYYYMMHH0000
ssas_instance_object_fact_1m_YYYYMMHH0600
ssas_instance_object_fact_1m_YYYYMMHH1200
ssas_instance_object_fact_1m_YYYYMMHH1800
ssas_instance_object_fact_1w
ssas_instance_object_fact_6h
ssas_instance_perfmon_fact_15m
ssas_instance_perfmon_fact_1d
ssas_instance_perfmon_fact_1h
ssas_instance_perfmon_fact_1m_YYYYMMHH0000
ssas_instance_perfmon_fact_1m_YYYYMMHH0600
ssas_instance_perfmon_fact_1m_YYYYMMHH1200
ssas_instance_perfmon_fact_1m_YYYYMMHH1800
ssas_instance_perfmon_fact_1w
ssas_instance_perfmon_fact_6h
ssas_instance_stat_fact_15m
ssas_instance_stat_fact_1d
ssas_instance_stat_fact_1h
ssas_instance_stat_fact_1m_YYYYMMHH0000
ssas_instance_stat_fact_1m_YYYYMMHH0600
ssas_instance_stat_fact_1m_YYYYMMHH1200
ssas_instance_stat_fact_1m_YYYYMMHH1800
ssas_instance_stat_fact_1w
ssas_instance_stat_fact_6h
ssas_sessions_lock_fact_15m
ssas_sessions_lock_fact_1d
ssas_sessions_lock_fact_1h
ssas_sessions_lock_fact_1m_YYYYMMHH0000
ssas_sessions_lock_fact_1m_YYYYMMHH0600
ssas_sessions_lock_fact_1m_YYYYMMHH1200
ssas_sessions_lock_fact_1m_YYYYMMHH1800
ssas_sessions_lock_fact_1w
ssas_sessions_lock_fact_6h
ssas_sessions_object_fact_15m
ssas_sessions_object_fact_1d
ssas_sessions_object_fact_1h
ssas_sessions_object_fact_1m_YYYYMMHH0000
ssas_sessions_object_fact_1m_YYYYMMHH0600
ssas_sessions_object_fact_1m_YYYYMMHH1200
ssas_sessions_object_fact_1m_YYYYMMHH1800
ssas_sessions_object_fact_1w
ssas_sessions_object_fact_6h
ssas_sessions_stat_fact_15m
ssas_sessions_stat_fact_1d
ssas_sessions_stat_fact_1h
ssas_sessions_stat_fact_1m_YYYYMMHH0000
ssas_sessions_stat_fact_1m_YYYYMMHH0600
ssas_sessions_stat_fact_1m_YYYYMMHH1200
ssas_sessions_stat_fact_1m_YYYYMMHH1800
ssas_sessions_stat_fact_1w
ssas_sessions_stat_fact_6h
ssas_unique_object_fact_15m
ssas_unique_object_fact_1d
ssas_unique_object_fact_1h
ssas_unique_object_fact_1m_YYYYMMHH0000
ssas_unique_object_fact_1m_YYYYMMHH0600
ssas_unique_object_fact_1m_YYYYMMHH1200
ssas_unique_object_fact_1m_YYYYMMHH1800
ssas_unique_object_fact_1w
ssas_unique_object_fact_6h
ssas_unique_stat_fact_15m
ssas_unique_stat_fact_1d
ssas_unique_stat_fact_1h
ssas_unique_stat_fact_1m_YYYYMMHH0000
ssas_unique_stat_fact_1m_YYYYMMHH0600
ssas_unique_stat_fact_1m_YYYYMMHH1200
ssas_unique_stat_fact_1m_YYYYMMHH1800
ssas_unique_stat_fact_1w
ssas_unique_stat_fact_6h

For detailed information, see the following topics:

•

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

pa_repository

Table 39. pa_repository
Name	Data type	Not Null?	Primary Key?	Default	Comment
inserted_time	timestamp with time zone	No	No
build_version	character varying(256)	No	No
db_version	character varying(256)	No	No
schema_version	character varying(256)	No	No
is_in_upgrade	smallint	No	No

ssas_instance_dim

Table 40. ssas_instance_dim
Name	Data type	Not Null?	Primary Key?	Default	Comment
instance_key	smallint	No	No
inserted_time	timestamp with time zone	No	No
create_date	timestamp with time zone	No	No
updated_date	timestamp with time zone	No	No
instance_name	character varying(256)	No	No
host	character varying(256)	No	No
additional_info	character varying(16383)	No	No
monitored	integer	No	No
instance_version	character varying(256)	No	No
spi_version	character varying(256)	No	No
instance_configuration	character varying(16383)	No	No

ssas_general_config

Table 41. ssas_general_config
Name	Data type	Not Null?	Primary Key?	Default	Comment
instance_key	smallint	No	No
inserted_time	timestamp with time zone	No	No
property_name	character varying (256)	No	No
config_value	character varying (256)	No	No

请选择您的产品：

为向您提供更好的服务，请填写'Purpose of your Chat'（联系目的）：

针对您的问题建议的解决方案

Foglight for SQL Server 5.7.5.41 - PI Schema Reference Guide

Table Data dictionary

pa_repository

ssas_instance_dim

ssas_general_config