Why is my Sqlserver so slow??

I'm using Rails 8 with
gem "activerecord-sqlserver-adapter", "~> 8.0", ">= 8.0.1"
gem 'tiny_tds', '~> 3.0.0',

I have have a postgres db on Render and my company has s Sqlerver db on Azure. Any thoughts on why i would get this from Sqlserver:
10:11:07 web.1 | JobScopeTaskTime Load (40.5ms) SELECT [job_scope_task_times].* FROM [job_scope_task_times] WHERE [job_scope_task_times].[job_scope_task_id] = 436 /action='show',application='Hme',controller='job_scopes'/

and this form Postgres:
10:15:08 web.1 | JobScopeTaskTime Load (0.1ms) SELECT "job_scope_task_times".* FROM "job_scope_task_times" WHERE "job_scope_task_times"."job_scope_task_id" = 188 /action='show',application='Hme',controller='job_scopes'/

That's 40ms for Sqlserver and 0.1ms for PG. The application is essentially useless when run with my companies Azure database. I do know that it is a S0 tier sql database and a Pro-4gb tier PG database on Render. They should be similar in 'power'.