Hi,
We have 4 node cluster with 16cpu and 128 GB RAM in each node. Two nodes are in Datacenter1 and other two are in Datacenter2. Recently added 40 databases into one AG where it has 5TB data. Here 4 databases have more that 500GB data and one more databases has 1.5 TB data. Is it recommended adding 40 databases (5TB data) in one availability group. If failover happens, Is this scenario creates any issue.
Please suggest best practices.
1) Do we need to add these 40 databases into multiple AG's(large and small)?
2) Do we need to increase Hardware resources?