立即与支持人员聊天
与支持团队交流

Foglight for SQL Server 5.7.5.41 - PI Schema Reference Guide

SQL PI Repository Schema SSAS SQL PI Repository Schema

Change Tracking Snapshots Tables

•
This table holds the database constraints snapshot to compare against: pass_ct_constraints_state
•
This table holds the database properties snapshot to compare against: pass_ct_database_properties_state
•
This table holds the database disks snapshot to compare against: pass_ct_disks_state
•
This table holds the database file groups snapshot to compare against: pass_ct_file_group_state
•
This table holds the database files snapshot to compare against: pass_ct_files_state
•
This table holds the database network interface snapshot to compare against: pass_ct_network_interface_state
•
This table holds the database partitions snapshot to compare against: pass_ct_partitions_state
•
This table holds the database space allocation snapshot to compare against: pass_ct_swap_space_allocation_state
•
This table holds the database user account snapshot to compare against: pass_ct_user_account_state
•
This table holds the database version info snapshot to compare against: pass_ct_version_info_state

Table Data dictionary

 

Table 2. List of table names
Table Names

pa_repository

pass_batch_dim

pass_batch_dim_1m_<YYYYMMDD>0000

pass_batch_dim_1m_<YYYYMMDD>0600

pass_batch_dim_1m_<YYYYMMDD>1200

pass_batch_dim_1m_<YYYYMMDD>1800

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_dim_lock_fact_15m

pass_dim_lock_fact_1d

pass_dim_lock_fact_1h

pass_dim_lock_fact_1m_<YYYYMMDD>0000

pass_dim_lock_fact_1m_<YYYYMMDD>0600

pass_dim_lock_fact_1m_<YYYYMMDD>1200

pass_dim_lock_fact_1m_<YYYYMMDD>1800

pass_dim_lock_fact_1w

pass_dim_lock_fact_6h

pass_dim_stat_fact_15m

pass_dim_stat_fact_1d

pass_dim_stat_fact_1h

pass_dim_stat_fact_1m_<YYYYMMDD>0000

pass_dim_stat_fact_1m_<YYYYMMDD>0600

pass_dim_stat_fact_1m_<YYYYMMDD>1200

pass_dim_stat_fact_1m_<YYYYMMDD>1800

pass_dim_stat_fact_1w

pass_dim_stat_fact_6h

pass_dim_wevent_fact_15m

pass_dim_wevent_fact_1d

pass_dim_wevent_fact_1h

pass_dim_wevent_fact_1m_<YYYYMMDD>0000

pass_dim_wevent_fact_1m_<YYYYMMDD>0600

pass_dim_wevent_fact_1m_<YYYYMMDD>1200

pass_dim_wevent_fact_1m_<YYYYMMDD>1800

pass_dim_wevent_fact_1w

pass_dim_wevent_fact_6h

pass_file_dim

pass_general_config

pass_instance_dim

pass_instance_lock_fact_15m

pass_instance_lock_fact_1d

pass_instance_lock_fact_1h

pass_instance_lock_fact_1m

pass_instance_lock_fact_1w

pass_instance_lock_fact_6h

pass_instance_stat_fact_15m

pass_instance_stat_fact_1d

pass_instance_stat_fact_1h

pass_instance_stat_fact_1m

pass_instance_stat_fact_1w

pass_instance_stat_fact_6h

pass_instance_wevent_fact_15m

pass_instance_wevent_fact_1d

pass_instance_wevent_fact_1h

pass_instance_wevent_fact_1m

pass_instance_wevent_fact_1w

pass_instance_wevent_fact_6h

pass_object_dim

pass_object_dim_1m_<YYYYMMDD>0000

pass_object_dim_1m_<YYYYMMDD>0600

pass_object_dim_1m_<YYYYMMDD>1200

pass_object_dim_1m_<YYYYMMDD>1800

pass_plan_dim

pass_plan_dim_1m_<YYYYMMDD>0000

pass_plan_dim_1m_<YYYYMMDD>0600

pass_plan_dim_1m_<YYYYMMDD>1200

pass_plan_dim_1m_<YYYYMMDD>1800

pass_plan_syntax_history

pass_request_lock_fact_15m

pass_request_lock_fact_1d

pass_request_lock_fact_1h

pass_request_lock_fact_1m_<YYYYMMDD>0000

pass_request_lock_fact_1m_<YYYYMMDD>0600

pass_request_lock_fact_1m_<YYYYMMDD>1200

pass_request_lock_fact_1m_<YYYYMMDD>1800

pass_request_lock_fact_1w

pass_request_lock_fact_6h

pass_request_stat_fact_15m

