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…

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?