We have a vendor application whose backend is on our sql2005 standard edition which is running on a virtual server. Regularly we get the following message: A transaction in session <sessionid> has been running for <minutes>... The minutes go into the thousands which translates to days.
When i double click on the transaction I always get 'FETCH API_CURSOR0000000000######'
I asked the vendor and his explanation was "The Web Server and Application Server will both connect and stay connected to the database'"
the net address of the particular transaction is not always the same and is not always the web server or app server
Does anybody else experience anything like this? is this normal?
thank you in advance for any suggestions or references to reading material on this.