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

ssas_instance_stat_fact

Table 42. ssas_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
active_sec	double precision	No	No
elapsed_sec	double precision	No	No
used_memory_kb	double precision	No	No
reads	double precision	No	No
writes	double precision	No	No
read_kb	double precision	No	No
write_kb	double precision	No	No
commands_executions	double precision	No	No
cpu_time_sec	double precision	No	No
io_wait_sec	double precision	No	No
memory_wait_sec	double precision	No	No
lock_wait_sec	double precision	No	No
lock_inactive_wait_sec	double precision	No	No
lock_read_wait_sec	double precision	No	No
lock_write_wait_sec	double precision	No	No
lock_commit_shared_wait_sec	double precision	No	No
lock_commit_exclusive_wait_sec	double precision	No	No
lock_commit_abort_wait_sec	double precision	No	No
lock_commit_in_progress_wait_sec	double precision	No	No
lock_invalid_wait_sec	double precision	No	No
remote_wait_sec	double precision	No	No
idle_wait_sec	double precision	No	No

ssas_instance_object_fact

Table 43. ssas_instance_object_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
object_id_short_text	character varying(256)	No	No
active_sec	double precision	No	No
reads	double precision	No	No
writes	double precision	No	No
read_kb	double precision	No	No
write_kb	double precision	No	No
rows_scanned	double precision	No	No
rows_returned	double precision	No	No
cpu_time_sec	double precision	No	No
io_wait_sec	double precision	No	No
lock_wait_sec	double precision	No	No
lock_inactive_wait_sec	double precision	No	No
lock_read_wait_sec	double precision	No	No
lock_write_wait_sec	double precision	No	No
lock_commit_shared_wait_sec	double precision	No	No
lock_commit_exclusive_wait_sec	double precision	No	No
lock_commit_abort_wait_sec	double precision	No	No
lock_commit_in_progress_wait_sec	double precision	No	No
lock_invalid_wait_sec	double precision	No	No
idle_wait_sec	double precision	No	No

ssas_instance_perfmon_fact

Table 44. ssas_instance_perfmon_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
available_bytes	double precision	No	No
cache_bytes	double precision	No	No
committed_bytes	double precision	No	No
system_processes	double precision	No	No
system_threads	double precision	No	No
events	double precision	No	No
mutexes	double precision	No	No
processes	double precision	No	No
sections	double precision	No	No
semaphores	double precision	No	No
threads	double precision	No	No
current_kb	double precision	No	No
total_direct_hits	double precision	No	No
total_misses	double precision	No	No
total_lookups	double precision	No	No
current_connections	double precision	No	No
current_user_sessions	double precision	No	No
total_requests	double precision	No	No
total_failures	double precision	No	No
logins_rate	double precision	No	No
current_models_processing	double precision	No	No
concurrent_dm_queries	double precision	No	No
total_queries	double precision	No	No
total_rows	double precision	No	No
current_locks	double precision	No	No
current_lock_waits	double precision	No	No
total_deadlocks_detected	double precision	No	No
processing_pool_idle_io_job_threads	double precision	No	No
processing_pool_busy_io_job_threads	double precision	No	No
processing_pool_idle_total_threads	double precision	No	No
processing_pool_busy_total_threads	double precision	No	No
query_pool_idle_threads	double precision	No	No
query_pool_busy_threads	double precision	No	No
query_pool_job_queue_length	double precision	No	No
cleaner_memory_kb	double precision	No	No
cleaner_memory_nonshrinkable_kb	double precision	No	No
cleaner_memory_shrinkable_kb	double precision	No	No
dimension_index_hash_files	double precision	No	No
dimension_property_files	double precision	No	No
dimension_string_files	double precision	No	No
fact_aggregation_files	double precision	No	No
fact_data_files	double precision	No	No
fact_string_files	double precision	No	No
filestore_kb	double precision	No	No
filestore_io_errors	double precision	No	No
memory_limit_high_kb	double precision	No	No
memory_limit_low_kb	double precision	No	No
memory_usage_kb	double precision	No	No
memory_size_bytes	double precision	No	No
current_partitions	double precision	No	No
total_partitions	double precision	No	No
total_rows_read	double precision	No	No
total_rows_written	double precision	No	No
total_bytes_sent	double precision	No	No
total_rows_sent	double precision	No	No
total_queries_answered	double precision	No	No
total_measure_group_queries	double precision	No	No
total_dimension_queries	double precision	No	No
queries_answered_rate	double precision	No	No
rows_sent_rate	double precision	No	No
number_of_calculation_covers	double precision	No	No
number_of_evictions_of_evaluation_nodes	double precision	No	No
total_cells_calculated	double precision	No	No

ssas_unique_stat_fact

Table 45. ssas_unique_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
user_name	character varying(256)	No	No
database_name	character varying(256)	No	No
host	character varying(256)	No	No
application	character varying(256)	No	No
command_hash	bigint	No	No
command_type	character varying(256)	No	No
active_sec	double precision	No	No
elapsed_sec	double precision	No	No
used_memory_kb	double precision	No	No
reads	double precision	No	No
writes	double precision	No	No
read_kb	double precision	No	No
write_kb	double precision	No	No
commands_executions	double precision	No	No
cpu_time_sec	double precision	No	No
io_wait_sec	double precision	No	No
memory_wait_sec	double precision	No	No
lock_wait_sec	double precision	No	No
lock_inactive_wait_sec	double precision	No	No
lock_read_wait_sec	double precision	No	No
lock_write_wait_sec	double precision	No	No
lock_commit_shared_wait_sec	double precision	No	No
lock_commit_exclusive_wait_sec	double precision	No	No
lock_commit_abort_wait_sec	double precision	No	No
lock_commit_in_progress_wait_sec	double precision	No	No
lock_invalid_wait_sec	double precision	No	No
remote_wait_sec	double precision	No	No
idle_wait_sec	double precision	No	No

请选择您的产品：

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

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

Foglight for SQL Server 5.7.5.41 - PI Schema Reference Guide

ssas_instance_stat_fact

ssas_instance_object_fact

ssas_instance_perfmon_fact

ssas_unique_stat_fact