70-465 · Question #79
You need to address the requirements for disc usage monitoring for the SQL Servers. What should you do?
The correct answer is B. You should configure a Dynamic Management View. To monitor disc usage for SQL Servers, Dynamic Management Views (DMVs) are the appropriate tool as they provide real-time performance and operational data directly from the server.
Question
Options
- AYou should configure disc quotas.
- BYou should configure a Dynamic Management View.
- CYou should configure alerts sent by the SQL Server Agent.
- DYou should configure a SQL Server Maintenance Plan.
How the community answered
(44 responses)- A2% (1)
- B75% (33)
- C16% (7)
- D7% (3)
Why each option
To monitor disc usage for SQL Servers, Dynamic Management Views (DMVs) are the appropriate tool as they provide real-time performance and operational data directly from the server.
Disc quotas are used to limit the amount of disk space a user or group can consume, acting as a preventative measure rather than a tool for monitoring ongoing disc usage.
Dynamic Management Views (DMVs) provide access to server state information, including disk I/O, file space usage, and other performance metrics crucial for monitoring how SQL Server interacts with its storage. By querying DMVs such as `sys.dm_io_virtual_file_stats` or `sys.dm_os_volume_stats`, administrators can gather detailed, real-time data on disk usage and performance for SQL Server databases and files.
SQL Server Agent alerts notify administrators about predefined conditions or events related to disc usage, but they do not provide the detailed, ongoing metrics required for direct disc usage monitoring.
SQL Server Maintenance Plans automate routine database maintenance tasks like backups and index rebuilds, but they are not designed for monitoring disc usage metrics.
Concept tested: SQL Server performance monitoring with DMVs
Source: https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-io-virtual-file-stats-transact-sql
Topics
Community Discussion
No community discussion yet for this question.