The DBA can use the SCOME technique to interrogate disk space on all linked servers. For example this report displays capacity and remaining disk space details for each drive on each linked SQL Server, ordered ascending by least percentage. Database sizes can be called in real time for evaluation. Capacity graphical charts for each drive. Option to query any anomolies due to the size of a drive having changed since the report was set up. All columns can be reordered.

Below is just a small sample of server drives. For this demo, not all example servers and their drives have been listed.

Disk Space
Use SCOME to interrogate the drive sizes on each remote server with the proc master.dbo.xp_fixeddrives.

Please enable browser pop-up windows for this page. This help guide can be hidden by clicking the minimise icon on the top right.