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.

질문됨 3달 전206회 조회
2개 답변

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/

답변함 3달 전
  • 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

답변함 3달 전

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인

관련 콘텐츠