I want to buy Microsoft SQL Server 2017 Enterprise edition but stuck on how to order the specification and all what I get a recommendation from the vendor is confusing.
I have a server with 2 CPU sockets each 10 cores and the operating system is Windows Server 2012 R2. I will be the only one using the server to pull data out of it but the database needs daily restoring from the primary database based on the log shipping with TDE certificate (that is the only reason needed the enterprise version) . So, how many packs of SQL 2017 enterprise 2 core license should I buy to successfully install?
Some of the vendors said only licensing on 4 of the 20 cores is enough and some others say all the 20 cores should be licensed….kind of confused to determine.