Editions and supported features of sql server 2019 (15.x)

RDBMS scalability and performance

Feature Enterprise Standard Web Express with Advanced Services Express
Columnstore12 Yes Yes Yes Yes Yes
Large object binaries in clustered columnstore indexes Yes Yes Yes Yes Yes
Online nonclustered columnstore index rebuild Yes No No No No
In-Memory OLTP1 Yes Yes Yes Yes3 Yes
Stretch Database Yes Yes Yes Yes Yes
Persistent Main Memory Yes Yes Yes Yes Yes
Multi-instance support 50 50 50 50 50
Table and index partitioning Yes Yes Yes Yes Yes
Data compression Yes Yes Yes Yes Yes
Resource Governor Yes No No No No
Partitioned Table Parallelism Yes Yes Yes Yes Yes
Multiple Filestream containers Yes Yes Yes Yes Yes
NUMA Aware Large Page Memory and Buffer Array Allocation Yes No No No No
Buffer Pool Extension Yes Yes No No No
I/O Resource Governance Yes No No No No
Read-Ahead Yes No No No No
Advanced Scanning Yes No No No No
Delayed Durability Yes Yes Yes Yes Yes
Automatic Tuning Yes No No No No
Batch Mode Adaptive Joins Yes No No No No
Batch Mode Memory Grant Feedback Yes No No No No
Interleaved Execution for Multi-Statement Table Valued Functions Yes Yes Yes Yes Yes
Bulk insert improvements Yes Yes Yes Yes Yes

1 In-Memory OLTP data size and Columnstore segment cache are limited to the amount of memory specified by edition in the section. The degree of parallelism (DOP) for operations is limited to 2 for SQL Server Standard Edition and 1 for SQL Server Web and Express Editions. This refers to columnstore indexes created over disk-based tables and memory-optimized tables.

2 Aggregate Pushdown, String Predicate Pushdown, and SIMD Optimizations are SQL Server Enterprise Edition scalability enhancements. For more detail, see Columnstore indexes — what’s new.

3 This feature is not included in the LocalDB installation option.

Открытие нового окна командной строкиStart a new command prompt

Если окно командной строки было случайно закрыто, то его можно открыть снова, выполнив следующие действия.If you accidentally close the command prompt, you can start a new command prompt by following these steps:

  1. Нажмите CTRL+SHIFT+ESC, чтобы отобразить диспетчер задач.Press Ctrl+Shift+Esc to display Task Manager.
  2. На вкладке Приложения нажмите Создать задачу.On the Applications tab, click New Task.
  3. В диалоговом окне Создание новой задачи введите cmd в поле Открыть Нажмите кнопку ОК.Click OK., а затем.In the Create New Task dialog box, type cmd in the Open field and then Нажмите кнопку ОК.Click OK..

Выбор правильного варианта

Поскольку организации обычно обновляют SQL Server реже, чем операционные системы, более старая версия может использоваться довольно долгое время, особенно если не требуются функции, добавленные в новое ПО.

Если вы начинаете с нуля, выберите самую новую версию, поддерживающую все ориентированные на вас операционные системы.

Если вы разработчик и хотите в конечном итоге развертываться в уже имеющемся на вашем ПК программном обеспечении, вы можете использовать SQL Server R2 Express, которая соответствует этой или более старой версии, чтобы не вводить функции, которые не существуют на вашем SQL Server.

Более старые варианты ПО обычно работают на новых операционных системах, но официально не указаны на веб-страницах Microsoft. В версиях 2005 года есть предупреждение о возможности возникновения проблем, если они будут установлены в ОС Windows 8.x и новее.

SQL ServerSQL Server , выпускиeditions

Эти выпуски SQL ServerSQL Serverописаны в следующей таблице.The following table describes the editions of SQL ServerSQL Server.

SQL ServerSQL Server editionedition ОпределениеDefinition
EnterpriseEnterprise Выпуск SQL ServerSQL Server Enterprise Edition является предложением класса «Премиум», обеспечивающим полный набор возможностей ЦОД с исключительно высокой производительностью, что позволяет добиться высокого уровня обслуживания важнейших рабочих нагрузок.The premium offering, SQL ServerSQL Server Enterprise edition delivers comprehensive high-end datacenter capabilities with blazing-fast performance enabling high service levels for mission-critical workloads.
StandardStandard Выпуск SQL ServerSQL Server Standard обеспечивает основные функции управления данными для приложений, работающих в отделах и небольших организациях. Поддерживаются распространенные средства разработки в локальных системах и вычислительных облаках, что делает возможным эффективное управление базами данных с минимальными затратами ИТ-ресурсов.SQL ServerSQL Server Standard edition delivers basic data management for departments and small organizations to run their applications and supports common development tools for on-premises and cloud — enabling effective database management with minimal IT resources.
ИнтернетWeb ВыпускSQL ServerSQL Server Web Edition — это вариант с низкой совокупной стоимостью владения, предназначенный для размещения веб-сайтов и дополнительных веб-услуг, который по доступной цене обеспечивает масштабируемость и функции управления для небольших и крупномасштабных веб-проектов.SQL ServerSQL Server 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.
РазработчикDeveloper ВыпускSQL ServerSQL Server Developer Edition позволяет разработчикам создавать приложения любого типа на базе SQL ServerSQL Server.SQL ServerSQL Server Developer edition lets developers build any kind of application on top of SQL ServerSQL Server. Он включает все функциональные возможности выпуска Enterprise Edition, однако лицензируется как система для разработки и тестирования, а не для применения в качестве рабочего сервера.It includes all the functionality of Enterprise edition, but is licensed for use as a development and test system, not as a production server. Выпуск SQL ServerSQL Server Developer Edition является идеальным выбором для тех, кто создает и тестирует приложения.SQL ServerSQL Server Developer is an ideal choice for people who build and test applications.
ExpressExpress edition Выпуск Express является бесплатной базой данных начального уровня и идеально подходит для обучения, а также для создания управляемых данными приложений, работающих на рабочих станциях и небольших серверах.Express edition is the entry-level, free database and is ideal for learning and building desktop and small server data-driven applications. Этот выпуск — лучший выбор для независимых поставщиков программного обеспечения, непрофессиональных разработчиков и любителей, создающих клиентские приложения.It is the best choice for independent software vendors, developers, and hobbyists building client applications. Если необходимы дополнительные функции базы данных, выпуск SQL ServerSQL Server Express можно легко обновить до версий SQL ServerSQL Serverболее высокого класса.If you need more advanced database features, SQL ServerSQL Server Express can be seamlessly upgraded to other higher end versions of SQL ServerSQL Server.

Description

The LocalDB setup program uses the program to install the necessary files on the computer. Once installed, LocalDB is an instance of SQL Server Express that can create and open SQL Server databases. The system database files for the database are stored in the local AppData path, which is normally hidden. For example, . User database files are stored where the user designates, typically somewhere in the folder.

For more information about including LocalDB in an application, see Visual Studio Local Data Overview, Create a database and add tables in Visual Studio.

For more information about the LocalDB API, see SQL Server Express LocalDB Reference.

The utility can create new instances of LocalDB, start and stop an instance of LocalDB, and includes options to help you manage LocalDB.For more information about the utility, see SqlLocalDB Utility.

The instance collation for LocalDB is set to and cannot be changed. Database-level, column-level, and expression-level collations are supported normally. Contained databases follow the metadata and collations rules defined by Contained Database Collations.

Restrictions

  • LocalDB cannot be patched beyond Service Packs. CUs and Security Updates cannot be applied manually and will not be applied via Windows Update, Windows Update for Business, or other methods.

  • LocalDB cannot be managed remotely via SQL Management Studio.

  • LocalDB cannot be a merge replication subscriber.

  • LocalDB does not support FILESTREAM.

  • LocalDB only allows local queues for Service Broker.

  • An instance of LocalDB owned by the built-in accounts such as can have manageability issues due to windows file system redirection. Instead use a normal windows account as the owner.

