Hi,
It is recommended having Orchestrator Server and SQL server on separate machines for multiple reasons:
Performance - allocate enough resources such as RAM / disk space
Redundancy especially if running SQL as cluster
Maintenance and DB Management .
Here's a doc about Database Sizing and Performance: