November 23, 2017 at 10:59 pm
Comments posted to this topic are about the item Index operations with max degree of parallelism value
November 23, 2017 at 11:02 pm
Good question thanks Junior.
...
November 24, 2017 at 1:44 am
Well, the traceflag doesn't control anything except parallelism of DBCC:
Disables parallel checking of objects by DBCC CHECKDB, DBCC CHECKFILEGROUP, and DBCC CHECKTABLE. By default, the degree of parallelism is automatically determined by the query processor. The maximum degree of parallelism is configured just like that of parallel queries. For more information, see Configure the max degree of parallelism Server Configuration Option
November 24, 2017 at 3:04 am
Rune Bivrin - Friday, November 24, 2017 1:44 AMWell, the traceflag doesn't control anything except parallelism of DBCC:Disables parallel checking of objects by DBCC CHECKDB, DBCC CHECKFILEGROUP, and DBCC CHECKTABLE. By default, the degree of parallelism is automatically determined by the query processor. The maximum degree of parallelism is configured just like that of parallel queries. For more information, see Configure the max degree of parallelism Server Configuration Option
concur
that beside, interesting question, thanks Junior
____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
November 24, 2017 at 4:01 am
Stewart "Arturius" Campbell - Friday, November 24, 2017 3:04 AMRune Bivrin - Friday, November 24, 2017 1:44 AMWell, the traceflag doesn't control anything except parallelism of DBCC:Disables parallel checking of objects by DBCC CHECKDB, DBCC CHECKFILEGROUP, and DBCC CHECKTABLE. By default, the degree of parallelism is automatically determined by the query processor. The maximum degree of parallelism is configured just like that of parallel queries. For more information, see Configure the max degree of parallelism Server Configuration Option
concur
that beside, interesting question, thanks Junior
Quite right, I just assumed that some text had been missed out, Junior?
...
November 27, 2017 at 11:49 am
How I know it's a Monday...
I looked up all four trace flags and found that only one of them is known, so figured logically that had to be the answer. So I went back to the QOTD to pick that option without paying much attention, and didn't realize they weren't listed in numerical order so selected the wrong option.
D'oh... time for more coffee!
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply