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.
Bạn đang xem 15. - THE REAL MTCS SQL SERVER 2008 EXAM 70/432 PREP KIT- P115 PPS