Sql server 2012 enterprise edition vs standard edition11/3/2022 0 Comments
Do I need to ensure that SQL login accounts are kept in sync between cluster nodes?.Do I need to ensure that SQL Agent jobs such as database backups, optimizations, DTS and others continue to run regardless of the node in service?.Do I need to support Lync Server or other applications that use distributed transactions?.Am I concerned about the cost of SQL Server Enterprise Edition?. SQL SERVER 2012 ENTERPRISE EDITION VS STANDARD EDITION WINDOWSNot only will you be able to save money, but if you answer yes to any of the following questions, AlwaysOn Availability Groups probably wasn’t the best solution for you to begin with and you would be better served by Windows Server Failover Clustering and DataKeeper Cluster Edition. You’ll be glad to know that for the cost of a single copy of SQL Server 2012 Standard Edition and the very affordable addition of SteelEye DataKeeper Cluster Edition, you’ll be able to deploy 2-node SQL Server 2012 Standard Edition clusters with data replication for about half the cost of a 2-node SQL Server Enterprise Edition AlwaysOn Availability Group and about ¼ of the price of a AlwaysOn Availability Group with read-only targets. What’s that you say, you don’t have a SAN? Or you’d rather build a solution that eliminates the SAN as a single point of failure and instead allows you to use data replication to keep the data in sync between cluster nodes the way that AlwaysOn Availability Groups allows you to? Or perhaps you want to use take advantage of the speed offered by local attached SSD drives such as those offered by Fusion-IO, but yet don’t want to give up on availability? So for $7,172 you can build a pretty robust 2-node SQL cluster, assuming you have an enterprise class SAN that you can use to store your cluster data. SQL SERVER 2012 ENTERPRISE EDITION VS STANDARD EDITION LICENSEThe good news is that Microsoft still allows you to build 2-node clusters using SQL Server Standard Edition, and since this is generally deployed in an active-passive configuration you do not have to license the standby server. When you start talking about that kind of money, you begin to wonder if there is an alternative to AlwaysOn Availability Groups. If you plan on taking advantage of the “Read-Only” replica, you can double the cost of the solution ($54,992) since you have to license both the source and the target server. The cost of SQL Server Enterprise is $27,496 for any server that has up to 4 physical processors vs. Microsoft has announced that some of the most widely anticipated availability options being introduced with SQL Server 2012, including AlwaysOn Availability Groups, will only be available with the Enterprise Edition of SQL.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
November 2022
Categories
All
RSS Feed |