Automatic and named instances

LocalDB supports two kinds of instances: Automatic instances and named instances.

  • Automatic instances of LocalDB are public. They are created and managed automatically for the user and can be used by any application. One automatic instance of LocalDB exists for every version of LocalDB installed on the user’s computer. Automatic instances of LocalDB provide seamless instance management. There is no need to create the instance; it just works. This feature allows for easy application installation and migration to a different computer. If the target machine has the specified version of LocalDB installed, the automatic instance of LocalDB for that version is available on the target machine as well. Automatic instances of LocalDB have a special pattern for the instance name that belongs to a reserved namespace. Automatic instances prevents name conflicts with named instances of LocalDB. The name for the automatic instance is MSSQLLocalDB.

  • Named instances of LocalDB are private. They are owned by a single application that is responsible for creating and managing the instance. Named instances provide isolation from other instances and can improve performance by reducing resource contention with other database users. Named instances must be created explicitly by the user through the LocalDB management API or implicitly via the app.config file for a managed application (although managed application may also use the API, if desired). Each named instance of LocalDB has an associated LocalDB version that points to the respective set of LocalDB binaries. The instance name of a LocalDB is sysname data type and can have up to 128 characters. (This differs from regular named instances of SQL Server, which limits names to regular NetBIOS names of 16 ASCII chars.) The name of an instance of LocalDB can contain any Unicode characters that are legal within a filename.A named instance that uses an automatic instance name becomes an automatic instance.

Different users of a computer can have instances with the same name. Each instance is a different processes running as a different user.

Технические особенности

Данная версия поставляется с Express Manager и диспетчером компьютеров, двумя инструментами GUI для настройки и установки. Версия ограничивается использованием общей памяти в локальной системе. Подключение к базе данных может осуществляться через TCP/IP или именованные каналы. Тем не менее веб-доступ через HTTP или высокопроизводительный доступ с использованием VIA не поддерживается. Вы должны специально включить сетевое взаимодействие с Express, и подключенный пользователь должен включить службу браузера SQL Server, чтобы выполнить сетевое подключение. Общая память не использует службу Browser.

Deciding among SQL Server components

Use the Feature Selection page of the SQL Server Installation Wizard to select the components to include in an installation of SQL Server. By default, none of the features in the tree are selected.

Use the information in the following tables to determine the set of features that best fits your needs.

Server components Description
SQL Server Database Engine SQL Server Database Engine includes the Database Engine, the core service for storing, processing, and securing data, replication, full-text search, tools for managing relational and XML data, in database analytics integration, and PolyBase integration for access to Hadoop and other heterogeneous data sources, and the Data Quality Services (DQS) server.
Analysis Services Analysis Services includes the tools for creating and managing online analytical processing (OLAP) and data mining applications.
Reporting Services Reporting Services includes server and client components for creating, managing, and deploying tabular, matrix, graphical, and free-form reports. Reporting Services is also an extensible platform that you can use to develop report applications.
Integration Services Integration Services is a set of graphical tools and programmable objects for moving, copying, and transforming data. It also includes the Data Quality Services (DQS) component for Integration Services.
Master Data Services Master Data Services (MDS) is the SQL Server solution for master data management. MDS can be configured to manage any domain (products, customers, accounts) and includes hierarchies, granular security, transactions, data versioning, and business rules, as well as an Add-in for Excel that can be used to manage data.
Machine Learning Services (In-Database) Machine Learning Services (In-Database) supports distributed, scalable machine learning solutions using enterprise data sources. In SQL Server 2016, the R language was supported. SQL Server 2017 supports R and Python.
Machine Learning Server (Standalone) Machine Learning Server (Standalone) supports deployment of distributed, scalable machine learning solutions on multiple platforms and using multiple enterprise data sources, including Linux and Hadoop. In SQL Server 2016, the R language was supported. SQL Server 2017 supports R and Python.
Management tools Description
SQL Server Management Studio SQL Server Management Studio is an integrated environment to access, configure, manage, administer, and develop components of SQL Server. Management Studio lets developers and administrators of all skill levels use SQL Server. Download and install Management Studio from Download SQL Server Management Studio
SQL Server Configuration Manager SQL Server Configuration Manager provides basic configuration management for SQL Server services, server protocols, client protocols, and client aliases.
SQL Server Profiler SQL Server Profiler provides a graphical user interface to monitor an instance of the Database Engine or Analysis Services.
Database Engine Tuning Advisor Database Engine Tuning Advisor helps create optimal sets of indexes, indexed views, and partitions.
Data Quality Client Provides a highly simple and intuitive graphical user interface to connect to the DQS server, and perform data cleansing operations. It also allows you to centrally monitor various activities performed during the data cleansing operation.
SQL Server Data Tools SQL Server Data Tools provides an IDE for building solutions for the Business Intelligence components: Analysis Services, Reporting Services, and Integration Services. (Formerly called Business Intelligence Development Studio). SQL Server Data Tools also includes «Database Projects», which provides an integrated environment for database developers to carry out all their database design work for any SQL Server platform (both on and off premise) within Visual Studio. Database developers can use the enhanced Server Explorer in Visual Studio to easily create or edit database objects and data, or execute queries.
Connectivity Components Installs components for communication between clients and servers, and network libraries for DB-Library, ODBC, and OLE DB.
Documentation Description
SQL Server Books Online Core documentation for SQL Server.

