We have been experiencing a strange issue since we upgrade from ASA 9 to ASA 12 in November. Periodically the server freezes. By that I mean that all databases attached to the server are non-responsive.
When they come back, looking in the SQL Monitor shows that all connections on one of our production databases were locked on an certain query ( and it's different every time ).
Does anyone have any ideas on how I can trouble shoot this problem, or have you experienced anything similar.
asked 17 Apr '13, 11:10
We had the same problem when switching one of our customers to SA12. We opened a support case and had a lengthy discussion about this being an error or not. But that's another story.
In the end raising the minimum for the multi programming level to 10 ( -gnl 10) remedied the problem. The default for this setting is the number of logical cpus you have licensed and are available to the engine. This means that when there is a period of low activity the engine reduces the multi programming level down to e. g. a level of 2. If then 2 connections "suddenly" issue a long(er) running statement, the server didn't respond to any request for up to 60 seconds in our case. This "hangs" happened up to 2-3 times per hour and our customer was not "amused" to say the least. In my opinion this default is just too low, at least for our application, so we now always set this option to 10 on every server with "Dynamic tuning of the multiprogramming level" ( >= 12).