cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Report server load balancing

BabarQayyum
Leader

Dear All,

Do we need an additional database for the report server load-balancing node, or we can use the same database used by the primary server?

Regards,

Babar


6 REPLIES 6

Jacek_Janowicz
Dynatrace Pro
Dynatrace Pro

Hi Babar,


Each NAM server requires separate database. No exceptions from that rule, this statement is correct for standalone NAM servers, elements of load balancing clusters and elements of failover clusters as well.

However, it is possible to run more than one database on single SQL server, which means multiple (all?) your reporting servers my work with single SQL server. All you need to remember in such configuration is to assure sufficient resources for SQL server, to avoid performance issues.


Best Regards,


Jacek


Hello @Jacek J.

Thank you for the clarification.

Do we have to have the same SQL version (Primary Server has SQL 2012) for the node server database, or can it be the different one?

Regards,

Babar


I can only confirm what Erik already said. There is no need to have exactly the same version of SQL server for NAM servers within single cluster.


Jacek


Hello @Jacek J.

Thank you for confirmation.

Regards,

Babar


I've had different versions of Windows and SQL across the NAM Server nodes without issues.


-- Erik


Hello @Erik S.

Thank you for sharing this information.

Regards,

Babar