Developer and Evaluation Editions
For features supported by Developer and Evaluation editions, see features listed for the SQL Server Enterprise Edition in the tables below.

The Developer edition continues to support only 1 client for SQL Server Distributed Replay.

Download SQL Server Express edition

After downloading the setup package, we can start the installation steps. We will right-click the installation file which is named SQL2019-SSEI-Expr.exe and select the Open option in order to start the installation process. In this step, we must make sure that the logged-on user already has the necessary rights to install the programs on the computer. Otherwise, we can face problems during the installation steps:

After starting the installation, we have to choose the installation type of the SQL Express edition:

The Basic installation method is the quickest and easiest installation method to install the SQL Server Database Engine with the default configuration.

The Download Media option also allows us to download the setup files for offline installations:

The Custom installation method offers more advanced installation options so that we can configure the features and other options of the SQL Server installation. We will use the Custom installation method. In the next screen, we will set the path of the setup files to be downloaded and then click the Install button:

The downloading process will be started and the elapsed time for this operation can be varying according to your internet connection speed:

Replication

Feature Enterprise Standard Web Express with Advanced Services Express
Heterogeneous subscribers Yes Yes No No No
Merge replication Yes Yes Yes (Subscriber only) Yes (Subscriber only) Yes (Subscriber only)
Oracle publishing Yes No No No No
Peer to peer transactional replication Yes No No No No
Snapshot replication Yes Yes Yes (Subscriber only) Yes (Subscriber only) Yes (Subscriber only)
SQL Server change tracking Yes Yes Yes Yes Yes
Transactional replication Yes Yes Yes (Subscriber only) Yes (Subscriber only) Yes (Subscriber only)
Transactional replication to Azure Yes Yes No No No
Transactional replication updateable subscription Yes Yes No No No

Технологии

Движок БД

Это основной сервис для хранения, обработки и защиты данных. Компоненты Database Engine обеспечивает контролируемый доступ и быструю обработку транзакций для удовлетворения требований самых требовательных приложений, потребляющих данные, на предприятии. Database Engine также обеспечивает расширенную поддержку для обеспечения высокой доступности.

Репликация

Репликация — это набор технологий для копирования и распределения данных и объектов базы данных из одной базы данных в другую, а затем синхронизации между базами данных для обеспечения согласованности. Используя репликацию, мжно распространять данные в разных местах, в том числе мобильным пользователям с помощью локальных и глобальных сетей, подключений удаленного доступа, беспроводных подключений и Интернета.

Integration Services

