This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

Problem with connections to SQL Server in Google Cloud

Posted 2 weeks ago
mmunoz
Bronze 1
Bronze 1
Reply posted on --/--/---- --:-- AM

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.

1 1 97
Topic Labels
1 REPLY 1

Posted on --/--/---- --:-- AM
christianpaula
Staff
Reply posted on --/--/---- --:-- AM

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.