SQL Server Standard is ideal for smaller to medium sized businesses. SQL Server Standard supports 128 GB
of memory (per instance of SQL Server Database Engine). It allows for a maximum relational database size up to 524 PB. And has a per instance maximum compute capacity of 4 sockets or 16 cores. SQL Server Enterprise is geared toward medium to enterprise sized businesses who are looking for high performance and scalability.