4 ms·
This is great. I suspect that I have exactly the right use case for this. The two main issues with running SQL Server are (1) you have to license all the core
by joshuaellinger 6y ago
This is great. I suspect that I have exactly the right use case for this.
The two main issues with running SQL Server are (1) you have to license all the cores on a system and (2) the standard license only recognizes up to 64GB RAM. So I actually wound up buying a 3GHz single-socket system for around $10K to save $20K on the SQL license.
With this, I can move a couple of the big DBs to another system that has 32 Cores with 256GB RAM and the entire DB will fit in memory, put in 5GB ethernet, and gain a tremendous amount of performance.
But, more importantly, I can migrate the workload on a case-by-case basis. Human costs always dwarf my software and hardware costs.
- sqlserver1 6y ago(2) is not accurate. SQL Server Standard Edition supports up to 128 GB RAM https://docs.microsoft.com/en-us/sql/sql-server/editions-and-components-of-sql-server-version-15?view=sql-server-ver15#Cross-BoxScaleLimits https://docs.microsoft.com/en-us/sql/sql-server/editions-and...
- ed25519FUUU 6y agoFor the highest socket license.
- c17r 6y agoI still remember the day that MS switch the SQL Server pricing from per-socket to per-core. Dark day, indeed.