At what point is it recommended for DPA to have its own dedicated SQL Database that is separate from the Orion database?
Is there a rule of thumb, such as numbered of monitored instances?
There are a LOT of variables that come into play on this one. Number of pollers and targets on the Orion side (now being branded as Solarwinds Core IT), number of instances monitored by DPA, activity/load of monitored instances, number of modules on the Orion side, resources on the SQL Server database server, performance of those resources, etc.
I'm not aware of any specific limits. One idea might be to monitor the SQL Server instance supporting Orion and DPA databases with DPA to have eyes into the environment if you start to see performance degradation.
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 195,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.