which sp_configure configuration option should you set?

You are the administrator of your company network. You are in charge of a SQL Server 2008 instance which has to be configured to use a single thread for queries. The queries have an estimated execution cost less than 3. So which sp_configure configuration option should you set?

You are the administrator of your company network. You are in charge of a SQL Server 2008 instance which has to be configured to use a single thread for queries. The queries have an estimated execution cost less than 3. So which sp_configure configuration option should you set?

A.
You should set priority boost

B.
You should set precompute rank

C.
You should set max worker threads

D.
You should set query governor cost limit

E.
You should set cost threshold for parallelism



Leave a Reply 0

Your email address will not be published. Required fields are marked *