SQL Server 2014 64-Bit, Standard Edition. Now with Service Pack 2.
Complete with4 Core License.This is the “per-core” License, supporting Servers with up to4Physical Cores.Per-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.
SQL Server 2014 enables customers to build mission-critical applications and
Big Data solutions using high-performance, in-memory technology across OLTP,
data warehousing, business intelligence and analytics workloads without having
to buy expensive add-ons or high-end appliances. SQL Server 2014 uses a common
set 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 existing
SQL Server 2014 makes it easier and more cost effective to build
high-performance, mission-critical applications, enterprise ready Big Data
assets, and BI solutions that help employees make better decisions, faster.
These solutions have the flexibility of being deployed on-premises, in the cloud
or in a hybrid environment, and can be managed through a common and familiar a
SQL Server 2014 accelerates reliable, mission critical applications with a
new in-memory OLTP engine that can deliver on average 10x, and up to 30x
transactional performance gains. For Data Warehousing, the new updatable
in-memory columnstore can query 100x faster than legacy solutions. SQL Server
also delivers peace of mind as the most secure database five years in a row.
With Windows Server, physical processing now scales up to 640 logical
processors, and virtual machines scale up to 64 logical processors. SQL Server
2014 uses this scale, storage spaces and network virtualization to maximize
overall infrastructure utilization. It can also run on Windows Server Core to
lower the surface area of attack.
Standard Edition features:
Core Data Management
Leverage reliable, cost-effective availability, and robust data security
features, powered by easy-to-use tools and functionality.
Built-in cloud capabilities provide a consistent platform to help reduce
costs and quickly scale.
Faster insights across your data
Unlock new insights and operational reporting visibility across the business
with consistent, integrated data.
Principal Editions of SQL Server 2014:
SQL Server Edition
(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.
(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
Standard (64-bit and
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
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
What’s new in SQL Server 2014 with Service Pack 2?
Performance and Scalability Improvements
Automatic Soft NUMA partitioning: With SQL Server 2014 SP2, Automatic
Soft 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 will
interrogate the hardware layout and automatically configure Soft NUMA on
systems reporting 8 or more CPUs per NUMA node. The automatic, soft NUMA
behavior is Hyperthread (HT/logical processor) aware. The partitioning and
creation of additional nodes scales background processing by increasing the
number of listeners, scaling, and network and encryption capabilities. It is
recommended to first test the performance workload with Auto-Soft NUMA before
turning it in production.
Dynamic Memory Object Scaling: SQL Server 2014 SP2 dynamically
partitions memory objects based on number of nodes and cores to scale on modern
hardware. The goal of dynamic promotion is to automatically partition a thread
safe memory object (CMEMTHREAD) if it becomes a bottleneck. Un-partitioned
memory objects can be dynamically promoted to be partitioned by node (number of
partitions equals number of NUMA nodes), and memory objects partitioned by node
can by further promoted to be partitioned by CPU (number of partitions equals
number of CPUs).
MAXDOP hint for DBCC CHECK* commands: This improvement addresses connect
response (468694). You can now run DBCC CHECKDB with the a MAXDOP setting other
than the sp_configure value. If MAXDOP exceeds the value configured with
Resource Governor, the Database Engine uses the Resource Governor MAXDOP value,
described in ALTER WORKLOAD GROUP (Transact-SQL). All semantic rules used with
the max degree of parallelism configuration option are applicable when you use
the MAXDOP query hint.
Enable >8TB for Buffer Pool: SQL Server 2014 SP2 enables 128TB
of virtual address space for buffer pool usage. This improvement enables SQL
Server Buffer Pool to scale beyond 8TB on modern hardware.
SOS_RWLock spinlock Improvement: The SOS_RWLock is a synchronization
primitive used in various places throughout the SQL Server code base. As the
name implies, the code can have multiple shared (readers) or single (writer)
ownership. This improvement removes the need for spinlock for SOS_RWLock and
instead uses lock-free techniques similar to in-memory OLTP. With this change,
many threads can read a data structure protected by SOS_RWLock in parallel
without blocking each other and thereby providing increased scalability. Prior
to this change, the spinlock implementation allowed only one thread to acquire
the SOS_RWLock at a time, even to read a data structure.
Spatial Native Implementation: Significant improvement in spatial
query performance is introduced in SQL Server 2014 SP2 through native
Supportability and Diagnostics Improvements
Database Cloning: Clone database is a new DBCC command that
enhances troubleshooting existing production databases by cloning the schema
and metadata without the data. The clone is created with the command DBCC
‘clone_database_name’). Note: Cloned
databases should not be used in production environments. Use the following
command determine if a database has been generated from a cloned database:
select DATABASEPROPERTYEX('clonedb', 'isClone'). The return value of 1
indicates the database is created from clonedatabase while 0 indicates it is
not a clone.
Tempdb supportability: A new errorlog message that
indicates the number of tempdb files and the size/autogrowth of tempdb data
files present at server startup.
Database Instant File Initialization Logging: A new errorlog message that
indicates on server statup, the status of Database Instant File Initialization
Module names in callstack: The Xevent callstack now includes
modules names + offset instead of absolute addresses.
New DMF for incremental statistics: This improvement addresses connect
response to enable tracking the incremental statistics at the partition level.
A new DMF sys.dm_db_incremental_stats_properties is introduced to expose
information per-partition for incremental stats.
Index Usage DMV behavior updated: This improvement addresses connect
response from customers where rebuilding an index will not clear any existing
row entry from sys.dm_db_index_usage_stats for that index. The behavior will
now be the same as in SQL 2008 and SQL Server 2016.
Improved correlation between diagnostics XE and
improvement addresses connect response (1934583). Query_hash and
query_plan_hash are used for identifying a query uniquely. DMV defines them as
varbinary(8), while XEvent defines them as UINT64. Since SQL server does not
have "unisigned bigint", casting does not always work. This
improvement introduces new XEvent action/filter columns equivalent to
query_hash and query_plan_hash except they are defined as INT64 which can help
correlating queries between XE and DMVs.
Support for UTF-8 in BULK INSERT and BCP: This improvement addresses connect
response where support for export and import of data encoded in UTF-8 character
set is now enabled in BULK INSERT and BCP.
Lightweight per-operator query execution
troubleshooting query performance, although showplan provides lot of
information on the query execution plan and cost of operator in the plan but it
has limited information on actual runtime statistics like (CPU, I/O Reads,
elapsed time per-thread). SQL 2014 SP2 introduces these additional runtime
statistics per operator in the Showplan as well as an XEvent
(query_thread_profile) to assist troubleshooting query performance.
Change Tracking Cleanup: A new stored procedure
sp_flush_CT_internal_table_on_demand is introduced to cleanup change tracking
internal tables on demand.
AlwaysON Lease Timeout Logging: Added new logging capability for
Lease Timeout messages so that the current time and the expected renewal times
are logged. Also a new message was introduced in the SQL Errorlog regarding the
timeouts. See the blog for more information.
New DMF for retrieving input buffer in SQL
Server: A new DMF
for 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 overestimated
memory grant: Added
new query hints for Resource Governor through MIN_GRANT_PERCENT and
MAX_GRANT_PERCENT. This allows you to leverage these hints while running
queries by capping their memory grants to prevent memory contention.
Better memory grant/usage diagnostics: A new extended event was added to
the list of tracing capabilities in SQL Server (query_memory_grant_usage) to
track memory grants requested and granted. This provides better tracing and
analysis capabilities for troubleshooting query execution issues related to
execution diagnostics for tempdb spill: Hash Warning and Sort Warnings now have additional
columns to track physical I/O statistics, memory used and rows affected. We
also introduced a new hash_spill_details extended event. Now you can track more
granular information for your hash and sort warnings. This improvement is also
now exposed through the XML Query Plans in the form of a new attribute to the
SpillToTempDbType complex type.
Improved diagnostics for query execution plans
that involve residual predicate pushdown: The actual rows read will now be reported in
the query execution plans to help improve query performance troubleshooting.
This should negate the need to capture SET STATISTICS IO separately. This now
allows you to see information related to a residual predicate pushdown in a
You can find a lot more info about MS SQL Server 2014 on the internet, also
all the news in the Service Pack 1 which is included in this installation.
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 is
inside the wrapped box, therefore).
Picture 1 is promotional only, Pictures 2 and 3 are the actual photo of the