The forum will be unavailable for maintenance at some point from Friday, April 13 at 19:00 EDT until Sunday, April 15 at 23:59 EDT. Downtime will be minimized but the exact timing is unknown.

How can I confirm that server option max_query_tasks is set to the desired value? I am using SA 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 -- the value that comes up with SET doesn't always match what I just entered with SET OPTION PUBLIC.max_query_tasks, so I would like another way to confirm the setting, or to be able to query it from within my applications.

asked 19 Nov '10, 20:14

SethKrieger's gravatar image

accept rate: 100%

edited 15 Mar '13, 18:30

Mark%20Culp's gravatar image

Mark Culp

Try this:

select "setting" 
from sysoptions 
where "option" = 'max_query_tasks' and "user_name" = 'public';

See more detailed info on this at this page on DCX:

permanent link

answered 19 Nov '10, 21:05

Chris%20Kleisath's gravatar image

Chris Kleisath
accept rate: 38%

Comment Text Removed

Perfect. Also thanks for the DCX link. I did not know it existed!

(20 Nov '10, 00:22) SethKrieger

Although there is much overlap between options and properties, they are two different things.

The max_query_tasks property is a connection property, not a server or database property.

The max_query_tasks option may be defined at the PUBLIC, user id and current connection levels (this contradicts the 11.0.1 Help which says only PUBLIC and current connection).

Here is some SQL code which may answer your question, as well as shedding light on the difference between option and property...

SET OPTION PUBLIC.max_query_tasks = '11';
SET OPTION DBA.max_query_tasks = '22';

-- Disconnect / reconnect as DBA.

SELECT CONNECTION_PROPERTY ( 'max_query_tasks' );




SET TEMPORARY OPTION max_query_tasks = '33';

SELECT USER_NAME ( SYSOPTION.user_id ) AS user_id,
 WHERE SYSOPTION."option" = 'max_query_tasks';

SELECT CONNECTION_PROPERTY ( 'max_query_tasks' );




permanent link

answered 19 Nov '10, 21:07

Breck%20Carter's gravatar image

Breck Carter
accept rate: 21%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:


question asked: 19 Nov '10, 20:14

question was seen: 1,915 times

last updated: 15 Mar '13, 18:30