UBB Store

Microsoft SQL Server 2014 Standard with 16 Core License, unlimited User CALs
When you click on links to various merchants on this site and make a purchase, this can result in this site earning a commission. Affiliate programs and affiliations include, but are not limited to, the eBay Partner Network.
Microsoft SQL Server 2014 Standard with 16 Core License, unlimited User CALs
Price: DK $595.00
SQL Server 2014 64-Bit, Standard Edition. Now with Service Pack 2.Complete with Retail 16 Core License.This is the Core License, allowing you to have a maximum of 16 CPU Cores in your Server or VM.The Core licenses comes with unlimited User CALs.
US English language, New and Shink Wrapped / Factory Sealed.License and Media included:
This SQL Server 2014 Standard Edition contains the Core License, meaning that it is licensed to the number of Cores physically in your Server CPU(s). User CALs are NOT needed for this license type.Inside the box, you will find the License Keys needed for installing and licensing the SQL Server, along with the installation media (DVD). So a DVD drive is needed to install the SQL Server.
Product Features:

SQL Server 2014 enables customers to build mission-critical applications andBig Data solutions using high-performance, in-memory technology across OLTP,data warehousing, business intelligence and analytics workloads without havingto buy expensive add-ons or high-end appliances. SQL Server 2014 uses a commonset of tools to deploy and manage databases both on-premises and in the cloud,which makes it easier for customers to take advantage of the cloud with existingskills.

SQL Server 2014 makes it easier and more cost effective to buildhigh-performance, mission-critical applications, enterprise ready Big Dataassets, and BI solutions that help employees make better decisions, faster.These solutions have the flexibility of being deployed on-premises, in the cloudor in a hybrid environment, and can be managed through a common and familiar atool set.

SQL Server 2014 accelerates reliable, mission critical applications with anew in-memory OLTP engine that can deliver on average 10x, and up to 30xtransactional performance gains. For Data Warehousing, the new updatablein-memory columnstore can query 100x faster than legacy solutions. SQL Serveralso delivers peace of mind as the most secure database five years in a row.

With Windows Server, physical processing now scales up to 640 logicalprocessors, and virtual machines scale up to 64 logical processors. SQL Server2014 uses this scale, storage spaces and network virtualization to maximizeoverall infrastructure utilization. It can also run on Windows Server Core tolower the surface area of attack.

Standard Edition features:Core Data Management

Leverage reliable, cost-effective availability, and robust data securityfeatures, powered by easy-to-use tools and functionality.

Cloud-enabled database

Built-in cloud capabilities provide a consistent platform to help reducecosts and quickly scale.

Faster insights across your data

Unlock new insights and operational reporting visibility across the businesswith consistent, integrated data.

Principal Editions of SQL Server 2014:

SQL Server Edition

Definition

Enterprise (64-bit and 32-bit) The premium offering, SQL Server 2014 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. Business Intelligence (64-bit and 32-bit) SQL Server 2014 Business Intelligence edition delivers comprehensive platform empowering organizations to build and deploy secure, scalable and manageable BI solutions. It offers exciting functionality such as browser based data exploration and visualization; powerful data mash-up capabilities, and enhanced integration management. Standard (64-bit and 32-bit) SQL Server 2014 Standard edition 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. Web (64-bit and 32-bit) SQL Server 2014 Web edition is a low total-cost-of-ownership option for Web hosters and Web VAPs to provide scalability, affordability, and manageability capabilities for small to large scale Web properties.


What’s new in SQL Server 2014 with Service Pack 2?

Performance and Scalability Improvements

Automatic Soft NUMA partitioning: With SQL Server 2014 SP2, AutomaticSoft NUMA is enabled when Trace Flag 8079 is turned on during instance startup.When Trace Flag 8079 is enabled during startup, SQL Server 2014 SP2 willinterrogate the hardware layout and automatically configure Soft NUMA onsystems reporting 8 or more CPUs per NUMA node. The automatic, soft NUMAbehavior is Hyperthread (HT/logical processor) aware. The partitioning andcreation of additional nodes scales background processing by increasing thenumber of listeners, scaling, and network and encryption capabilities. It isrecommended to first test the performance workload with Auto-Soft NUMA beforeturning it in production.

Dynamic Memory Object Scaling: SQL Server 2014 SP2 dynamicallypartitions memory objects based on number of nodes and cores to scale on modernhardware. The goal of dynamic promotion is to automatically partition a threadsafe memory object (CMEMTHREAD) if it becomes a bottleneck. Un-partitionedmemory objects can be dynamically promoted to be partitioned by node (number ofpartitions equals number of NUMA nodes), and memory objects partitioned by nodecan by further promoted to be partitioned by CPU (number of partitions equalsnumber of CPUs).

MAXDOP hint for DBCC CHECK* commands: This improvement addresses connectresponse (468694). You can now run DBCC CHECKDB with the a MAXDOP setting otherthan the sp_configure value. If MAXDOP exceeds the value configured withResource Governor, the Database Engine uses the Resource Governor MAXDOP value,described in ALTER WORKLOAD GROUP (Transact-SQL). All semantic rules used withthe max degree of parallelism configuration option are applicable when you usethe MAXDOP query hint.

Enable >8TB for Buffer Pool: SQL Server 2014 SP2 enables 128TBof virtual address space for buffer pool usage. This improvement enables SQLServer Buffer Pool to scale beyond 8TB on modern hardware.

