立即与支持人员聊天
与支持团队交流

Foglight for SQL Server 5.7.5.41 - PI Schema Reference Guide

SQL PI Repository Schema SSAS SQL PI Repository Schema

Instance Activity

•
These tables contain information about observed blocking lock scenarios at the instance level for a specific time period:
pass_instance_lock_fact_15m, pass_instance_lock_fact_1d, pass_instance_lock_fact_1h, pass_instance_lock_fact_1m, pass_instance_lock_fact_1w, pass_instance_lock_fact_6h
•
These tables contain performance metric data aggregated to the instance level for a specific time period:
pass_instance_stat_fact_15m, pass_instance_stat_fact_1d, pass_instance_stat_fact_1h, pass_instance_stat_fact_1m, pass_instance_stat_fact_1w, pass_instance_stat_fact_6h
•
These tables contain information about observed wait events at the instance-level for specific time periods:
pass_instance_wevent_fact_15m, pass_instance_wevent_fact_1d, pass_instance_wevent_fact_1h, pass_instance_wevent_fact_1m, pass_instance_wevent_fact_1w, pass_instance_wevent_fact_6h

Sessions Activity

•
These tables contain the sessions activity (SQL Server requests):
pass_request_stat_fact_1m_<YYYYMMDD>0000, pass_request_stat_fact_1m_<YYYYMMDD>0600, pass_request_stat_fact_1m_<YYYYMMDD>1200, pass_request_stat_fact_1m_<YYYYMMDD>1800
•
These tables contain the locks tree information:
pass_lock_tree_fact_15m, pass_lock_tree_fact_1d, pass_lock_tree_fact_1h, pass_lock_tree_fact_1m_<YYYYMMDD>0000, pass_lock_tree_fact_1m_<YYYYMMDD>0600, pass_lock_tree_fact_1m_<YYYYMMDD>1200, pass_lock_tree_fact_1m_<YYYYMMDD>1800, pass_lock_tree_fact_1w, pass_lock_tree_fact_6h

Change Tracking Data

For detailed information, see the following topics:

•
Change Tracking Tables
•
Change Tracking Snapshots Tables

Change Tracking Tables

This table contains the record of changes per type over time:

•
pass_change_tracking_item
相关文档

The document was helpful.

选择评级

I easily found the information I needed.

选择评级