question

Jcho360-0829 avatar image
0 Votes"
Jcho360-0829 asked SeeyaXi-msft commented

SQL Server Memory with AlwaysOn

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-general
· 1
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.

Hi @Jcho360-0829 ,

We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.

Best regards,
Seeya

0 Votes 0 ·

1 Answer

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

Hi @Jcho360-0829,

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.

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.