Microsoft
70-465 · Question #38
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 queri
The correct answer is C. Query the sys.dm_io_virtual_file_stats dynamic management function.. sys.dm_io_virtual_file_stats Returns I/O statistics for data and log files.
Submitted by yuki_2020· Mar 5, 2026Design and implement database solutions for SQL Server
Question
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?
Options
- AQuery the sys.dm_os_tasks dynamic management view.
- BQuery the sys.dm_os_performance_counters dynamic management view.
- CQuery the sys.dm_io_virtual_file_stats dynamic management function.
- DExamine the Data File I/O pane in Activity Monitor.
How the community answered
(13 responses)- A15% (2)
- C77% (10)
- D8% (1)
Explanation
sys.dm_io_virtual_file_stats Returns I/O statistics for data and log files.
Topics
#performance monitoring#DMVs#I/O performance#database files
Community Discussion
No community discussion yet for this question.