PATROL for PostgreSQL Database overview
As an administrator, you must ensure that the infrastructure is always up and running with maximum efficiency. BMC Helix Operations Management and TrueSight Operations Management help you achieve this goal by providing tools to monitor your environment. You need to collect data about your environment to be able to understand its health. For example, you are monitoring PostgreSQL database, to ensure that it is up and running all the time, you collect metrics that inform you about the health of your database. By monitoring this information, you will be able to proactively resolve an issue even before it occurs.
PATROL Agent and knowledge modules (KMs) are used to collect data in BMC Helix Operations Management and TrueSight Operations Management. A KM is a data collector that also contains monitoring logic. PATROL Agent provides infrastructure to KMs to collect data.
The following image shows how PATROL Agent and KMs help BMC Helix Operations Management in collecting data for monitoring:
After you install KMs and PATROL Agent, you configure monitor policies. When these policies are enabled, data collection starts. The collected data is shown on the Devices page in BMC Helix Operations Management and TrueSight Operations Management.
PATROL for PostgreSQL enables you to:
- Monitor PostgreSQL database availability
- Monitor availability and performance of database resources
As an administrator, you want to track the PostreSQL database cache size. It will help you to ensure that all transactions are alloted cache and no transaction has to wait. You collect health and availability metrics of your PostgreSQL database by using PATROL Agent and PATROL for PostgreSQL. You are collecting the Database cache usage attribute. You set up an alram policy that will alert you when the threshold value is crossed. If the threshold is crossed, an event is generated in BMC Helix Operations Management or TrueSight Operations Management. You can also view the Database cache usage graph.
As an administrator, you want to monitor database connections to ensure minimum waiting time to get a lock. You monitor how many connections are made to the database and how many database elements are locked at one time, or are waiting to get a lock.
You are collecting data in the Number of connections, Number of elements waiting to get a Lock, or Number of locked elements attributes. You configure an alarm policy that will alert you when the threshold value for any of these attributes is crossed. For instance, if the number of connections surpasses the threshold set for it, an event is generated in BMC Helix Operations Management or TrueSight Operations Management. You can also view the Number of connections graph.
Product roles
The main user role for the KM is Administrator. The following image shows your product goals:
Learn more
Data collection is a product goal for BMC Helix Operations Management and TrueSight Operations Management. For information about complete data collection and what you can do with the collected data, see BMC Helix Operations Management and TrueSight Operations Management documentation.
For information about the metadata of attributes that the KM collects, see
Parameter Reference Database
.
BMC bundles all the KMs and PATROL Agent in a repository that is updated periodically in BHOM tenants. TrueSight Operations Management users can download it from the Electronic Product Distribution website. For more information about the list of KMs that BMC provides and other details about the repository, see
Repository
.
To learn more about PATROL Agents, see PATROL Agent documentation. Separate documentation is available for PATROL Agent (which is applicable for TrueSight Operations Management) and PATROL Agent for BMC Helix Operations Management.
As an administrator, the documentation for PATROL for PostgreSQL helps you install the KM and configure it to start data collection. The following sections are recommended for you:
Comments
Log in or register to comment.