{"id":1315,"date":"2016-10-06T10:49:42","date_gmt":"2016-10-06T10:49:42","guid":{"rendered":"http:\/\/www.quartzbd.com\/?post_type=product&p=1315"},"modified":"2016-10-06T10:49:42","modified_gmt":"2016-10-06T10:49:42","slug":"sql-server-2012-enterprise-sp3-x86-x64","status":"publish","type":"product","link":"http:\/\/www.quartzbd.com\/?product=sql-server-2012-enterprise-sp3-x86-x64","title":{"rendered":"SQL Server 2012 Enterprise SP3 x86.x64"},"content":{"rendered":"
\n

SQL Server Enterprise Edition x86.x64<\/h1>\n<\/div>\n
<\/div>\n
<\/div>\n
\n

Features Supported by the Editions of SQL Server<\/strong>\"SQL<\/p>\n

Microsoft has very nice documentation covering which features are available for each version and edition of SQL Server. I refer to these pages fairly often, usually on Mondays when I can\u2019t remember if some particular feature is available in Standard Edition (SE) or if it is Enterprise Edition (EE) only.<\/p>\n

If you zoom in on the Enterprise Edition features for any category you\u2019ll notice a very rich set of amazing things that you only get when you ride the \u201cStarship Enterprise\u201d (a.k.a. Enterprise Edition.) Let\u2019s take a look at a select handful of Enterprise Edition features in SQL Server 2012:<\/p>\n

Cross-Box Scale Limits<\/p>\n

Maximum Compute Capacity Used by a Single Instance<\/p>\n

Operating System maximum: However big you build your server, that\u2019s how much CPU you can use. It sounds good, but be warned; due to changes in licensing in SQL 2012 it\u2019s desirable to have as few CPU as possible. Fewer and faster is a good rule of thumb. We\u2019ll get into why a little later in this post. Compare this to Standard Edition where the limit is the \u201clesser of 4 sockets or 16 cores\u201d.<\/p>\n

Maximum memory utilized (per instance of SQL Server Database Engine)<\/p>\n

Operating system maximum. Like CPU, Enterprise Edition will use as much RAM as is available. Compare to Standard Edition where the limit is 64GB. (Note SQL2014 SE allows 128GB).<\/p>\n

High Availability<\/p>\n

Online indexing<\/a> \u2013 Rebuild indexes online without blocking the ongoing workload. It\u2019s not perfect, the rebuild process still takes some locks as it finalizes and merges the rebuilt data back into the \u2018live\u2019 database, but it sure beats the Standard Edition option where the lock persists for the duration of the rebuild.<\/p>\n

AlwaysOn Availability Groups<\/a> \u2013 A comprehensive solution to both HA and DR allowing segregation of OLTP, DSS, and maintenance workloads and may put five nines in reach. To get something similar out of Standard Edition (or any pre-AOAG versions) you\u2019d need to employ clustering, database mirroring, replication, log shipping, andor some combination of these and perhaps other technologies. That is certainly a challenge, and any given solution might have its drawbacks, but note it is possible to achieve HADR without AOAGs.<\/p>\n

Mirrored backups<\/a> \u2013 It\u2019s convenient to regularly back up database to a local drive for easy and quick access just in case they are needed quickly. Of course it\u2019s a risk to only keep them there since if the whole box goes down those backups go with it. A typical practice is to backup databases locally, then immediately copy them off to a remote drive. That\u2019s a two-step process and it can be tricky to manage the OS-level file copy through SQL Server. But if you have Enterprise Edition it is possible to send a copy of the backup to two separate destinations \u2013 one local and one remote \u2013 in parallel, which handily solves the problem.<\/p>\n

Scalability and Performance<\/p>\n

Table and index partitioning<\/a> \u2013 This is a great feature to help manage tables with many rows since it enables you to access, load, remove (age-out), or maintain sub-sets of table data. The table still looks and acts like a unit, but behind the scenes groups of rows are segregated into different partitions. Data can be moved in and out of a single partition efficiently, and indexes and data compression can be maintained on the partition level. In some cases the SQL engine is able to optimize query executions by eliminating partitions that are not relevant to the query. In Standard Editions the closest corollary is \u00a0partitioned views<\/a> which may provide some performance optimizations, but none of the management benefits of partitioned tables.<\/p>\n

Data compression<\/a> \u2013 Enterprise Edition supports row and page compression of data. Data compression not only saves space on the physical disk but also can reduce IO. When data is compressed, there is more data per page and so less page reads are required to access a given set of data. Additionally, since the data remains in the compressed configuration after the physical read, the over-all buffer pool usage is reduced which is a good thing \u2013 the more data that fits in the buffer pool, the less SQL Server will need to access that data via slow physical reads.<\/p>\n

Resource Governor<\/a> \u2013 An enterprise level environment typically serves a diverse set of users. In a well configured SQL Server each user, or group of users, has a particular security profile \u2013 some are allowed only to read data from specific views, others to read and write to a set of tables, yet other to execute stored procedures, etc. You can think of the Resource Governor along the same lines, but rather than security constraints, the Resource Governor enforces resource constraints. One type of user might only have access to 30% of the overall CPU, another group to 10% of memory, and so on. Resource Governor enforces a maximum (and minimum) percent of resources for each user type.<\/p>\n

These are the Voyages of the \u201cStarship\u201d Standard Edition<\/strong><\/p>\n

After this overview of EE features I hope you are getting the idea of some of the power available in Enterprise Edition. But this also points out just what Standard Edition doesn\u2019t provide. No data compression, no online indexing, no partitioning, etc. Very often I see Enterprise Edition installed and in use, but with a minimum or none of the EE features enabled. If the features above, or the others described in the Microsoft documents, are not necessary for your operations then Standard Edition is your ticket. You still get some valuable tools; in fact it has plenty of great features that suffice for many implementations, and you may be able to work around SE shortcoming with some creative development or implementation of combined features (like the HADR example above). In short, if you don\u2019t need Enterprise Edition, don\u2019t use Enterprise Edition.<\/p>\n

It matters because as we all look towards inevitably upgrading versions beyond SQL 2008, we are faced with Microsoft\u2019s new SQL Server licensing scheme<\/a>. Licensing is going from socket based to core based. The 2008 EE server that has been running along doing its work on 4 quad-core CPUs might suddenly quadruple in licensing costs upon upgrading to SQL2012 EE. Now is the time, before upgrading to 2012+, to down-edition to Standard Edition where possible.<\/p>\n

To wrap it all up, this highlights the need to review the current SQL environment for version, edition and work load. Consider consolidating critical production database to perhaps one or several high caliber EE servers with lots of RAM. Then find ways to employ those expensive EE features. Some EE features may initially look like \u2018a solution in search of a problem\u2019, but it\u2019s worth a close study to determine how they might be useful. In general these EE features work great and can be critical in getting and keeping enterprise level databases running tip-top. Meanwhile, move less-critical, less-used database to Standard Edition instances. For edges cases, find ways to get by without EE features when you can. Not only can you save licensing costs with this effort as we migrate to SQL 2012+, but you\u2019ll end up with a well thought out, easier to manage and more organized SQL Server environment.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

Delivery system
\n===============
\nFace to face from our office
\nDownload from Dropbox link
\nCourier Service<\/p>\n

Payment system
\n==============
\nFace to Face
\nbkash-01716197088 ( Personal )<\/p>\n

Contact
\n========
\n01919197088
\n01716197088-bkash ( Personal )
\n01552551768-office
\nqrtzcom@gmail.com
\nFreelancer.com profile page: https:\/\/www.freelancer.com.bd\/u\/qrtzcom.html
\nwww.quartzbd.com
\nwww.facebook.com\/quartz.bd
\nskype: quartzcom<\/p>\n","protected":false},"featured_media":1316,"comment_status":"open","ping_status":"closed","template":"","meta":[],"product_cat":[225,194,181,167],"product_tag":[],"class_list":{"0":"post-1315","1":"product","2":"type-product","3":"status-publish","4":"has-post-thumbnail","6":"product_cat-may-2016","7":"product_cat-top-collection","8":"product_cat-server-series","9":"product_cat-sql","11":"first","12":"instock","13":"shipping-taxable","14":"purchasable","15":"product-type-simple"},"_links":{"self":[{"href":"http:\/\/www.quartzbd.com\/index.php?rest_route=\/wp\/v2\/product\/1315"}],"collection":[{"href":"http:\/\/www.quartzbd.com\/index.php?rest_route=\/wp\/v2\/product"}],"about":[{"href":"http:\/\/www.quartzbd.com\/index.php?rest_route=\/wp\/v2\/types\/product"}],"replies":[{"embeddable":true,"href":"http:\/\/www.quartzbd.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1315"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/www.quartzbd.com\/index.php?rest_route=\/wp\/v2\/media\/1316"}],"wp:attachment":[{"href":"http:\/\/www.quartzbd.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1315"}],"wp:term":[{"taxonomy":"product_cat","embeddable":true,"href":"http:\/\/www.quartzbd.com\/index.php?rest_route=%2Fwp%2Fv2%2Fproduct_cat&post=1315"},{"taxonomy":"product_tag","embeddable":true,"href":"http:\/\/www.quartzbd.com\/index.php?rest_route=%2Fwp%2Fv2%2Fproduct_tag&post=1315"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}