The below table show High Availability features supported by different SQL Server versions which give SharePoint Administrator insight which options will be appropriated the option.
For SQL Server 2012
For SQL Server 2014
For SQL Server 2016 and higher version
AlwaysOn will be supported with standard edition but with some limitations:
- Limited to two nodes only (a primary and a secondary server)
- Like mirroring, you can’t read from the secondary, nor take backups of it
- It is not appropriate for a SharePoint farm as it only supports a single database within the Basic Availability Group