SOS_RWLock spinlock Improvement: The SOS_RWLock is a synchronizationprimitive used in various places throughout the SQL Server code base. As thename implies, the code can have multiple shared (readers) or single (writer)ownership. This improvement removes the need for spinlock for SOS_RWLock andinstead uses lock-free techniques similar to in-memory OLTP. With this change,many threads can read a data structure protected by SOS_RWLock in parallelwithout blocking each other and thereby providing increased scalability. Priorto this change, the spinlock implementation allowed only one thread to acquirethe SOS_RWLock at a time, even to read a data structure.

Spatial Native Implementation: Significant improvement in spatialquery performance is introduced in SQL Server 2014 SP2 through nativeimplementation.

Supportability and Diagnostics Improvements

Database Cloning: Clone database is a new DBCC command thatenhances troubleshooting existing production databases by cloning the schemaand metadata without the data. The clone is created with the command ‘clone_database_name’). Note: Cloneddatabases should not be used in production environments. Use the followingcommand determine if a database has been generated from a cloned database:select DATABASEPROPERTYEX(\'clonedb\', \'isClone\'). The return value of 1indicates the database is created from clonedatabase while 0 indicates it isnot a clone.

Tempdb supportability: A new errorlog message thatindicates the number of tempdb files and the size/autogrowth of tempdb datafiles present at server startup.

Database Instant File Initialization Logging: A new errorlog message thatindicates on server statup, the status of Database Instant File Initialization(enabled/disabled).

Module names in callstack: The Xevent callstack now includesmodules names + offset instead of absolute addresses.

New DMF for incremental statistics: This improvement addresses connectresponse to enable tracking the incremental statistics at the partition level.A new DMF sys.dm_db_incremental_stats_properties is introduced to exposeinformation per-partition for incremental stats.

Index Usage DMV behavior updated: This improvement addresses connectresponse from customers where rebuilding an index will not clear any existingrow entry from sys.dm_db_index_usage_stats for that index. The behavior willnow be the same as in SQL 2008 and SQL Server 2016.

Improved correlation between diagnostics XE andDMVs: Thisimprovement addresses connect response (1934583). Query_hash andquery_plan_hash are used for identifying a query uniquely. DMV defines them asvarbinary(8), while XEvent defines them as UINT64. Since SQL server does nothave \"unisigned bigint\", casting does not always work. Thisimprovement introduces new XEvent action/filter columns equivalent toquery_hash and query_plan_hash except they are defined as INT64 which can helpcorrelating queries between XE and DMVs.

Support for UTF-8 in BULK INSERT and BCP: This improvement addresses connectresponse where support for export and import of data encoded in UTF-8 characterset is now enabled in BULK INSERT and BCP.

Lightweight per-operator query executionprofiling: Whiletroubleshooting query performance, although showplan provides lot ofinformation on the query execution plan and cost of operator in the plan but ithas limited information on actual runtime statistics like (CPU, I/O Reads,elapsed time per-thread). SQL 2014 SP2 introduces these additional runtimestatistics per operator in the Showplan as well as an XEvent(query_thread_profile) to assist troubleshooting query performance.

Change Tracking Cleanup: A new stored is introduced to cleanup change trackinginternal tables on demand.

AlwaysON Lease Timeout Logging: Added new logging capability forLease Timeout messages so that the current time and the expected renewal timesare logged. Also a new message was introduced in the SQL Errorlog regarding thetimeouts. See the blog for more information.

New DMF for retrieving input buffer in SQLServer: A new DMFfor retrieving the input buffer for a session/request (sys.dm_exec_input_buffer)is now available. This is functionally equivalent to DBCC INPUTBUFFER.

Mitigation for underestimated and overestimatedmemory grant: Addednew query hints for Resource Governor through MIN_GRANT_PERCENT andMAX_GRANT_PERCENT. This allows you to leverage these hints while runningqueries by capping their memory grants to prevent memory contention.

Better memory grant/usage diagnostics: A new extended event was added tothe list of tracing capabilities in SQL Server (query_memory_grant_usage) totrack memory grants requested and granted. This provides better tracing andanalysis capabilities for troubleshooting query execution issues related tomemory grants.

Queryexecution diagnostics for tempdb spill: Hash Warning and Sort Warnings now have additionalcolumns to track physical I/O statistics, memory used and rows affected. Wealso introduced a new hash_spill_details extended event. Now you can track moregranular information for your hash and sort warnings. This improvement is alsonow exposed through the XML Query Plans in the form of a new attribute to theSpillToTempDbType complex type.

Improved diagnostics for query execution plansthat involve residual predicate pushdown: The actual rows read will now be reported inthe query execution plans to help improve query performance troubleshooting.This should negate the need to capture SET STATISTICS IO separately. This nowallows you to see information related to a residual predicate pushdown in aquery plan.


More info:

You can find a lot more info about MS SQL Server 2014 on the internet, alsoall the news in the Service Pack 1 which is included in this installation.

Please notice:

If you have any questions about this item, please ask them before purchasing,because we don’t accept returns of opened software items (the license code isinside the wrapped box, therefore).

Picture 1 is promotional only, Pictures 2 and 3 are the actual photo of theitem.



Buy Now