Integration Services — это платформа для создания высокопроизводительных решений для интеграции данных, включая пакеты, которые обеспечивают обработку извлечения, преобразования и загрузки (ETL) для хранилищ данных.

Analysis Services

Analysis Services — это аналитическая платформа данных и набор инструментов для личной, командной и корпоративной бизнес-аналитики. Разработчики серверов и клиентов поддерживают традиционные решения OLAP, новые решения для табличного моделирования, а также аналитику самообслуживания и совместную работу с использованием Power Pivot, Excel и среды SharePoint Server. Службы Analysis Services также включают интеллектуальный анализ данных, для раскрытия скрытых шаблонов, в больших объемах данных .

Высокий уровень доступности реляционной СУБДRDBMS high availability

КомпонентFeature EnterpriseEnterprise StandardStandard ИнтернетWeb ExpressExpress
доставка журналов;Log shipping ДаYes ДаYes ДаYes нетNo
Сжатие резервных копийBackup compression ДаYes ДаYes НетNo нетNo
Моментальный снимок базы данныхDatabase snapshot ДаYes ДаYes НетNo нетNo
Экземпляр отказоустойчивого кластера Always On 1Always On failover cluster instance1 ДаYes ДаYes НетNo нетNo
Группы доступности Always On 2Always On availability groups2 ДаYes НетNo НетNo нетNo
Базовые группы доступности 3Basic availability groups 3 нетNo ДаYes НетNo нетNo
Группа доступности с минимальным числом реплик для фиксацииMinimum replica commit availability group ДаYes ДаYes НетNo нетNo
Группа доступности без кластеровClusterless availability group ДаYes ДаYes НетNo нетNo
Восстановление страниц и файлов в режиме «в сети»Online page and file restore ДаYes НетNo НетNo нетNo
Индексирование в сетиOnline indexing ДаYes НетNo НетNo нетNo
Возобновляемая перестройка индексов в подключенном режимеResumable online index rebuilds ДаYes НетNo НетNo нетNo
Изменение схемы в режиме «в сети»Online schema change ДаYes НетNo НетNo нетNo
Быстрое восстановлениеFast recovery ДаYes НетNo НетNo нетNo
Зеркальные резервные копииMirrored backups ДаYes НетNo НетNo нетNo
Поддержка памяти и ЦП с «горячей» заменойHot add memory and CPU ДаYes НетNo НетNo нетNo
Зашифрованная резервная копияEncrypted backup ДаYes ДаYes НетNo нетNo
Гибридное резервное копирование в Azure (резервное копирование по URL-адресу)Hybrid backup to Azure (backup to URL) ДаYes ДаYes НетNo нетNo

1 В выпуске Enterprise количество узлов равно максимуму, поддерживаемому операционной системой.1 On Enterprise edition, the number of nodes is the operating system maximum. В выпуске Standard поддерживается два узла.On Standard edition, there is support for two nodes.

2 В выпуске Enterprise поддерживается до 8 вторичных реплик, включая 2 синхронные вторичные реплики.2 On Enterprise edition, provides support for up to 8 secondary replicas — including 2 synchronous secondary replicas.

3 В выпуске Standard поддерживаются базовые группы доступности.3 Standard edition supports basic availability groups. Базовая группа доступности поддерживает две реплики с одной базой данных.A basic availability group supports two replicas, with one database. Дополнительные сведения о базовых группах доступности см. в разделе Базовые группы доступности.For more information about basic availability groups, see Basic Availability Groups.

Install LocalDB

Install LocalDB through the installation wizard or by using the SqlLocalDB.msi program. LocalDB is an option when installing SQL Server Express LocalDB.

Select LocalDB on the Feature Selection/Shared Features page during installation. There can be only one installation of the LocalDB binary files for each major SQL Server Database Engine version. Multiple Database Engine processes can be started and will all use the same binaries. An instance of the SQL Server Database Engine started as the LocalDB has the same limitations as SQL Server Express.

An instance of SQL Server Express LocalDB is managed by using the utility. SQL Server Express LocalDB should be used in place of the SQL Server Express user instance feature, which was deprecated.

