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

pass_instance_dim

Table 17. pass_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
pass_version	character varying(256)	No	No
hw_type	character varying(256)	No	No
os_type	character varying(256)	No	No
os_release	character varying(256)	No	No
os_version	character varying(256)	No	No
db_version	character varying(256)	No	No
monitored	integer	No	No

pass_instance_lock_fact

Table 18. pass_instance_lock_fact
Name	Data type	Not Null?	Primary Key?	Default	Comment
instance_key	smallint	No	No
inserted_time	timestamp with time zone	No	No
sample_starttime	timestamp with time zone	No	No
sample_endtime	timestamp with time zone	No	No
sample_duration	bigint	No	No
object_id	character varying(256)	No	No
blck_client_machine_name	character varying(256)	No	No
blck_program_name	character varying(256)	No	No
blck_username	character varying(256)	No	No
blck_sql_handle	character varying(16383)	No	No
event_duration	double precision	No	No
lock_tree_id	bigint	No	No

pass_instance_stat_fact

Table 19. pass_instance_stat_fact
Name	Data type	Not Null?	Primary Key?	Default	Comment
instance_key	smallint	No	No
inserted_time	timestamp with time zone	No	No
sample_starttime	timestamp with time zone	No	No
sample_endtime	timestamp with time zone	No	No
sample_duration	bigint	No	No
physical_reads	double precision	No	No
logical_reads	double precision	No	No
num_executions	double precision	No	No
row_count	double precision	No	No
writes	double precision	No	No
cpu_time	double precision	No	No
active_time	double precision	No	No
elapsed_time	double precision	No	No
granted_query_memory	double precision	No	No
degree_of_parallelism	double precision	No	No
tempdb_io	double precision	No	No
tempdb_gam_wait	double precision	No	No
tempdb_sgam_wait	double precision	No	No
tempdb_pfs_wait	double precision	No	No
wait_log	double precision	No	No
wait_remote_provider	double precision	No	No
wait_lock	double precision	No	No
wait_latch	double precision	No	No
wait_network	double precision	No	No
wait_io	double precision	No	No
wait_other	double precision	No	No
wait_xtp	double precision	No	No
wait_for_cpu	double precision	No	No
wait_idle	double precision	No	No
wait_clr	double precision	No	No
wait_memory	double precision	No	No
s_wait_lock_shared	double precision	No	No
s_wait_lock_exclusive	double precision	No	No
s_wait_lock_bulk_update	double precision	No	No
s_wait_lock_schema	double precision	No	No
s_wait_lock_update	double precision	No	No
s_wait_lock_intent	double precision	No	No
s_wait_network_io	double precision	No	No
s_wait_network_mirror	double precision	No	No
s_wait_network_ipc	double precision	No	No
s_wait_network_http	double precision	No	No
s_wait_other_hosted_comp	double precision	No	No
s_wait_other_external_proc	double precision	No	No
s_wait_other_db_replicate	double precision	No	No
s_wait_other_service_broker	double precision	No	No
s_wait_other_misc	double precision	No	No
s_wait_other_fulltext	double precision	No	No
s_wait_parallel_coordination	double precision	No	No
s_wait_other_backup	double precision	No	No
s_wait_other_sync_task	double precision	No	No
s_wait_cursor_synchronization	double precision	No	No
s_wait_other_hadr	double precision	No	No
s_wait_other_deferred_task	double precision	No	No
s_wait_io_completion	double precision	No	No
s_wait_io_bulk_load	double precision	No	No
s_wait_io_data_page	double precision	No	No
s_wait_latch_buffer	double precision	No	No
s_wait_remote_dist_tran	double precision	No	No
s_wait_remote_oledb	double precision
s_wait_log_synch	double precision
s_wait_log_other	double precision
s_wait_log_write	double precision
s_wait_log_buffer	double precision
s_wait_latch_general	double precision
s_wait_latch_savepoint	double precision
s_wait_xtp_tran	double precision
s_wait_xtp_proc	double precision	No	No
s_wait_xtp_log	double precision	No	No
s_wait_xtp_misc	double precision	No	No

pass_instance_wevent_fact

Table 20. pass_instance_wevent_fact
Name	Data type	Not Null?	Primary Key?	Default	Comment
instance_key	smallint	No	No
inserted_time	timestamp with time zone	No	No
sample_starttime	timestamp with time zone	No	No
sample_endtime	timestamp with time zone	No	No
sample_duration	bigint	No	No
file_id	integer	No	No
file_database_id	smallint	No	No
wait_event_name	character varying(256)	No	No
category_name	character varying(256)	No	No
sub_category_name	character varying(256)	No	No
event_duration	double precision	No	No

Please select your product:

To serve you better, please complete the Purpose of your Chat:

Recommended Solutions for Your Problem

Foglight for SQL Server 5.7.5.41 - PI Schema Reference Guide

pass_instance_dim

pass_instance_lock_fact

pass_instance_stat_fact

pass_instance_wevent_fact