Foglight for SQL Server 5.7.5.41 - PI Schema Reference Guide

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

请选择您的产品：

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

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

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