comparison of SQL Server 2014 and SQL Server 2014 Enterprise Edition Optimized for Data Warehousing Workloads on A7 VMs

Question

Hi,

Can someone share the explicit features provided in SQL Server 2014 Datawarehouse edition compared to sql server 2014.

Regards

Gaurav

Answer 1

Hi,

Thanks for posting !

I am currently researching on the same and will get back to you shortly.

Thanks for your time and patience

Regards,

Sowmya

Answer 2

Hi,

The Standard Edition of SQL Server 2014 delivers basic data management and business intelligence database for departments and small organizations to run their applications and supports common development tools for on-premise and cloud — enabling effective database management with minimal IT resources.

However the Enterprise Edition delivers comprehensive high-end datacenter capabilities with blazing-fast performance, unlimited virtualization, and end-to-end business intelligence — enabling high service levels for mission-critical workloads and end user access to data insights.

This Enterprise Edition image is optimized for data warehousing workloads and is intended for VM sizes including A4, A7, A8, A9, D4, D13 and D14. Once deployed, the VM comes with Windows Storage Spaces pre-configured. This image has been pre-configured for Windows Azure, including enabling CEIP which can be disabled, for more info see 

http://msdn.microsoft.com/library/azure/dn133151.aspx#database

This image supports data sizes of up to 2TB for A7, 4TB for A8 and 6TB for A9, respectively, using clustered columnstore indexes.

Hope this helps !

Regards,

Sowmya

Answer 3

The information about the DW images is available in the link below:

http://blogs.technet.com/b/dataplatforminsider/archive/2014/09/12/new-vm-images-optimized-for-transactional-and-dw-workloads-in-azure-vm-gallery.aspx

If you have any further questions not covered by this link, please ask.

Answer 4

Hi Gaurav,

Ninar has provided a good article for the introduction of SQL Server 2014 Datawarehouse in Azure.

In addition, you can also refer to the link below for more information:

“Modernizing” Your Data Warehouse with Microsoft

Best regards,

Susie

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help. If you have feedback for TechNet Subscriber Support, contact [e-mail].