You have a line-of-business application. The application generates reports based on data
from database v iews. U sers report that i t t akes a l ong t ime t o g enerate reports. Y ou r
un a S QL Server Profiler trace and discover that the application is generating many
blocking processes. You need to minimize the number of blocking processes. You must
achieve this goal without modifying the statements that the application sends to the server.
What should you do?
A.
Implement a database Service Broker.
B.
Create new database report views.
C.
Change the isolation level of the database.
D.
Change the isolation level of each query.