First, let me say im not a DBA expert, and im facing a hard decision
We have a DB on SQL 2008 Enterprise. Since SQL 2008 is out of support from MS we decided to move to a newer version (2019)
My main question is:
Is there any performace difference between Standard and Enterprise? (i know the memory limitation)
I mean, if I go for standard, that version not includes features that will improve the performance of the DB?.
For example. If I have the same hardware (with 128GB of ram) the enterprise will be "faster" than standard version.
I know some of you may think, "what this guy is asking!!!" Sorry for that, im not very familiar with DB's
Im not interestend in other features only a database engine to storage data (dont care datawarehouse features, replication, cluster, etc)
If only i will storage data, there something that i will miss if I go for standard?
Hope you can help me. Diference of $$$ between two versions is high, and in 3rd world countries, that is a lot of money!
thanks a lot in advance!