Problem with connections to SQL Server in Google Cloud

[mmunoz]

I am experiencing a connection issue on my SQL Server on Google Cloud.
The number of connections reaches 200 per minute and then the database stops responding.
I have been investigating the problem, but have not been able to find the cause.

Instance type: 6 CPU, 10 GB Memory, 100 GB Storage
Region: us-central1-c
SQL Server Version: SQL Server 2019 Web CU24

Has anyone experienced a similar problem?
What recommendations can you give me to diagnose the problem?
What additional tools or resources can I use to solve the problem?

I appreciate in advance any help the community can give me to solve this problem.

[christianpaula · Accepted solution]

Hi @mmunoz,

Welcome to Google Cloud Community!

These might help you:

• Sudden connection spikes (200 per minute) suggest runaway connections or inefficient queries.
• Verify allowed network connections for your Cloud SQL instance.
• Analyze Cloud SQL logs to identify any patterns or problematic users.
• Identify long-running queries that might be consuming resources.
• Monitor resource usage (CPU, memory, disk) for your Cloud SQL instance.
• Consider scaling up your Cloud SQL instance if resources are maxed out.
• Refer to Google Cloud documentation for troubleshooting connection issues.