Accepts a comma-delimited list of processor numbers and/or ranges. If the lower endpoint of a range is omitted, then it is
assumed to be zero. If the upper endpoint of a range is omitted, then it is assumed to be the highest CPU known to the operating
system. To specify all processors type - or 0-.
The -gta option allows you to specify which logical processors are used by the database server.
The database server might not use all of the specified logical processors in the following cases:
If one or more of the specified logical processors does not exist, or is offline.
If the license does not allow it.
If the set of logical processors specified by the -gta option exceeds the license limits, the server uses the lowest-numbered
logical processors specified by the -gta option up to, but not exceeding, the license limits. The database server does not
choose logical processors in the order listed by the -gta option. The server does not attempt to maximize concurrency within
the license limit and the specified -gta option.
If the set of logical processors specified by the -gta option does not match any online processors, the server acts as if
the -gta option was not specified and uses up to the licensed number of logical processors, starting at processor 0.
The -gta option cannot be used with the -gt or -gtc options.
While the database server is running, you can change which logical processors it uses with the ProcessorAffinity option of
the sa_server_option system procedure.