Which sp_configure configuration option should you set?

You administer a SQL Server 2008 instance.
You need to configure the instance to use a single thread for queries that have an estimated
execution cost less than 3.
Which sp_configure configuration option should you set?

You administer a SQL Server 2008 instance.
You need to configure the instance to use a single thread for queries that have an estimated
execution cost less than 3.
Which sp_configure configuration option should you set?

A.
priority boost

B.
precompute rank

C.
max worker threads

D.
query governor cost limit

E.
cost threshold for parallelism



Leave a Reply 0

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