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.ColumnOperatorValueDurationGreater than or
equal2000ApplicationNameLikeApp1DatabaseNameLikeDB1

B.
Add the ApplicationName column and create the following column
filters.ColumnOperatorValueDurationGreater than or equal2ApplicationNameLikeApp1DatabaseNameLikeDB1

C.
Add the CPU column and create the following column filters.ColumnOperatorValueCPUGreater than or
equal2000TextDataLikeApp1DatabaseNameLikeDB1

D.
Add the ApplicationName and CPU columns and create the following column
filters.ColumnOperatorValueCPUGreater than or equal2ApplicationNameLikeApp1TextDataLikeDB1



Leave a Reply 0

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