PrepAway - Latest Free Exam Questions & Answers

Which action should you recommend?

You are an enterprise application developer. You are creating a financial application that includes a data access component. This component executes queries against a Microsoft SQL Server database. Application performance deteriorates as the volume of data in the database increases. You need to identify which database queries require the greatest time to execute. You need to minimize the impact on application performance while gathering this information. Which action should you recommend?

PrepAway - Latest Free Exam Questions & Answers

A.
Use common language runtime (CLR) Profiler to examine the runtime performance of the methods that execute the database queries.

B.
Use Ildsam.exe to examine the disassembled code of the methods that execute the database queries.

C.
Create and run a SQL Profiler trace to analyze the database queries.

D.
Use static analysis to examine the source code of the methods that execute the database queries.


Leave a Reply