❔ Timeout Issue - (SQL Server & CSharp)
Hello guys,
So i have a huge amount of data on my database and i need to make a transaction using procedures with SQL Server and executing those commands through an C# Layer on my backend and sometimes due that high amount of storage data i often get timeout exceptions when doing those actions, i usually put the timeout value as 0 so it's not going to expire my transaction even it takes too long, but recently i tried putting a value like 120s and it solved my timing out issue but i dont get why it worked, is there anyone who can explain to me why it did work and if theres another method to solve these kinda of problems?
Thanks!
3 Replies
we need to see code to answer this
A common cause for "I changed something and now everything is fast again" I saw is that query plans got regenareted. Sometimes a query plan is not optimal . If your performance is bad again just drop the query plans and check if performance is better. If thats the case you can investigate further.
Was this issue resolved? If so, run
/close - otherwise I will mark this as stale and this post will be archived until there is new activity.