PrepAway - Latest Free Exam Questions & Answers

What should you do?

You are the administrator of a SQL Server 2005 computer named SQL1. The SQL Server transaction log files are stored on an 80-GB mirrored volume. New databases have been added to SQL1, and the 80-GB volume is 85 percent full. You do not currently have the ability to upgrade the volume or to add more disk space. You need to receive an alert if the unused disk space on the 80-GB volume falls below 5 GB. What should you do?

PrepAway - Latest Free Exam Questions & Answers

A.
In the Performance Logs and Alerts console, create an alert on the Logical Disk % Free Space counter.

B.
In SQL Server Agent, create an alert for the SQL Server: Databases Percent Log Used object.

C.
In the Wmic.exe utility, execute the Microsoft Windows Management Instrumentation (WMI) query SELECT FreeSpace FROM Win32_LogicalDisk.

D.
In SQL Server Management Studio, run the DBCC SQLPERF(LOGSPACE) command.

Explanation:
An alert on the Logical Disk % Free Space counter in the Performance Logs and Alerts console will provide you with the needed alert.


Leave a Reply