I currently have 7 DPA application servers and 6 SQL server repositories and one Oracle repository, one for each application server. I am about to stand up another DPA application server and was wondering if I can place the new repository on one of my existing SQL Servers, a separate repository but on the same SQL Server as an existing repository?
So like many database questions, this will be answered with an "It depends".
You can host the new repo on an instance with an existing repo.
However, watch for resource contention using this multi-tenant approach. You may even want to monitor the shared instance with DPA to see what kind of impact each has on the other...