YOU HAVE A SQL SERVICE BROKER APPLICATION THAT YOU WISH TO INCREAS...

20. You have a SQL Service Broker application that you wish to increase the

performance when receiving messages. What changes should you make?

A. Change the receiving code to load the data into a table, increasing the

number of messages being received at one time by increasing the value of

the TOP parameter.

B. Change the sending code to send more than one message in the same

conversation. Change the receiving code to load the data into a table,

increasing the number of messages being received at one time by

increasing the value of the TOP parameter.

C. Change the sending code to send more than one message in the same

conversation.

D. Increase the number of activated procedures that can run at any one time.

Answer B is the correct answer. You have to change both the sending code

and the receiving code to increase this performance. Increasing the number of

activated procedures will not increase the performance of the RECEIVE

command so that is not a good solution.

Chapter 13: Performance Tuning