Search code examples
amazon-web-servicesamazon-rds

We have a AWS RDS - SQL Server instance and it is unusably slow

We have a AWS RDS - SQL Server instance and it is unusably slow.

I just ran a simple index create on table with 180k records (small table) and it took ~9 minutes to complete!

create index YearIndex on LiveData(year)

It is also extremely slow in SSMS and Azure Data Studio when viewing the schema (tables/views... )

I'm new to AWS RDS, But I am suspecting there is some connectivity issue problem going on - I can't image this would ever be this slow.

Any suggestions on what to do?

Solution

  • I found that the micro tier couldn't handle a connection without locking up. It was 100% unusable even in the smallest use. I was able to get credentials and upgrade to db.t3.small on the instance and it is working like a normal database now.