Question

_____________ displays an estimate of the current amount of disk space used by a table.

(a) sp_lock

(b) sp_who

(c) sp_monitor

(d) sp_spaceused

The question was asked in a national level competition.

This intriguing question originated from Performance Monitoring in chapter Monitoring and Auditing of SQL Server

Answer 1

The correct answer is (d) sp_spaceused

For explanation: sp_spaceused displays the number of rows, disk space reserved, and disk space used by a table, indexed view, or Service Broker queue in the current database, or displays the disk space reserved and used by the whole database.