YOU ARE SEEING PERFORMANCE PROBLEMS ON YOUR SQL SERVER SERVICE BRO...

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 opti-

mized. 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.