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_request_stat_fact_1m

Table 25. pass_request_stat_fact_1m
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
session_id	smallint	No	No
login_time	bigint	No	No
database_name	character varying(256)	No	No
machine_name	character varying(256)	No	No
program_name	character varying(256)	No	No
username	character varying(256)	No	No
context_info	byte	No	No
command_name	character varying(256)	No	No
query_hash	character varying(16383)	No	No
sql_handle	character varying(16383)	No	No
erp1_name	character varying(256)	No	No
erp2_name	character varying(256)	No	No
erp3_name	character varying(256)	No	No
erp4_name	character varying(256)	No	No
erp5_name	character varying(256)	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	No	No
s_wait_log_synch	double precision	No	No
s_wait_log_other	double precision	No	No
s_wait_log_write	double precision	No	No
s_wait_log_buffer	double precision	No	No
s_wait_latch_general	double precision	No	No
s_wait_latch_savepoint	double precision	No	No
s_wait_xtp_tran	double precision	No	No
s_wait_xtp_proc	double precision	No	No
s_wait_xtp_log	double precision	No	No
s_wait_xtp_misc	double precision	No	No
object_id	character varying (256)	No	No
blck_session_id	smallint	No	No
blck_login_time	bigint	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 (256)	No	No
event_duration	double precision	No	No
instance_key	smallint	No	No
inserted_time	timestamp with time zone	No	No

pass_syntax_dim

Table 26. pass_syntax_dim
Name	Data type	Not Null?	Primary key?	Default	Comment
instance_key	smallint	No	No
inserted_time	timestamp with time zone	No	No
query_hash	character varying(16383)	No	No
sql_text	character varying(16383)	No	No
sql_short_text	character varying(256)	No	No

pass_unique_file_io_stat_fact

Table 27. pass_unique_file_io_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
database_name	character varying(256)	No	No
machine_name	character varying(256)	No	No
program_name	character varying(256)	No	No
username	character varying(256)	No	No
context_info	bytea	No	No
command_name	character varying(256)	No	No
query_hash	character varying(16383)	No	No
sql_handle	character varying(16383)	No	No
erp1_name	character varying(256)	No	No
erp2_name	character varying(256)	No	No
erp3_name	character varying(256)	No	No
erp4_name	character varying(256)	No	No
erp5_name	character varying(256)	No	No
file_name	character varying(256)	No	No
disk_name	character varying(256)	No	No
file_database_name	character varying(16383)	No	No
logical_file_name	character varying(16383)	No	No
total_io_mbytes	double precision	No	No
mb_read	double precision	No	No
mb_writen	double precision	No	No
mb_on_disk	double precision	No	No
total_wait_time	double precision	No	No
reads_waits_time	double precision	No	No
writes_waits_time	double precision	No	No
number_reads	double precision	No	No
number_writes	double precision	No	No
wait_io	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

pass_unique_lock_fact

Table 28. pass_unique_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
database_name	character varying(256)	No	No
machine_name	character varying(256)	No	No
program_name	character varying(256)	No	No
username	character varying(256)	No	No
context_info	bytea	No	No
command_name	character varying(256)	No	No
query_hash	character varying(16383)	No	No
sql_handle	character varying(16383)	No	No
erp1_name	character varying(256)	No	No
erp2_name	character varying(256)	No	No
erp3_name	character varying(256)	No	No
erp4_name	character varying(256)	No	No
erp5_name	character varying(256)	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

Seleziona il prodotto:

Per una maggiore efficacia, compilare l'Obiettivo della chat:

Soluzioni consigliate per il problema

Foglight for SQL Server 5.7.5.41 - PI Schema Reference Guide

pass_request_stat_fact_1m

pass_syntax_dim

pass_unique_file_io_stat_fact

pass_unique_lock_fact