Add "troubleshooting" information to more docs pages

[Rperry2174]

We're starting to run into more issues where people are profiling very large / complex applications. As we've added new features, it's possible for people to get into issues where a single config option can cause for the Pyroscope server to run into issues:

• too many tags
• Scrape interval too short
• Retention threshold too high/low
• "How much overhead does pyroscope cause"
• 2. if the push destination is unresponsive, will the profiling agent spin, consume resources, or crash?
• etc

We should add more information to various pages to help people troubleshoot the issues that they run into more easily. Not sure if this should be one page or on each individual page, but just adding this here as a placeholder so we can address this more thoroughly as time goes on

[Rperry2174]

Examples:
https://prometheus.io/docs/introduction/faq/#troubleshooting

[kolesnikovae]

We should prioritise this, I believe.