Azure Postgres16 Flexible Server: Connections spike at 9 am (CET+1)

Question

Azure Postgres16 Flexible Server: Connections spike at 9 am (CET+1)

Ronny Carlansson 20

I created a new Azure Postgres Flexible Server (ver 16). In Overview->Surveillance, I noticed a spike in connections at 9 am (CET+1). This is a new server with no databases or clients. Any idea what this is?

Ronny Carlansson 20 Reputation points

2024-03-07T09:30:09.7833333+00:00
Ronny Carlansson 20 Reputation points

2024-03-07T16:31:26.4866667+00:00

Hi,

It's a completely new Postgres 16 server with no changes, no database and no clients. Still, I can see connections spikes? It has to be internal system processes, maintenance tasks, or internal operations, but which?

Next to do is to add logging as you suggested. I now see that serverlogs has changed from single server (v10) to flexible server (v16). Few more steps to do..

Regards,
SSingh-MSFT 16,461 Reputation points Moderator

2024-03-08T06:11:02.36+00:00

Hi Ronny Carlansson •,

Thanks for the reply.

Did you try to change from Single to Flexible server?

For deep investigation of the spike, I would recommend you to raise support case.

Let us know if you face any issue in doing the same.

Thanks
SSingh-MSFT 16,461 Reputation points Moderator

2024-03-11T06:36:39.0033333+00:00

Hi Ronny Carlansson •,

We haven't heard back from you. In case you already found a solution, would you please share it here with the community? Otherwise, let us know and we will continue to engage with you on the issue.

Thanks

1 answer

Your answer

Ronny Carlansson 20 Reputation points

2024-03-07T09:30:09.7833333+00:00
Ronny Carlansson 20 Reputation points

2024-03-07T16:31:26.4866667+00:00

Hi,

It's a completely new Postgres 16 server with no changes, no database and no clients. Still, I can see connections spikes? It has to be internal system processes, maintenance tasks, or internal operations, but which?

Next to do is to add logging as you suggested. I now see that serverlogs has changed from single server (v10) to flexible server (v16). Few more steps to do..

Regards,
SSingh-MSFT 16,461 Reputation points Moderator

2024-03-08T06:11:02.36+00:00

Hi Ronny Carlansson •,

Thanks for the reply.

Did you try to change from Single to Flexible server?

For deep investigation of the spike, I would recommend you to raise support case.

Let us know if you face any issue in doing the same.

Thanks
SSingh-MSFT 16,461 Reputation points Moderator

2024-03-11T06:36:39.0033333+00:00

Hi Ronny Carlansson •,

We haven't heard back from you. In case you already found a solution, would you please share it here with the community? Otherwise, let us know and we will continue to engage with you on the issue.

Thanks

Answer 1

Hi Ronny Carlansson •,

Welcome to Microsoft Q&A forum.

As I understand, you have got connection spike for your Azure Database for PostgreSQL Flexible Server.

Could you please let us know the configuration of the Server?

Also, this could be due to internal system processes, maintenance tasks, or internal operations.

That default value for the max_connections server parameter is calculated when the instance of Azure Database for PostgreSQL Flexible Server is first provisioned, based on the SKU name selected for its compute. Any subsequent changes of SKU to the compute supporting that flexible server, won't have any effect on the currently set neither on the default value chosen for max_connections server parameter of that instance. Therefore it is recommended that, whenever you change the SKU assigned to an instance, you also adjust the currently set value for the max_connections parameter as per the values provided in the table above.

You can try to check more by https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/concepts-audit Audit logs.

Let us know if this helps. If not, we can further investigate.

Thanks

Share via

Azure Postgres16 Flexible Server: Connections spike at 9 am (CET+1)

1 answer

Your answer