pass_request_stat_fact_1d

pass_request_stat_fact_1h

pass_request_stat_fact_1m_<YYYYMMDD>0000

pass_request_stat_fact_1m_<YYYYMMDD>0600

pass_request_stat_fact_1m_<YYYYMMDD>1200

pass_request_stat_fact_1m_<YYYYMMDD>1800

pass_request_stat_fact_1w

pass_request_stat_fact_6h

pass_syntax_dim

pass_syntax_dim_1m_<YYYYMMDD>0000

pass_syntax_dim_1m_<YYYYMMDD>0600

pass_syntax_dim_1m_<YYYYMMDD>1200

pass_syntax_dim_1m_<YYYYMMDD>1800

pass_unique_file_io_fact_15m

pass_unique_file_io_fact_1d

pass_unique_file_io_fact_1h

pass_unique_file_io_fact_1m_<YYYYMMDD>0000

pass_unique_file_io_fact_1m_<YYYYMMDD>0600

pass_unique_file_io_fact_1m_<YYYYMMDD>1200

pass_unique_file_io_fact_1m_<YYYYMMDD>1800

pass_unique_file_io_fact_1w

pass_unique_file_io_fact_6h

pass_unique_lock_fact_15m

pass_unique_lock_fact_1d

pass_unique_lock_fact_1h

pass_unique_lock_fact_1m_<YYYYMMDD>0000

pass_unique_lock_fact_1m_<YYYYMMDD>0600

pass_unique_lock_fact_1m_<YYYYMMDD>1200

pass_unique_lock_fact_1m_<YYYYMMDD>1800

pass_unique_lock_fact_1w

pass_unique_lock_fact_6h

pass_unique_object_io_fact_15m

pass_unique_object_io_fact_1d

pass_unique_object_io_fact_1h

pass_unique_object_io_fact_1m_<YYYYMMDD>0000

pass_unique_object_io_fact_1m_<YYYYMMDD>0600

pass_unique_object_io_fact_1m_<YYYYMMDD>1200

pass_unique_object_io_fact_1m_<YYYYMMDD>1800

pass_unique_object_io_fact_1w

pass_unique_object_io_fact_6h

pass_unique_stat_fact_15m

pass_unique_stat_fact_1d

pass_unique_stat_fact_1h

pass_unique_stat_fact_1m_<YYYYMMDD>0000

pass_unique_stat_fact_1m_<YYYYMMDD>0600

pass_unique_stat_fact_1m_<YYYYMMDD>1200

pass_unique_stat_fact_1m_<YYYYMMDD>1800

pass_unique_stat_fact_1w

pass_unique_stat_fact_6h

pass_unique_wevent_fact_15m

pass_unique_wevent_fact_1d

pass_unique_wevent_fact_1h

pass_unique_wevent_fact_1m_<YYYYMMDD>0000

pass_unique_wevent_fact_1m_<YYYYMMDD>0600

pass_unique_wevent_fact_1m_<YYYYMMDD>1200

pass_unique_wevent_fact_1m_<YYYYMMDD>1800

pass_unique_wevent_fact_1w

pass_unique_wevent_fact_6h

pass_wait_event_dim

For detailed information, see the following topics:

•
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

pass_batch_dim

 
Table 3. pass_batch_dim
Name
Data type
Not Null?
Primary Key?
Default
Comment

instance_key

Smallint

No

No

 

 

inserted_time

timestamp with time zone

No

No

 

 

sql_handle

character varying (16383)

No

No

 

 

batch_name

character varying (256)

No

No

 

 

batch_text

character varying (16383)

No

No

 

 

batch_short_text

character varying (256)

No

No

 

 

pass_change_tracking_item

 
Table 4. pass_change_tracking_item
Name
Data type
Not Null?
Primary Key?
Default
Comment

instance_key

Smallint

No

No

 

 

inserted_time

timestamp with time zone

No

No

 

 

category_main

character varying (16383)

No

No

 

 

category

character varying (16383)

No

No

 

 

change_type

character varying (16383)

No

No

 

 

ojbect_name_1

character varying (16383)

No

No

 

 

object_name_2

character varying (16383)

No

No

 

 

attribute

character varying (16383)

No

No

 

 

new_value

character varying (16383)

No

No

 

 

old_value

character varying (16383)

No

No

 

 

change_datetime

timestamp without time zone

No

No

 

 

change_by_user

character varying (16383)

No

No

 

 

change_by application

character varying (16383)

No

No

 

 

change_by_server

character varying (16383)

No

No

 

 

相关文档

The document was helpful.

选择评级

I easily found the information I needed.

选择评级