17. You are seeing performance problems on your SQL Server Service Broker
application. Messages are taking too long to be processed by the activated
stored procedure. The stored procedure itself is already fully optimized.
What can you do in order to decrease the amount of time it takes to process
messages with the least amount of effort?
A. Increase the number of parallel processes that are run automatically by
changing the MAX_QUEUE_READERS value via the ALTER QUEUE
command.
B. Increase the number of parallel processes that are run automatically by the
receiving service by changing the MAX_QUEUE_READERS value via
the ALTER SERVICE command.
C. Reduce the number of messages by sending more data per message.
D. Create more queues and send some of the messages to each of the queues.
The correct answer is A. You will want to use the ALTER QUEUE command
to increase the number of threads that are run in parallel. If you already have
set this to the maximum number of threads, then you could consider answer D,
but it is not likely that you will ever need to make this change.
Bạn đang xem 17. - THE REAL MTCS SQL SERVER 2008 EXAM 70 432 PREP KIT P162 PPTX