October 5, 2005 at 8:09 am
Hi everyone. We run quite a large system with thousands of connections during peak times and we are currently trying to address the mirriad of problems that our application is facing, some may be SQL Server issues some may be other 3rd party systems that we intergrate with. In our troubleshooting someone asked me the following questions, and frankly I was unsure how to answer in a clear and consise way:
So what happens to connections and queries on the server when the application cancels the queries or shuts down rapidly? (FYI: The application has a 1 second timeout on queries too.) Can I (the DBA) tell how many queries have been issues and cancelled because the recordset / response was not sent/received within that 1 second?
October 5, 2005 at 1:42 pm
I would see the book online for that topic.
If there was a large transaction going on ( like altering a table in enterprise manager) it will be rolled back ( which can take a lot of time)
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply