RDS SQL Server improvements


Hello folks, I´m getting troubles with my DataBase SQL Server, I´m using a t2.micro and a basic query with inner join between 2 tables is taking 25sec for 250 rows. No WHERE clause is being used and I as far as I know it´s taking too long to response. Can anyone let me know what could I do to improve my DB server performance? Thanks in advance, Regards.

feita há 3 meses203 visualizações
2 Respostas

To improve the performance of your queries, I recommend first checking the execution plan and wait events during execution. RDS Performance Insights can provide insight into wait types. You can also reference the documentation below for troubleshooting guidance.

While the RDS OS is optimized, it still requires some resources. A T2.Micro instance has only 1 vCPU and 1GB of memory. After evaluating the current SQL Server metrics, you may want to consider upsizing the instance if more compute or memory resources are needed.

Blogs for reference: Troubleshoot slow-running queries in SQL Server: https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/performance/troubleshoot-slow-running-queries

Performance Insights metrics for DB instances: https://docs.aws.amazon.com/prescriptive-guidance/latest/amazon-rds-monitoring-alerting/db-instance-performance-insights.html

Best practices for configuring performance parameters for Amazon RDS for SQL Server: https://aws.amazon.com/blogs/database/best-practices-for-configuring-performance-parameters-for-amazon-rds-for-sql-server/

respondido há 3 meses
  • I'll check those docs, thanks a lot for your support. Anyway I would let you know that my DataBase server isn't always running slow. The same query which takes 25sec to response sometimes takes 0sec to give me the result. Seeing AWS metrics I can see that 7 connections and 30% CPU utilization are enough to get that 25sec delay, and it's really weird to see a server being affected by those values.


Question: Is there any possibility that AWS could set on 25sec the default value for response-time after some request rate on Data Base server? My question is based on all the tests that I've been performed over my server where I've received that response time on each query, I don't understand why is not changing it's always 25sec. PERFORMANCE OVERVIEW REQUESTS RESPONSE TIME

respondido há 3 meses

Você não está conectado. Fazer login para postar uma resposta.

Uma boa resposta responde claramente à pergunta, dá feedback construtivo e incentiva o crescimento profissional de quem perguntou.

Diretrizes para responder a perguntas