How to configure the app insight in postgressql server in azure as well as with sql db server in azure ?

Question

HI,

I just wanted to know how to configure the app insight in postgressql server in azure as well as with sql db server in azure ? Does MS supports app insight for both DB server's ? I am not find any details in web pages .

Answer 1

Hello @amit devi

Thank you for posting in Q & A forum.

Azure Database for PostgreSQL provides various metrics that give insight into the behavior of the resources supporting the PostgreSQL server. Each metric is emitted at a one-minute frequency, and has up to 93 days of history.

You can configure alerts on the metrics. For step by step guidance, see How to set up alerts

These metrics are available for Azure Database for PostgreSQL:

Error

Failed Connections	connections_failed	Count	The number of established connections that failed.

Latency

Max Lag Across Replicas	pg_replica_log_delay_in_bytes	Bytes	The lag in bytes between the primary and the most-lagging replica. This metric is available on the primary server only.
Replica Lag	pg_replica_log_delay_in_seconds	Seconds	The time since the last replayed transaction. This metric is available for replica servers only.

Saturation

Backup Storage Used	backup_storage_used	Bytes	The amount of backup storage used. This metric represents the sum of storage consumed by all the full database backups, differential backups, and log backups retained based on the backup retention period set for the server. The frequency of the backups is service managed and explained in the concepts article. For geo-redundant storage, backup storage usage is twice that of the locally redundant storage.
CPU percent	cpu_percent	Percent	The percentage of CPU in use.
IO percent	io_consumption_percent	Percent	The percentage of IO in use. (Not applicable for Basic tier servers.)
Memory percent	memory_percent	Percent	The percentage of memory in use.
Server Log storage limit	serverlog_storage_limit	Bytes	The maximum server log storage for this server.
Server Log storage percent	serverlog_storage_percent	Percent	The percentage of server log storage used out of the server's maximum server log storage.
Server Log storage used	serverlog_storage_usage	Bytes	The amount of server log storage in use.
Storage limit	storage_limit	Bytes	The maximum storage for this server.
Storage percentage	storage_percent	Percent	The percentage of storage used out of the server's maximum.
Storage used	storage_used	Bytes	The amount of storage in use. The storage used by the service may include the database files, transaction logs, and the server logs.

Traffic

Active Connections	active_connections	Count	The number of active connections to the server.
Network Out	network_bytes_egress	Bytes	Network Out across active connections.
Network In	network_bytes_ingress	Bytes	Network In across active connections.

Azure SQL Database

1. Monitor your SQL deployments with SQL Insights (preview)
2. Monitoring and performance tuning in Azure SQL Database

---

If this answers your query, do click Accept Answer and Up-Vote for the same. And, if you have any further query do let us know.