↑
Back to Top
What are the key benefits and main advantages of Microsoft SQL Server 2017 Standard?
Reliable Performance – Fast queries and stable OLTP workloads daily.
Strong Security – Encryption, auditing, and role-based access controls.
Hybrid Ready – Works across on-prem and cloud environments.
Insight Tools – Reporting and analytics for business decisions.
Easy Management – Familiar tools for monitoring and maintenance.
Broad Compatibility – Supports many apps, drivers, and platforms.
Download: SQL Server 2017 Standard
Database Engine – Relational engine for storing and querying production data.
Basic Availability Groups – Two-replica failover protecting a single database.
Reporting Services – Builds paginated reports and dashboards from live data.
Integration Services – Moves and transforms data between systems and warehouses.
Core Capacity – Uses up to 24 cores and 128 GB RAM.
Important – Transparent Data Encryption is not included in this 2017 edition.
SQL Server 2017 Standard is the mid-tier relational database for departmental and small-to-medium business workloads. It runs on Windows, Linux, and Docker, and covers transactional databases, reporting, and ETL without the cost of Enterprise.
Cross-Platform – Same engine on Windows, Linux, and containers.
Built-In BI – Reporting and Integration Services ship at no extra cost.
Basic High Availability – Two-node clustering and single-database availability groups.
Licensing Choice – Per-core or Server plus CAL model available.
Predictable Limits – 24 cores and 128 GB cover most line-of-business apps.
In-Place Upgrade – Upgrades existing 2012 to 2016 instances directly.
It stores, secures, and queries relational data for business applications such as ERP back ends, accounting systems, and departmental web apps. The Standard edition includes the full Database Engine plus Reporting Services and Integration Services, so a single license covers transactional storage, scheduled ETL jobs, and report generation. SQL Server 2017 was also the first release to run natively on Linux and in Docker containers, which lets teams standardise on one engine across mixed infrastructure. For typical line-of-business databases under 128 GB of active memory, Standard delivers the same query engine as Enterprise without the higher per-core cost.
It fits small and medium businesses running departmental databases, accounting or ERP back ends, and internal web applications that stay within 24 cores and 128 GB of engine memory. Because Reporting Services and Integration Services are included, a finance team can schedule nightly data loads and publish paginated reports from one licensed instance instead of buying separate tools. Organisations that need unlimited memory, online index rebuilds, or Always On availability groups with multiple readable secondaries will hit Standard's ceilings and should evaluate Enterprise instead. For most non-mission-critical workloads, Standard's limits are higher than the actual hardware in use.
The query engine is identical, but Standard caps compute at the lesser of 4 sockets or 24 cores and buffer pool memory at 128 GB per instance, while Enterprise scales to the operating system maximum. Standard supports basic availability groups (two replicas, one database) and two-node failover clustering, whereas Enterprise adds Always On availability groups with up to eight secondaries, online index rebuilds, partitioned table parallelism, and Resource Governor. Columnstore batch-mode queries are limited to two cores of parallelism on Standard, which slows large analytical scans compared with Enterprise. For transactional apps and modest reporting this gap rarely matters; for large data warehouses or 24/7 mission-critical systems it does.
| Feature | Standard | Enterprise |
|---|---|---|
| Max cores per instance | 24 cores | OS maximum |
| Max buffer pool memory | 128 GB | OS maximum |
| Always On availability groups | Basic only | ✓ |
| Transparent Data Encryption | ✕ | ✓ |
| Online index rebuild | ✕ | ✓ |
| Resource Governor | ✕ | ✓ |
| Columnstore batch-mode parallelism | 2 cores | Unlimited |
| Max database size | 524 PB | 524 PB |
No. In SQL Server 2017, Transparent Data Encryption (TDE) is an Enterprise-only feature, and attempting to enable it on Standard returns the error that TDE is not available in this version category. This is a common buyer trap, because TDE later became available in Standard starting with SQL Server 2019, so guides written for newer versions do not apply here. If you specifically need at-rest encryption of the whole database file on 2017, you must use Enterprise or upgrade to a 2019-or-later Standard license. Standard 2017 still supports cell-level encryption, Always Encrypted, row-level security, and dynamic data masking for more targeted protection.
It depends on the licensing model: the Server plus CAL model requires a CAL for every user or device that accesses the server, while the per-core model requires no CALs at all. A SQL Server CAL must be the same version or newer than the server, so a 2017 server needs 2017-or-newer CALs, and one CAL lets that user reach multiple licensed SQL Server instances. The per-core model is the better fit when you cannot count users, run public-facing or extranet workloads, or expect access from external systems. For a fixed, countable internal user group, Server plus CAL is usually cheaper than licensing every physical core.
Confirm your workload stays under 24 cores and 128 GB of engine memory, because these are hard ceilings that Standard will not exceed even on larger hardware. Check whether you need Always On availability groups with readable secondaries or online index rebuilds, since both are Enterprise-only and cannot be added to Standard later. Verify your high-availability plan fits basic availability groups (one database, two replicas) or a two-node failover cluster. Finally, decide between per-core and Server-plus-CAL licensing up front, as switching models after deployment usually means repurchasing licenses.
Yes. SQL Server 2017 was the first release to support Linux distributions such as Red Hat, SUSE, and Ubuntu, as well as Docker containers, using the same Database Engine as the Windows build. This lets teams run the licensed Standard engine on existing Linux infrastructure without changing edition.
A single relational database can grow to 524 PB, the same ceiling as Enterprise. In practice the real constraint is the 128 GB buffer pool memory limit, not file size, so very large active datasets will be paged from disk rather than held in memory.
Standard includes basic availability groups, which protect a single database with two replicas, plus two-node failover cluster instances. Full Always On availability groups with multiple readable secondaries are Enterprise-only, so multi-database or read-scale setups require Enterprise.
No. A SQL Server CAL must match or exceed the server version, so a 2017 server needs 2017-or-newer CALs; older 2014 or 2016 CALs do not grant access. The same CAL can, however, be used to reach multiple licensed SQL Server instances across editions.
| Operating Systems | Windows Server 2016: Standard / Datacenter Windows Server 2012 R2: Standard / Datacenter Windows Server 2012: Standard / Datacenter Windows 10: Pro / Enterprise Windows 8.1: Pro / Enterprise Windows 8: Pro / Enterprise |
| Processor | x64 processor, minimum 1.4 GHz Recommended 2.0 GHz or faster |
| Memory RAM | Minimum 1 GB for Standard edition and other non-Express editions Recommended at least 4 GB and increase as database size grows |
| Hard Disk | Minimum 6 GB of available hard-disk space for installation Actual space depends on selected components and data growth |
| Display | Super-VGA 800x600 or higher resolution monitor |
| Graphics | Standard graphics adapter capable of supporting Super-VGA 800x600 or higher |
| NET Version | .NET Framework 4.6 or later required for Database Engine, Master Data Services, or Replication SQL Server setup can install .NET Framework if needed |
| Note | SQL Server 2017 installation is supported on x64 processors only, x86 is not supported On Windows 8.1 and Windows Server 2012 R2, install KB2919355 before .NET Framework updates |
keys.express and keys.discount is a web platforms for new and used product keys. The product keys for Windows and other software available in the shop of keys.express and keys.discount are cheap, safe, legal and with activation guarantee.
Here you can find some general information about used software, an overview of the most important legal information as well as answers to frequently asked questions from our customers ("FAQ“)
Used software is available for sale in the European Union as well as in Switzerland according to current jurisdiction provided that the necessary conditions are met. The necessary conditions are as follows:
keys.express and keys.discount ensure that the above mentioned requirements are met and that a legal use of the software is guaranteed. The requirements of the European legislation are also met in Switzerland.
You can find further information on:
There is a lot of legal information about the topic of used software. We are more than happy to answer any questions you may have. You can contact us at any time via welcome(at)keys.express. In the meantime, you can also find a short overview of the most important legal information regarding used software here:
For distance contracts concluded by telephone, on the Internet or when ordering from a catalogue, EU law provides for the possibility for consumers to withdraw from the contract for a certain period of time ("right of withdrawal"). A consumer in this sense is any natural person who concludes a legal transaction for purposes that are predominantly neither commercial nor self-employed. In Switzerland we usually speak of consumers.
Consumers have the right to cancel the contract within fourteen calendar days without giving reasons. The revocation period begins on the day the contract is concluded.
In order to exercise your right of withdrawal from keys.express or keys.discount, you must inform us by means of a clear statement (e.g. a letter, fax or e-mail sent by post) of your decision to withdraw from this contract. For this purpose, you can contact us using the following information:
Keys Distribution Ltd
Suite 2, 215 Main Street
Gibraltar Heights, Gibraltar
Phone +423 7989130
Email: welcome@keys.discount
keys.express and keys.discount also provides a template revocation form. In order to comply with the revocation period, it is sufficient to send the notification of the exercise of the right of revocation to Keys Distribution Ltd before the end of the revocation period.
If you revoke this contract, we must reimburse you for all payments which we have received from you for the corresponding order, including delivery costs (with the exception of additional costs which result from the fact that you have chosen a different type of delivery than the cheapest standard delivery offered by us), immediately and at the latest within fourteen calendar days from the day on which we receive notification of your revocation of this contract. For this repayment we will usually use the same means of payment that you used for the original transaction, unless expressly agreed otherwise with you. In no case will you be charged for this refund.