You must login or register to post a reply
Re: Multisequencing, but not for all
there a heap of subtleties, beginning from what SET ` install different applications, before, under what rights the request
Sets I from plans is launched pulled out with the help sys.dm_exec_plan_attributes. Anything criminal in them is not present. And here is how on the rights can depend? However, it has been noted that yesterday the request was serial, then became parallel, and then again serial. not on application depends.
And what sense has parameter "cost threshold for parallelism"? Value 5 is in meters? Kilograms?
ion-option [quote =] Cost represents the prospective expenses necessary for performance of the serial plan in a certain configuration of the equipment (it not a time unit).
https://technet.microsoft.com/ru-ru/library/ms188603 (v=sql.105).aspx [quote =] In a following example the cost threshold for parallelism in 10 seconds is installed.
I had suspicions that it StatementSubTreeCost after which the server starts to make parallel plans.