SQL connection timeout error with single query only in Azure webapp

Question

I'm working on an Azure web app. Using the entity framework to fetch the result. Everything is working fine. All queries are working as expected.

But the following one throwing the SQL connection timeout error. Most of the time it works fine but doesn't know when it starts giving the error and keep this error for more than 24 hours.

var logsCount = context.Logs.Where(l => l.StartDate >= startDate && l.StartDate <= endDate)
                            .GroupBy(l => l.KeywordID)
                            .ToDictionary(l => l.Key, l => l.Count());

I believe it's not an issue with the query because it keeps running fine for many days and starts giving problem suddenly.

It starts working fine itself. Not sure, why it's happening?

Can it be anything related to database or server only?

there can be many reasons related to unreliable network, number of connections,connection timeout parameter . — anoop-khandelwal
– anoop-khandelwal, Commented Sep 17, 2018 at 12:18

Alberto Morillo · Accepted Answer · 2018-09-17 12:28:23Z

1

Please try creating an index like the following using a tool like SQL Server Management Studio:

CREATE INDEX IX ON [YourTable] (StartDate, KeywordID) INCLUDE ( list all columns returned separated by comma )

answered Sep 17, 2018 at 12:28

Alberto Morillo

15.8k3 gold badges29 silver badges32 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SQL connection timeout error with single query only in Azure webapp

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related