What is the minimum RAM configuration for SQL Server Availability Group Automatic Seeding

PTL_SQL 20 Reputation points
2023-05-30T12:41:47.5366667+00:00

What is the minimum RAM configuration for SQL Server Availability Group Automatic Seeding? I have an 8GB Windows cluster with two nodes, with about 5GB allocated to SQL on each node. I have a 40GB database that fails to complete seeding with automatic seeding. Queries against sys.dm_hadr_automatic_seeding show that the seeding is not complete

I also noticed that when adding the database to the AG, the memory utilisation on the server increases sharply and results in SQL dump errorlog.

Doing the same thing with Manual seeding however completes without the sharp increase in memory utilization and the seeding successfully completes.

I will appreciate some advice on resolving this issue please. Thank you.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,343 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Erland Sommarskog 106.8K Reputation points
    2023-05-30T22:06:06.3166667+00:00

    Apparently the min RAM for automatic seeing of a 40 GB database is more than 5GB. I was able to make automatic seeding on my lab AG at home with 6 GB on my VMs. But my biggest database is around 1GB.

    Overall, 8 GB for a database server is very humble.


  2. ZoeHui-MSFT 35,546 Reputation points
    2023-05-31T05:34:53.9566667+00:00

    Hi @PTL_SQL,

    There are four ways to monitor and troubleshoot automatic seeding:

    You may try the methods to see if you could see any useful messages.

    Regards,

    Zoe Hui


    If the answer is helpful, please click "Accept Answer" and upvote it.