When should you switch from SQL to NoSQL?

hey folks im wrestling with a scaling issue on a project where weve been happily using a relational database for years now with increasing traffic and complex query patterns im wondering when the benefits of a nosql database start to outweigh the headaches of migrating specifically im thinking about situations where the data schema is highly dynamic or when read write loads are extremely high and can be scaled horizontally what are your experiences with this transition are there specific use cases or metrics that signal its time to explore nosql