What should you do to capture only those App1 actions in DB1 that have a response time of two seconds or more?

You use an order application named App1, which connects to a SQL Server 2005 database named DB1.

Because some actions take more than three seconds, users report slow performance when they use App1. You

want to identify those actions by using the Tuning template in SQL Server Profiler to trace the application.

You need to capture only those App1 actions in DB1 that have a response time of two seconds or more.

What should you do?

You use an order application named App1, which connects to a SQL Server 2005 database named DB1.

Because some actions take more than three seconds, users report slow performance when they use App1. You want to identify those actions by using the Tuning template in SQL Server Profiler to trace the application.

You need to capture only those App1 actions in DB1 that have a response time of two seconds or more.

What should you do?

A.
Add the ApplicationName column and create the following column filters.

B.
Add the ApplicationName column and create the following column filters.

C.
Add the CPU column and create the following column filters.

D.
Add the ApplicationName and CPU columns and create the following column filters.



Leave a Reply 0

Your email address will not be published. Required fields are marked *