You are analyzing an application that uses Microsoft .NET Framework 4 and Microsoft SQL
Server 2008. The application is used to maintain an inventory database and is accessed
from several remote Windows client applications. The application frequently updates
multiple rows in a database table by using a DbDataAdapter object. Users report that the
application runs slowly during peak business hours. When large number of records are
changed by multiple users, you discover the following: • The CPU utilization of the client
applications is normal. • The network utilization increases slightly. • The CPU utilization of
the database server remains close to the normal average for a day. You need to resolve the
performance issue. What should you do?
A.
Insert a random time interval between updates.
B.
Remove any limit on batch update sizes. Modify the client application to perform a single
update.
C.
Disable batch updates. Modify the client application to perform a single update.
D.
Move the update method calls to a separate BackgroundWorker thread.