This is something that is difficult to answer, because it mostly depends on how resource hungry the checks are and how often they run.
You can take a look here: Icinga2 at large scale
In general I would recommend running the database on a separate node, in case of the IDO db.
With the new IcingaDB (Redis+Mysql/Pgsql) the load due to db queries should decrease.