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.
Bạn đang xem 13. - THE REAL MTCS SQL SERVER 2008 EXAM 70 432 PREP KIT P163 DOC