Share via

SQL Server Memory with AlwaysOn

Jcho360 1 Reputation point
2021-09-10T18:37:20.277+00:00

Hello All,

I know there are some rules of thumb for memory in a SQL Server single instance dedicated database servers, do these same rules apply for AO?, due to there is more load in clustered servers/AO databases, having ~80% of memory assign it to the SQL Servers can cause the server to run out of memory or resources.

Any thoughts about this?

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Seeya Xi-MSFT 16,756 Reputation points
    2021-09-13T06:03:31.233+00:00

    Hi @Jcho360 ,

    In addition to those, it is worth mentioning that AlwaysOn is a highly available technology in SQL Server. It has a load sharing function. A secondary replica of an AlwaysOn availability group can provide read-only access. Only the read database processes query requests. The read-write database is used for processing. Such a setting is recommended.
    For high availability, you can refer to this Microsoft document: High availability and Scalability in Analysis Services.

    Best regards,
    Seeya

    If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar queries.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    Was this answer helpful?

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.