SQL Server instances are divided into Stand-alone and Active/Standby types by architecture. Each instance type features different characteristics. For more information, refer to Instance Types.
Different instance specifications are supported by Stand-alone and Active/Standby instance types. For more information, refer to Instance Specifications.