question

Sai-0641 avatar image
0 Votes"
Sai-0641 asked AmeliaGu-msft answered

How many availability groups are suggested for 5TB data.

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?

sql-server-general
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

TomPhillips-1744 avatar image
0 Votes"
TomPhillips-1744 answered

An AG is intended to allow you to have a smaller failover group than the entire server by relating databases together into a single group. However, if all your databases need to failover to another server, then a single AG is fine.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

AmeliaGu-msft avatar image
0 Votes"
AmeliaGu-msft answered

Hi Sai-0641,

Do we need to increase Hardware resources?

It depends on the workload. Signs of overloaded systems can include, but are not limited to, worker thread exhaustion, slow response times for availability group system views and DMVs, and/or stalled dispatcher system dumps. You can thoroughly test your environment with a production-like workload to ensure it can handle peak workload capacity within your application SLAs. When considering SLAs be sure to consider load under failure conditions as well as expected response times.
And please refer to AlwaysOn– Performance Aspects and Performance Monitoring and Monitor performance for Always On which might help.

Best Regards,
Amelia


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.