Using SQL Server with client/server applications

You can install just the SQL Server client components on a computer that is running client/server applications that connect directly to an instance of SQL Server. A client components installation is also a good option if you administer an instance of SQL Server on a database server, or if you plan to develop SQL Server applications.

The client tools option installs the following SQL Server features: backward compatibility components, SQL Server Data Tools, connectivity components, management tools, software development kit, and SQL Server Books Online components. For more information, see Install SQL Server.

Running with IIS

On an internet server, such as a server that is running Internet Information Services (IIS), you will typically install the SQL Server client tools. Client tools include the client connectivity components used by an application connecting to an instance of SQL Server.

Note

Although you can install an instance of SQL Server on a computer that is running IIS, this is typically done only for small Web sites that have a single server computer. Most Web sites have their middle-tier IIS systems on one server or a cluster of servers, and their databases on a separate server or federation of servers.

RDBMS scalability and performance

Feature Enterprise Standard Web Express withAdvanced Services Express
Columnstore12 Yes Yes Yes Yes Yes
Large object binaries in clustered columnstore indexes Yes Yes Yes Yes Yes
Online non-clustered columnstore index rebuild Yes No No No No
In-Memory Database: In-Memory OLTP1 Yes Yes Yes Yes3 Yes
In-Memory Database: hybrid buffer pool Yes Yes No No No
In-Memory Database: memory-optimized tempdb metadata Yes No No No No
In-Memory Database: persistent memory support Yes Yes Yes Yes Yes
Stretch database Yes Yes Yes Yes Yes
Multi-instance support 50 50 50 50 50
Table and index partitioning Yes Yes Yes Yes Yes
Data compression Yes Yes Yes Yes Yes
Resource governor Yes No No No No
Partitioned table parallelism Yes Yes Yes Yes Yes
Multiple filestream containers Yes Yes Yes Yes Yes
NUMA aware and large page memory and buffer array allocation Yes No No No No
Buffer pool extension Yes Yes No No No
I/O resource governance Yes No No No No
Read-ahead Yes No No No No
Advanced scanning Yes No No No No
Delayed durability Yes Yes Yes Yes Yes
Intelligent Database: automatic tuning Yes No No No No
Intelligent Database: batch mode for row store 1 Yes No No No No
Intelligent Database: row mode memory grant feedback Yes No No No No
Intelligent Database: approximate count distinct Yes Yes Yes Yes Yes
Intelligent Database: table variable deferred compilation Yes Yes Yes Yes Yes
Intelligent Database: scalar UDF inlining Yes Yes Yes Yes Yes
Batch mode adaptive joins Yes No No No No
Batch mode memory grant feedback Yes No No No No
Interleaved execution for multi-statement table valued functions Yes Yes Yes Yes Yes
Bulk insert improvements Yes Yes Yes Yes Yes

1 In-Memory OLTP data size and Columnstore segment cache are limited to the amount of memory specified by edition in the section. The degree of parallelism (DOP) for operations is limited to 2 for SQL Server Standard Edition and 1 for SQL Server Web and Express Editions. This refers to columnstore indexes created over disk-based tables and memory-optimized tables.

2 Aggregate Pushdown, String Predicate Pushdown, and SIMD Optimizations are SQL Server Enterprise Edition scalability enhancements. For more detail, see Columnstore indexes — what’s new.

3 This feature is not included in the LocalDB installation option.

Using SQL Server with client/server applications

You can install just the SQL Server client components on a computer that is running client/server applications that connect directly to an instance of SQL Server. A client components installation is also a good option if you administer an instance of SQL Server on a database server, or if you plan to develop SQL Server applications.

The client tools option installs the following SQL Server features: backward compatibility components, SQL Server Data Tools, connectivity components, management tools, software development kit, and SQL Server Books Online components. For more information, see Install SQL Server.

Добавить комментарий

Ваш адрес email не будет опубликован. Обязательные поля помечены *

Adblock
detector