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

Explanation:

sys.dm_db_index_operational_stats dynamic management function provides us the currentlow-level I/O, locking, latching, and access method for each partition of the table. This information is really useful to troubleshoot SQL Server performance issues.

Reference: https://basitaalishan.com/2013/03/19/using-sys-dm_db_index_operational_stats-to-analyse-how-indexes-are-utilised/