question

SushilAgarwal-8271 avatar image
0 Votes"
SushilAgarwal-8271 asked Yufeishao-0810 commented

Microsoft®SQLServerStandardEdition 2017 Sngl OLP 1License NoLevel

my client has bought

Microsoft®SQLServerStandardEdition 2017 Sngl OLP 1License NoLevel

Microsoft®SQLCAL 2017 Sngl OLP 1License NoLevel UsrCAL

is it optimum for a server
Intel Xeon 1x2680 12 mb cache,
64Gb Ram
900 Gb Sas 15K hdd

30 users

sql-server-general
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

ErlandSommarskog avatar image
0 Votes"
ErlandSommarskog answered

Maybe. Maybe not. It all depends on the workload. So, sorry, we cannot answer neither yes or no to your question.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Yufeishao-0810 avatar image
0 Votes"
Yufeishao-0810 answered Yufeishao-0810 commented

Hi @SushilAgarwal-8271,

Your configuration already meets the minimum hardware configuration requirements of SQL Server 2017, but the optimum does not dare to say, application performance of SQL Server may be based on your actual workload, any software may have some issues that affect the performance of the SQL Server. Maybe you need to adapt your configuration to the actual workload.


· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

sir,
i want to know the server

Intel Xeon 1x2680 12 mb cache,
64Gb Ram
900 Gb Sas 15K hdd

with foloowing sql license

Microsoft®SQLServerStandardEdition 2017 Sngl OLP 1License NoLevel

Microsoft®SQLCAL 2017 Sngl OLP 1License NoLevel UsrCAL

having 30 users will run at its fullest performance or sql licesnse is downgraded ? or additional sql licese is required , becuase on search its confusing Sql server Core lisense, cal license

this server has 12 cores, single processor, 64 gb ram and 900gb sas hdd , then will the licesese bought will impose any downgraded excecution or not ?

0 Votes 0 ·

As Olaf says, the license does not affect the performance. But if you have more users than your CALs permits, it will not be fun if you get license-audited. But that is a strictly legal problem.

0 Votes 0 ·

yes, Microsoft Open License just provides a simple,flexible, and cost effective way to buy the latest Microsoft technology

0 Votes 0 ·
OlafHelper-2800 avatar image
0 Votes"
OlafHelper-2800 answered

The type of license CAL/CORE and/or the count of license don't have any effect on the permformance.

Just the Enterprise Edition has some performance related features more the the Standard Edition.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.