You need to identify the purpose of each Dynamic Management Views (DMVs)

DRAG DROP
You administer a Microsoft SQL Server 2008 R2 database instance.
You need to identify the purpose of each Dynamic Management Views (DMVs).

What should you do? (To answer, drag the appropriate purpose to the correct DMV in the
answer area. Each purpose may be used once, more than once, or not at all. Each DMV
may be used once or not at all. Additionally, you may need to drag the split bar between
panes or scroll to view content.)

DRAG DROP
You administer a Microsoft SQL Server 2008 R2 database instance.
You need to identify the purpose of each Dynamic Management Views (DMVs).

What should you do? (To answer, drag the appropriate purpose to the correct DMV in the
answer area. Each purpose may be used once, more than once, or not at all. Each DMV
may be used once or not at all. Additionally, you may need to drag the split bar between
panes or scroll to view content.)

Answer:

Explanation:
Note:
dm_io_virtual_file_stats Returns I/O statistics for data and log files. Syntax:
sys.dm_io_virtual_file_stats ( { database_id | NULL } , { file_id | NULL } )
dm_os_performance_counters Returns a row per performance counter maintained by the
server.
dm_exec_query_memory_grants Returns information about the queries that have acquired a
memory grant or that still require a memory grant to execute. Queries that do not have to
wait on a memory grant will not appear in this view.
Incorrect: dm_fts_memory_buffers Returns information about memory buffers belonging to a
specific memory pool that are used as part of a full-text crawl or a full-text crawl range.
Incorrect: dm_os_windows_info Returns one row that displays Windows operating system
version information.



Leave a Reply 0

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