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 DbDotoAdopter 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.
Disable batch updates. Modify the client application to perform a single update.
B.
Insert a random time interval between updates.
C.
Move the update method calls to a separate BackgroundWorker thread.
D.
Remove any limit on batch update sizes. Modify the client application to perform a single update.
Explanation:
Requirements several remote Windows client applications. The application frequently updates multiple rows in a database table by using a DbDataAdapter object.
(The DbDataAdapter class inherits from the DataAdapter class and helps a class implement a DataAdapter designed for use with a relational database.
An application does not create an instance of the DbDataAdapter interface directly, but creates an instance of a class that inherits IDbDataAdapter and DbDataAdapter.) The BackgroundWorker component is designed to allow you to execute time-consuming operations on a separate, dedicated thread. This allows you to run operations that take a lot of time, such as file downloads and database transactions asynchronously and allow the UI to remain responsive.