Exam 70-764 topic 1 question 169 discussion

Actual exam question from Microsoft's 70-764

Question #: 169
Topic #: 1

You manage a SQL Server 2014 instance that contains a database named DB1.
Users report that some queries to DB1 take longer than expected.
Although most queries run in less than one second, some queries take up to 20 seconds to run. You need to view all of the performance statistics for each database file.
Which method should you use?

A. Query the sys.dm_os_tasks dynamic management view.
B. Query the sys.dm_os_performance_counters dynamic management view.
C. Query the sys.dm_io_virtual_file_stats dynamic management function.
D. Examine the Data File I/O pane in Activity Monitor.

Show Suggested Answer

Suggested Answer: C 🗳️
sys.dm_io_virtual_file_stats Returns I/O statistics for data and log files.

by TheSwedishGuy at Jan. 29, 2020, 3:12 p.m.

Comments

Submit Cancel

mrn0107

5 years, 5 months ago

strange, but this is correct...

upvoted 1 times

...

TheSwedishGuy

5 years, 5 months ago

Not sure all database files are virtual, so sys.dm_io_virtual_file_stats caught me by surprise. It does however have performance stats, such as i/o stalls.. https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-io-virtual-file-stats-transact-sql?view=sql-server-ver15

upvoted 2 times

...