PrepAway - Latest Free Exam Questions & Answers

Which of the following options describes a reason for querying this view?

You work as a database administrator at ABC.com.ABC.com is using a SQL Server 2008 R2
instance.
You been instructed to query the sys.dm_exec_query_stats view.

Which of the following options describes a reason for querying this view? (Choose all that apply.)

PrepAway - Latest Free Exam Questions & Answers

A.
To establish which common language runtime (CLR) queries are running extensively.

B.
To establish the total number of time-out errors since server startup.

C.
To establish the amount of queries waiting for grants to be satisfied.

D.
To establish the amount of active queries that have their grants satisfied.

Explanation:


Leave a Reply