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
Bạn đang xem 20. - THE REAL MTCS SQL SERVER 2008 EXAM 70 432 PREP KIT P162 PPTX