Determining current option setting for max_query_tasks -
11-19-2010
, 01:44 PM
How can I confirm that server option max_query_tasks is set to the
desired value? I am using SA 11.2472 and I don't see that setting when
I run sa_eng_properties, or SELECT PROPERTY('max_query_tasks'). It
does appear if I just do SET in DBISQL, but it seems that the value
retrieved by that method may be the connection value rather than the
global one? |