YOU’RE RESPONSIBLE FOR SQL SERVER IN THE ORGANIZATION AND THE IT M...

13. You’re responsible for SQL Server in the organization and the IT manager

would like to forecast the remaining storage capacity that exists on the disk.

Which SQL Server tools could help with capacity planning?

A. SP_spaceused

B. Resource Governor

C. SQL Profiler

D. Performance Data Collector

Answer D is correct. The performance data collector tracks data and log file

size and can help with capacity planning. sp_spaceused shows free space within

a file, but doesn’t help in itself with capacity planning. Neither options B

or C will help with capacity planning.