Hi We are having a severe issue with DEADLOCKS on our SQL DB .I mean DEADLOCKS of Data Base itself and not the application. what is the way to investigate it with AppDynamics ? Any suggestion or reference to any source of information on this theme w...
Thank you for the response but the article is not exactly relevant since I am looking for information on all the DEAD Locks actually happened in our MS SQL DB (not MYSQL DB) during particular period of time.And what is needed is to see in APP Dynami...
on MS SQL we use Last Elapsed time parameter for a query. So we retrieve it by running once in a minute a request for "Procedure X " Last Elapsed Time, recorded by the DB server itself,Probably Oracle has something similar