March 27, 2024 at 1:13 pm
I have a situation where our application has sql timeouts set to 120 seconds. SQL Time Outs occur everyday. There is an error log that furnishes the SQL that Timed Out. I run the SQL in SSMS and in most cases the SQL run within the 120 seconds so I'm wonder what the difference lies. Maybe the appliaction settings for SQL within the Application is different than what I'm running in SSMS. I've also checked to see if there is locking/blocking/deadlocks and I very rarely see this. Almost all of the queries are queries that reference Views.
Any suggestions would be greatly appreciated.
March 27, 2024 at 1:47 pm
Maybe the application settings for SQL within the Application is different than what I'm running in SSMS
That was my first thought. You should check this.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply