Is a dedicated dbserver necessary for urs, reporting, ocs ets respectively?

[kevinwang]

Hi, friends,

I have a question about dbserver and statserver.
different DAPs can share same dbserver，but can these solutions like OCS, ERS, WFM even message server share same dbserver? or they all need their own dedicated dbservers? is there any rule about this?
Same question for statserver,is a dedicated statserver necessary for urs, reporting, gis?
Thanks in advance.

Kevin

[Steve]

All DB-server does is converts the database agnostic Genesys world into the correct SQL for your RDBMS (Oracle, MSSQL or whatever), all the connection details are held in the DAP, so as such there is no rule.

You need to think about the advantages and disadvantages of splitting them up or not. The more processes you have running the more processing power you need, more/bigger servers? If you only have 1 what about resilience? What about fault finding? If everything is using 1 DB-server it means only 1 log, finding stuff might be more difficult and the logs would need to be bigger (more segments) which could easily fill disk space.

Stat-Server is limited to a finite number of stats, so you need to think about sizing firstly. Then you can think about the same things I have mentioned for DB-Server.

Personally I like to split things up, a pair of servers for Framework, a pair for routing, at least a pair for reporting etc and then I keep everything related to that component on those machines, and that includes DB-Servers and Stat-Servers.  The downside of that is of course cost.

In summary there is no rule, just a lot of factors to balance.