Introduction xp_fixeddrives only provide how much disk space is free on each drive but not the maximum space of the…