Monitoring the PostGreSQL on Azure

eG Enterprise provides a special-purpose monitoring model for the PostGreSQL on Azure.

Figure 1 : Layer model of the PostgreSQL on Azure

Each layer of Figure 1 is mapped to a variety of tests pertaining to the PostGreSQL Service, PostGreSQL Server, PostGreSQL Tablespaces, PostGreSQL I/O and PostGreSQL Azure Infrastructure layers. Since the tests pertaining to thePostGreSQL Service, PostGreSQL Server, PostGreSQL Tablespaces, and PostGreSQL I/O layers are similar PostgreSQL monitoring model; they have already been discussed in the Monitoring PostgreSQL section, the sections to come will discuss the tests associated with the PostGreSQL Azure Infrastructure layer alone. The tests mapped to this layer track the CPU usage, memory utilization, network traffic, database connections, and storage of the target database. Using the measures reported by these tests, administrators can find quick and accurate answers to the following performance queries:

• What is the current status of the target database?

• Is the percentage CPU utilized by the target database to process the tasks too high?

• Is the percentage of memory utilization too high?

• Is the percentage of storage utilized by the target database too high? If so, then what is the amount of used and available storage?

• Are there too many connections on the target database?

• Are there too many connection failures?

• Does the target database optimally utilize server log storage?

• Is the replication lag time of the replica server too high?

• Is the target database experiencing too much network traffic?

• Is the database excessively consuming I/O?