YOU ARE MANAGING AN OLTP DATABASE THAT MAKES HEAVY USE OF THE SQL...

15. You are managing an oLTP database that makes heavy use of the sQL

service Broker. You have identified that an activated stored procedure

is causing performance problems. You need to stop processing by the activated

stored procedure as quickly as possible. What action should you take?

A. Use the ALTer QUeUe command and set the MAX_QUeUe_

reADers setting to zero.

B. Use the ALTer QUeUe command and set the AcTivATioN

sTATUs = oFF.

A. Use the ALTer QUeUe command and set the sTATUs = oFF.

D. Use the ALTer QUeUe command and change the ProceDUre_

NAMe setting to an invalid stored procedure name.