Single Server and Flexible server performance

rv385 0

Our application has been hosted in the Azure Environment windows server and Database server. In the month of september, Database has been migrated from single server instance to Flexible server instance.

After the migration , we feel the performance of the application has been reduced.

We have increased the compute+storage of Flexible servers. But no luck.

Any solution for this?

1 answer

Sai Raghunadh M 1,290 Reputation points Microsoft Vendor

2024-11-12T10:12:05.42+00:00

Hi@ rv385,

Thanks for the question and using MS Q&A platform.

Since you've already upgraded your compute and storage resources with limited results, I suggest the following steps:

Optimize your database settings and indexes for the new Flexible Server setup.

Consider optimizing your application by using caching or reducing unnecessary database calls.

Double-check your database settings and maintenance tasks to make sure they're properly configured.

If performance issues continue, it might be a good idea to contact Azure Support for more detailed troubleshooting, as they can look into any potential issues specific to your environment after migration.

Hope this helps. Do let us know if you any further queries. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.
Please sign in to rate this answer.
rv385 0 Reputation points

2024-11-12T13:59:46.2166667+00:00

Hi Sai,

Thanks for your response.

Can you brief me about this point Double-check your database settings and maintenance tasks to make sure they're properly configured.

Thanks,

Ramya

Sai Raghunadh M 1,290 Reputation points Microsoft Vendor

2024-11-12T15:18:36.9933333+00:00

Hi@ rv385,

After migrating to Flexible Server, certain settings and configurations might need to be adjusted to better fit the new architecture and your application’s needs.

Connection Pooling: If you're not already using connection pooling, enabling it can significantly reduce overhead caused by opening and closing database connections repeatedly. For PostgreSQL, you can use PgBouncer for connection pooling.

PgBouncer helps in managing a large number of database connections efficiently, which can be particularly helpful in multi-tenant environments or when your application has high concurrency. Flexible Server can support connection pooling, but you should ensure it's configured properly.

rv385 0 Reputation points

2024-11-13T09:53:11.1233333+00:00

Hi @Sai Raghunadh M

I will try your suggestions and update here.

Thanks,

Ramya

Sai Raghunadh M 1,290 Reputation points Microsoft Vendor

2024-11-14T10:17:42.6033333+00:00

Hi@ rv385,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.

rv385 0 Reputation points

2024-11-15T07:46:49.1333333+00:00

Hi @Sai Raghunadh M ,

We have tried your suggestions but no luck. We are working to separate the issue. Will post the steps that we have followed to mitigate the issue once we implement it.

Thanks,

Ramya

Sai Raghunadh M 1,290 Reputation points Microsoft Vendor

2024-11-18T06:18:40.1266667+00:00

Hi@ rv385,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Single Server and Flexible server performance

1 answer

Your answer