Personally I've only used it on a handful of VMs to check if they have enough resources.
I think the interval is more about how accurate you want the data to be. The lower the interval will get you more accurate data but it will obviously be more taxing on both your network and database.