Sample Header Ad - 728x90

SQL Server Timeout only on production

0 votes
1 answer
629 views
I have an API endpoint that runs a query. For some reason, when I hit the production endpoint the query times out (after 2 minutes) but when I hit the same endpoint locally with my local environment connected to the same production DB the query runs in a couple of seconds. Is there a reason why this might happen? The issue is definitely not a connectivity issue because when I hit the same endpoint (on prod) with a different token it doesn't timeout. It's only some tokens that timeout on prod (yet when I run it locally connected to my prod DB it runs in a couple of seconds)
Asked by Moshe (67 rep)
May 5, 2022, 08:34 PM
Last activity: May 8, 2022, 05:03 AM