Question No: 15
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
Answer: E
70-432 Exam Dumps
No comments:
Post a Comment
Note: only a member of this blog may post a comment.