We are currently running SQL 2012 Enterprise for our data warehouse. Our database is 500GB of data. All of our data is partitioned and compressed using page compression. Our largest fact table is 1.3 billion rows of data.
I have just been informed that we need to make changes to our licensing structures. Due to the cost of the enterprise version of SQL on 2012 (per core), we are looking at if we could drop back to BI version.
Our main issue is IO and disk space. We would obviously lose the compression and partitioning which will have a knock on effect on large reads and system performance. At our current understanding, it would be a lot cheaper to buy a flash storage
unit for the DB and run BI edition than it would be to pay the Enterprise costs.
Does anyone have similar issues with large tables? How do you find the performance and behaviour of such large tables.
Microsoft führt eine Onlineumfrage durch, um Ihre Meinung zur Technet Website zu erfahren. Wenn Sie sich zur Teilnahme entscheiden, wird Ihnen die Onlineumfrage angezeigt, sobald Sie die Technet Website verlassen.