Chatta subito con l'assistenza

Ottieni assistenza in tempo reale
Completa la registrazione

Accedi

Richiedi prezzo

Contatta il supporto vendite

VERSIONI DI PROVA GRATUITA

Foglight for SQL Server 5.7.5.41 - PI Schema Reference Guide

Table of Contents

SQL PI Repository Schema

About the SQL PI repository Connecting to the SQL PI repository Understanding Time Ranges and Data Intervals SQL Server Dimensions Collected Metrics

Schema Tables Samples queries General Tables Dimension Tables Performance Metric (Fact) Tables

Unique Combinations Instance Activity Sessions Activity

Change Tracking Data

Change Tracking Tables Change Tracking Snapshots Tables

Table Data dictionary

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_object_dim

Table 21. pass_object_dim
Name	Data type	Not Null?	Primary key?	Default	Comment
instance_key	smallint	No	No
inserted_time	timestamp with time zone	No	No
object_id	character varying(256)	No	No
object_name	character varying(256)	No	No
object_database	character varying(256)	No	No
object_type	character varying(256)	No	No
object_owner	character varying(256)	No	No

pass_plan_dim

Table 22. pass_plan_dim
Name	Data type	Not Null?	Primary Key?	Default	Comment
instance_key	smallint	No	No
inserted_time	timestamp with time zone	No	No
resolving_time	timestamp with time zone	No	No
plan_handle	character varying(16383)	No	No
query_plan	character varying(16383)	No	No
plan_type	character varying(256)	No	No
plan_text_hash	integer	No	No
sql_handle	character varying(16383)	No	No

pass_plan_syntax_history

Table 23. pass_plan_syntax_history
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
username	character varying (16383)	No	No
database_name	character varying (256)	No	No
query_plan_hash	character varying (16383)	No	No
plan_handle	character varying (16383)	No	No

pass_request_lock_fact

Table 24. pass_request_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
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	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_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(16383)	No	No
event_duration	double precision	No	No

Related Documents

The document was helpful.

Seleziona valutazione

I easily found the information I needed.

Seleziona valutazione