70-465 · Question #17
70-465 Question #17: Real Exam Question with Answer & Explanation
Dynamic Management Views (DMVs) such as sys.dm_db_file_space_usage are the correct tool for monitoring tempdb free space, as they provide real-time metadata about database file space consumption without requiring event tracing. SQL Trace (specifically using the Deadlock Graph eve
Question
Drag and Drop Question You plan to deploy SQL Server 2014. Your company identifies the following monitoring requirements: - Tempdb must be monitored for insufficient free space. - Deadlocks must be analyzed by using Deadlock graphs. You need to identify which feature meets each monitoring requirement. Which features should you identify? To answer, drag the appropriate feature to the correct monitoring requirement in the answer area. Answer:
Explanation
Dynamic Management Views (DMVs) such as sys.dm_db_file_space_usage are the correct tool for monitoring tempdb free space, as they provide real-time metadata about database file space consumption without requiring event tracing. SQL Trace (specifically using the Deadlock Graph event in SQL Server Profiler or a server-side trace) is the correct tool for capturing and analyzing deadlock graphs, as it records the XML-based deadlock graph event that visually represents the resources and processes involved in a deadlock. Together, these two features satisfy both monitoring requirements outlined in the question.
Topics
Community Discussion
No community discussion yet for this question.