Which dynamic management view should you use?

You have a database named DB1 that contains a table named Table1. Table1 has 1 billion rows.
You import 10 million rows of data into Table1.
After the import, users report that queries take longer than usual to execute.
You need to identify whether an out-of-date execution plan is causing the performance issue.
Which dynamic management view should you use?
A. sys.dm_xtp_transaction_stats
B. sys.dm_exec_input_buffer
C. sys.dm_db_index_operational_stats
D. sys.dm_db_stats_properties

microsoft-exams

Leave a Reply

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


The reCAPTCHA verification period has expired. Please reload the page.