70-465 · Question #17
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 an
The correct answer is dynamic management view; SQL Trace. 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
Exhibit
Answer Area
Drag items
Correct arrangement
- dynamic management view
- SQL Trace
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.