I've recently upgraded my PIX 535 cluster from 7.2 to 8.0.4(32). Since the upgrade we have been experiencing blocking sessions on one of our DB servers and associated performance issues. I have checked the logs but I cannot see a message to state that sql inspection is the cause. I would expect to see something like
%ASA-6-302014: Teardown TCP connection...Flow closed by inspection
I have since turned off sql inspection and the problem has not reappeared.
Is SQL inspection likely to be the cause here and if so why didn't I see the associated messages in the syslog which is set to record informational events?