Profiling services for resource optimization and capacity planning in distributed systems