YOU ARE RESPONSIBLE FOR A SYSTEM THAT IS USED FOR BOTH ONLINE TRAN...

12. - THE REAL MTCS SQL SERVER 2008 EXAM 70 432 PREP KIT P9 PPTX
THE REAL MTCS SQL SERVER 2008 EXAM 70 432 PREP KIT P9 PPTX
12. You are responsible for a system that is used for both online transaction processing (OLTP) and reporting. When reports run on the server, the OLTP process slows way down. How can you allow reports to be run on the server and minimize impact to the OLTP processes?A. Use the Resource GovernorB. Use a DDL triggerC. Use a DML triggerD. Use processor affinity masks