지금 지원 담당자와 채팅
지원 담당자와 채팅

Foglight for SQL Server 5.7.5.41 - PI Schema Reference Guide

SQL PI Repository Schema SSAS SQL PI Repository Schema

SQL PI Repository Cold Backup Procedure

To perform a cold backup of the SQL PI Repository:
1
Deactivate the SPIRepository Agent.
2
Stop the Infobright™ process by double-clicking <foglight home> Infobright/Infobright-stop.
3
Back up the <foglight home>/Infobright/ib_data directory.

SSAS SQL PI Repository Schema

This section provides information about the SSAS SQL PI repository. For more information, see the following topics:

•
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

About the SSAS SQL PI repository

SQL PI allows you see enterprise-level performance at a glance. You can determine the root-cause of performance deviations and identify changes to your SSAS environment quickly and easily. The repository allows you to save historical data for up to three years, and allows you to see the changes made over the time.

Connecting to the SSAS SQL PI repository

SQL PI repository is based on a PostgreSQL® database (http://www.postgresql.org). Any Postgres database administration and development utility, such as pgAdmin (http://www.pgadmin.org), is sufficient to connect to the repository. In order to connect to the repository, you need the following information:

•
Repository host— determined during the initial installation, could be on the Foglight Management Server host.
•
Repository port— default port 5029
•
Repository database — msbi-GUID
•
Connection user and password — postgres/postgres

Your agent repository configuration can be found under the menu Administration > Agents > Agent Status > (agent_name)> Edit Properties. In the list of properties, search for the SQL PI properties:

•
SQL PI Repository host name
•
SQL PI Repository port
•
SQL PI Repository database

The default user and password is postgres.

관련 문서

The document was helpful.

평가 결과 선택

I easily found the information I needed.

평가 결과 선택