Hi guys, I am trying to get a quicker alert to myself when a connection is being blocked. To figure out how long it has been blocked for I was using the connection property WaitStartTime. However I have a minor issue, it seems like the time is in the future.
I put a lock on a table then ran my query.
The WaitStartTime gave the following timestamp: 2012-03-28 10:39:57.675 The current timestamp gave the following timestamp: 2012-03-28 10:32:58.714
Do note that the connection property LastReqTime matched the WaitStartTime and the connection property TransactionStartTime was an empty string.
Can someone please tell me why my WaitStartTime is in the future? FWIW I am running on a ASA12 engine. Thanks!