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

Возможности

SQL Server Express предоставляет множество возможностей платных, полных версий системы управления базами данных Microsoft SQL Server. Однако он имеет технические ограничения, которые делают его непригодным для некоторых крупномасштабных развертываний.

В отличие от MSDE, Express не включает параллельный регулятор рабочей нагрузки для ограничения производительности, если компонент Database Engine получает больше работы, чем обычно для небольшого числа пользователей.

SQL Server Express включает несколько графических средств для управления базами данных. К ним относятся:

  • SQL Server Management Studio
  • SQL Server Configuration Manager
  • SQL Server Surface Area Configuration tool
  • SQL Server Business Intelligence Development Studio

Функции, доступные в выпусках SQL Server «Standard» и «better», но отсутствующие в SQL Server Express:

Службы Анализа
службы интеграции
Службы Уведомлений

Management tools

Feature Enterprise Standard Web Express with Advanced Services Express
SQL Management Objects (SMO) Yes Yes Yes Yes Yes
SQL Assessment API Yes Yes Yes Yes Yes
SQL Vulnerability Assessment Yes Yes Yes Yes Yes
SQL Configuration Manager Yes Yes Yes Yes Yes
SQL CMD (Command Prompt tool) Yes Yes Yes Yes Yes
Distributed Replay — Admin Tool Yes Yes Yes Yes No
Distribute Replay — Client Yes Yes Yes No No
Distributed Replay — Controller Yes1 Yes2 Yes2 No No
SQL Profiler Yes Yes No3 No3 No3
SQL Server Agent Yes Yes Yes No No
Microsoft System Center Operations Manager Management Pack Yes Yes Yes No No
Database Tuning Advisor (DTA) Yes Yes4 Yes4 No No

1 Up to 16 clients

2 1 client

3 SQL Server Web, SQL Server Express, SQL Server Express with Tools, and SQL Server Express with Advanced Services can be profiled using SQL Server Standard and SQL Server Enterprise editions.

4 Tuning enabled only on Standard edition features

Работа пользовательских экземпляровHow User Instances Work

При первом создании пользовательского экземпляра для любого пользователя системные базы данных master и msdb копируются из папки Template Data в локальный пользовательский каталог-репозиторий для монопольного использования пользовательским экземпляром.The first time a user instance is generated for each user, the master and msdb system databases are copied from the Template Data folder to a path under the user’s local application data repository directory for exclusive use by the user instance. Этот путь обычно выглядит следующим образом: .This path is typically . При запуске пользовательского экземпляра база данных tempdb журнал и файлы трассировки также записываются в этот каталог.When a user instance starts up, the tempdb, log, and trace files are also written to this directory. Для экземпляра создается имя, которое гарантированно будет уникальным для каждого пользователя.A name is generated for the instance, which is guaranteed to be unique for each user.

По умолчанию всем участникам группы Builtin\Users Windows предоставляются разрешения на подключение к локальному экземпляру, а также разрешения на чтение и выполнение для двоичных файлов SQL Server.By default all members of the Windows Builtin\Users group are granted permissions to connect on the local instance as well as read and execute permissions on the SQL Server binaries. После проверки учетных данных вызывающего пользователя, размещающего пользовательский экземпляр, этот пользователь станет на этом экземпляре.Once the credentials of the calling user hosting the user instance have been verified, that user becomes the on that instance. Для пользовательских экземпляров включена только общая память, то есть возможны только операции на локальном компьютере.Only shared memory is enabled for user instances, which means that only operations on the local machine are possible.

Пользователи должны иметь разрешения на чтение и запись для файлов MDF и LDF, указанных в строке подключения.Users must be granted both read and write permissions on the .mdf and .ldf files specified in the connection string.

Примечание

MDF и LDF представляют файлы базы данных и журнала соответственно.The .mdf and .ldf files represent the database and log files, respectively. Эти два файла являются сопоставленным набором

Таким образом во время операций резервного копирования и восстановления необходимо соблюдать осторожность.These two files are a matched set, so care must be taken during backup and restore operations. Файл базы данных содержит сведения о точной версии файла журнала

База данных не будет открываться, если она связана с неверным файлом журнала.The database file contains information about the exact version of the log file, and the database will not open if it is coupled with the wrong log file.

Чтобы избежать повреждения данных, база данных в пользовательском экземпляре открывается с монопольным доступом.To avoid data corruption, a database in the user instance is opened with exclusive access. Если два разных пользовательских экземпляра совместно используют одну и ту же базу данных на одном компьютере, пользователь первого экземпляра должен закрыть базу данных, прежде чем ее можно будет открыть во втором экземпляре.If two different user instances share the same database on the same computer, the user on the first instance must close the database before it can be opened in a second instance.

Требования к программному обеспечениюSoftware requirements

Следующие требования относятся ко всем видам установки.The following requirements apply to all installations:

КомпонентComponent ТребованиеRequirement
Операционная системаOperating system Windows 10 TH1 1507 или более поздней версииWindows 10 TH1 1507 or greaterWindows Server 2016 или более поздней версииWindows Server 2016 or greater
.NET Framework.NET Framework Минимальная версия операционной системы подразумевает минимальную версию платформы .NET Framework.Minimum operating systems includes minimum .NET framework.
Сетевое программное обеспечениеNetwork Software Поддерживаемые операционные системы для SQL ServerSQL Server содержат встроенное сетевое программное обеспечение.Supported operating systems for SQL ServerSQL Server have built-in network software. Именованные экземпляры и экземпляры по умолчанию изолированной установки поддерживают следующие сетевые протоколы: Shared memory, Named Pipes и TCP/IP.Named and default instances of a stand-alone installation support the following network protocols: Shared memory, Named Pipes, and TCP/IP.

Программа установкиSQL ServerSQL Server устанавливает следующие компоненты, необходимые для продукта:SQL ServerSQL Server Setup installs the following software components required by the product:

  • Собственный клиент SQL ServerSQL ServerSQL ServerSQL Server Native Client
  • SQL ServerSQL Server Файлы поддержки программы установкиSetup support files

Важно!

Для компонента PolyBase существуют дополнительные аппаратные и программные требования.There are additional hardware and software requirements for the PolyBase feature. Дополнительные сведения см. в разделе Приступая к работе с PolyBase.For more information, see Get started with PolyBase.

Возможности пользовательского экземпляраUser Instance Capabilities

Пользовательские экземпляры полезны для пользователей, работающих под управлением Windows с учетной записью пользователя с минимальными правами доступа (LUA).User instances are useful for users who are running Windows under a least-privilege user account (LUA). Каждый пользователь имеет права SQL Server системного администратора ( ) для экземпляра, работающего на своем компьютере, без необходимости запуска от имени администратора Windows.Each user has SQL Server system administrator () privileges over the instance running on their computer without needing to run as a Windows administrator as well. Программное обеспечение, выполняемое в пользовательском экземпляре с ограниченными разрешениями, не может вносить изменения на уровне системы, так как экземпляр SQL Server Express работает под учетной записью пользователя Windows без прав администратора, а не как служба.Software executing on a user instance with limited permissions cannot make system-wide changes because the instance of SQL Server Express is running under the non-administrator Windows account of the user, not as a service. Каждый пользовательский экземпляр изолирован от родительского и любых других пользовательских экземпляров, выполняющихся на том же компьютере.Each user instance is isolated from its parent instance and from any other user instances running on the same computer. Базы данных, запущенные в пользовательском экземпляре, открываются только в однопользовательском режиме. Таким образом несколько пользователей не могут подключаться к базам данных, запущенным в пользовательском экземпляре.Databases running on a user instance are opened in single-user mode only, and it is not possible for multiple users to connect to databases running on a user instance. Репликация и распределенные запросы также отключены для пользовательских экземпляров.Replication and distributed queries are also disabled for user instances.

Примечание

Пользовательские экземпляры не требуются для пользователей, которые уже являются администраторами на своих компьютерах, или для сценариев, включающих несколько пользователей базы данных.User instances are not needed for users who are already administrators on their own computers, or for scenarios involving multiple database users.

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.

Scale limits

Feature Enterprise Standard Web Express withAdvanced Services Express
Maximum compute capacity used by a single instance — SQL Server Database Engine1 Operating system maximum Limited to lesser of 4 sockets or 24 cores Limited to lesser of 4 sockets or 16 cores Limited to lesser of 1 socket or 4 cores Limited to lesser of 1 socket or 4 cores
Maximum compute capacity used by a single instance — Analysis Services or Reporting Services Operating system maximum Limited to lesser of 4 sockets or 24 cores Limited to lesser of 4 sockets or 16 cores Limited to lesser of 1 socket or 4 cores Limited to lesser of 1 socket or 4 cores
Maximum memory for buffer pool per instance of SQL Server Database Engine Operating System Maximum 128 GB 64 GB 1410 MB 1410 MB
Maximum memory for Columnstore segment cache per instance of SQL Server Database Engine Unlimited memory 32 GB 16 GB 352 MB 352 MB
Maximum memory-optimized data size per database in SQL Server Database Engine Unlimited memory 32 GB 16 GB 352 MB 352 MB
Maximum memory utilized per instance of Analysis Services Operating System Maximum 16 GB2 64 GB3 N/A N/A N/A
Maximum memory utilized per instance of Reporting Services Operating System Maximum 64 GB 64 GB 4 GB N/A
Maximum relational database size 524 PB 524 PB 524 PB 10 GB 10 GB

1 Enterprise Edition with Server + Client Access License (CAL) based licensing (not available for new agreements) is limited to a maximum of 20 cores per SQL Server instance. There are no limits under the Core-based Server Licensing model. For more information, see Compute Capacity Limits by Edition of SQL Server.

2 Tabular

3 MOLAP

Shared instances of LocalDB

To support scenarios where multiple users of the computer need to connect to a single instance of LocalDB, LocalDB supports instance sharing. An instance owner can choose to allow the other users on the computer to connect the instance. Both automatic and named instances of LocalDB can be shared. To share an instance of LocalDB, a user selects a shared name (alias) for it. Because the shared name is visible to all users of the computer, this shared name must be unique on the computer. The shared name for an instance of LocalDB has the same format as the named instance of LocalDB.

Only an administrator on the computer can create a shared instance of LocalDB. A shared instance of LocalDB can be unshared by an administrator or by the owner of the shared instance of LocalDB. To share and unshared an instance of LocalDB, use the and methods of the LocalDB API, or the share and unshared options of the utility.

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 Machine Learning Services to run Python and R scripts with relational data.
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 2019 (15.x) 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 2019 (15.x) supports R and Python.
Management tools Description
SQL Server Management Studio SQL Server Management Studio (SSMS) is an integrated environment to access, configure, manage, administer, and develop components of SQL Server. SSMS lets developers and administrators of all skill levels use SQL Server. The latest edition of SSMS updates SMO, which includes the SQL Assessment API. 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.

Включение пользовательских экземпляровEnabling User Instances

Для создания пользовательских экземпляров требуется запуск родительского экземпляра SQL Server Express.To generate user instances, a parent instance of SQL Server Express must be running. Пользовательские экземпляры по умолчанию включаются, если установлен SQL Server Express, и они могут быть явно включаться или отключаться системным администратором, выполняющим системную хранимую процедуру sp_configure в родительском экземпляре.User instances are enabled by default when SQL Server Express is installed, and they can be explicitly enabled or disabled by a system administrator executing the sp_configure system stored procedure on the parent instance.

Для пользовательских экземпляров поддерживается только сетевой протокол локальных именованных каналов.The network protocol for user instances must be local Named Pipes. Пользовательский экземпляр невозможно запустить на удаленном экземпляре SQL Server, а учетные данные SQL Server запрещено использовать.A user instance cannot be started on a remote instance of SQL Server, and SQL Server logins are not allowed.

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

RDBMS manageability

Feature Enterprise Standard Web Express withAdvanced Services Express
User instances No No No Yes Yes
LocalDB No No No Yes No
Dedicated admin connection Yes Yes Yes Yes1 Yes1
SysPrep support2 Yes Yes Yes Yes Yes
PowerShell scripting support3 Yes Yes Yes Yes Yes
Support for data-tier application component operations — extract, deploy, upgrade, delete Yes Yes Yes Yes Yes
Policy automation (check on schedule and change) Yes Yes Yes No No
Performance data collector Yes Yes Yes No No
Able to enroll as a managed instance in multi-instance management Yes Yes Yes No No
Standard performance reports Yes Yes Yes No No
Plan guides and plan freezing for plan guides Yes Yes Yes No No
Direct query of indexed views (using NOEXPAND hint) Yes Yes Yes Yes Yes
Direct query SQL Server Analysis Services Yes Yes No No Yes
Automatic indexed views maintenance Yes Yes Yes No No
Distributed partitioned views Yes No No No No
Parallel indexed operations Yes No No No No
Automatic use of indexed view by query optimizer Yes No No No No
Parallel consistency check Yes No No No No
SQL Server Utility Control Point Yes No No No No
Buffer pool extension Yes Yes No No No
Master instance for big data cluster Yes Yes No No No
Compatibility certification Yes Yes Yes Yes Yes

1 With trace flag

2 For more information, see Considerations for Installing SQL Server Using SysPrep.

3 On Linux, PowerShell scripts are supported, from Windows computers targeting SQL Server on Linux.

Сравнение с Microsoft SQL Server

Основные отличия

Максимальный размер в 10 ГБ на базу данных в SQL Server 2016, SQL Server 2014, SQL Server 2012 и 2008 R2 Express (4 ГБ для SQL Server 2008 Express и более ранних версий; по сравнению с 2 ГБ в прежнем MSDE). Ограничение применяется для каждой базы данных (исключая файлы журналов), но в некоторых сценариях пользователи можно получить доступ к большему количеству данных с помощью нескольких взаимосвязанных баз данных.

Нет сервиса SQL Server Agent.

  • Ограничения на использование физического оборудования:
    • Один физический процессор, но разрешено использовать многоядерный.
    • 1 ГБ ОЗУ (работает в системе с большим объемом ОЗУ, но использует не более 1 ГБ на экземпляр компонента SQL Server Database Engine). Express с дополнительными сервисами имеет ограничение в 4 ГБ на экземпляр Reporting Services (недоступно в других вариантах Express). Службы Analysis Services недоступны для экспресс-вариантов.

В отличие от MSDE, Express не включает параллельный регулятор рабочей нагрузки для ограничения производительности, если компонент Database Engine получает больше работы, чем обычно для небольшого числа пользователей .

Поддерживаемые компонентыSupported Features

В следующей таблице можно найти компоненты, которые поддерживаются в SQL ServerSQL Server в установке Server Core.Use the following table to find which features are supported in SQL ServerSQL Server on a Server Core installation .

КомпонентFeature ПоддерживаетсяSupported Дополнительные сведенияAdditional Information
СлужбыКомпонент Database EngineDatabase EngineКомпонент Database EngineDatabase Engine Services ДаYes
SQL ServerSQL Server РепликацияReplication ДаYes
Полнотекстовый поискFull Text Search ДаYes
Службы Analysis ServicesAnalysis Services ДаYes
Службы R (в базе данных)R Services (In-Database) ДаYes
Службы Reporting ServicesReporting Services НетNo
SQL ServerSQL Server Data Tools (SSDT)Data Tools (SSDT) НетNo
Средства связи клиентских средствClient Tools Connectivity ДаYes
Сервер служб Integration ServicesIntegration Services Server ДаYes
Обратная совместимость клиентских средствClient Tools Backward Compatibility НетNo
Пакет SDK клиентских средствClient Tools SDK НетNo
Электронная документация поSQL ServerSQL ServerSQL ServerSQL Server Books Online НетNo
Основные средства управленияManagement Tools — Basic Только удаленныеRemote Only Установка этих компонентов на Server Core не поддерживается.Installation of these features on Server Core is not supported. Эти компоненты могут быть установлены на сервере, отличном от Server Core, и подключены к службам Компонент Database EngineDatabase Engine, установленным в Server Core.These components can be installed on a different server that is not Server Core and connected to the Компонент Database EngineDatabase Engine services installed on Server Core.
Средства управления — полный наборManagement Tools — Complete Только удаленныеRemote Only Установка этих компонентов на Server Core не поддерживается.Installation of these features on Server Core is not supported. Эти компоненты могут быть установлены на сервере, отличном от Server Core, и подключены к службам Компонент Database EngineDatabase Engine, установленным в Server Core.These components can be installed on a different server that is not Server Core and connected to the Компонент Database EngineDatabase Engine services installed on Server Core.
Контроллер распределенного воспроизведенияDistributed Replay Controller НетNo
Клиент распределенного воспроизведенияDistributed Replay Client Только удаленныеRemote Only Установка этих компонентов на Server Core не поддерживается.Installation of these features on Server Core is not supported. Эти компоненты могут быть установлены на сервере, отличном от Server Core, и подключены к службам Компонент Database EngineDatabase Engine, установленным в Server Core.These components can be installed on a different server that is not Server Core , and connected to the Компонент Database EngineDatabase Engine services installed on Server Core.
Пакет SDK для подключения клиентов SQLSQL Client Connectivity SDK ДаYes
Microsoft Sync FrameworkMicrosoft Sync Framework ДаYes Платформа Microsoft Sync Framework не входит в установочный пакет SQL ServerSQL Server .Microsoft Sync Framework is not included in the SQL ServerSQL Server installation package. Вы можете скачать соответствующую версию Sync Framework в Центре загрузки Майкрософт (https://go.microsoft.com/fwlink/?LinkId=221788) и установить ее на компьютер, где работает установка Server Core.You can download the appropriate version of Sync Framework from this Microsoft Download Center (https://go.microsoft.com/fwlink/?LinkId=221788) page and install it on a computer that is running Server Core.
Службы Master Data ServicesMaster Data Services НетNo
Data Quality ServicesData Quality Services НетNo

Версии

Версия 2016 была выпущена в трех модификациях:

  • SP1 Express — это основное предложение для экспресс-доставки, поставляется с базовыми функциями. Кроме того, такие возможности, как динамическая маскировка данных и безопасность на уровне строк, теперь доступны в Express.

  • Express с расширенными службами — эта версия содержит большее количество функций. Включены механизм реляционной базы данных, Management Studio, отчетность и полнотекстовый поиск. Идеально подходит для разработчиков, работающих с меньшими приложениями, которым необходимо внедрить отчетность в своих субъектах.

  • Express LocalDB — эта редакция в основном используется в качестве инструмента разработки. Это наиболее легкая версия Express, которая работает как локальное приложение. Поддерживает все основные функции программирования других изданий. Большим преимуществом LocalDB для разработчиков является то, что он позволяет создавать локальную среду, которая намного проще в установке и управлении. Пользователи могут просто запустить экземпляр среды выполнения LocalDB по мере необходимости без установки службы

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.

Programmability

Feature Enterprise Standard Web Express with Advanced Services Express
Basic R integration 1 Yes Yes Yes Yes No
Advanced R integration 2 Yes No No No No
Basic Python integration Yes Yes Yes Yes No
Advanced Python integration Yes No No No No
Machine Learning Server (Standalone) Yes No No No No
PolyBase compute node Yes Yes 3 Yes 3 Yes 3 Yes 3
PolyBase head node Yes No No No No
JSON Yes Yes Yes Yes Yes
Query Store Yes Yes Yes Yes Yes
Temporal Yes Yes Yes Yes Yes
Common Language Runtime (CLR) Integration Yes Yes Yes Yes Yes
Native XML support Yes Yes Yes Yes Yes
XML indexing Yes Yes Yes Yes Yes
MERGE & UPSERT capabilities Yes Yes Yes Yes Yes
FILESTREAM support Yes Yes Yes Yes Yes
FileTable Yes Yes Yes Yes Yes
Date and Time datatypes Yes Yes Yes Yes Yes
Internationalization support Yes Yes Yes Yes Yes
Full-text and semantic search Yes Yes Yes Yes No
Specification of language in query Yes Yes Yes Yes No
Service Broker (messaging) Yes Yes No (Client only) No (Client only) No (Client only)
Transact-SQL endpoints Yes Yes Yes No No
Graph Yes Yes Yes Yes Yes

1 Basic integration is limited to 2 cores and in-memory data sets.

2 Advanced integration can use all available cores for parallel processing of data sets at any size subject to hardware limits.

3 Scale out with multiple compute nodes requires a head node.

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.

Scale limits

Feature Enterprise Standard Web Express with Advanced Services Express
Maximum compute capacity used by a single instance — SQL Server Database Engine1 Operating system maximum Limited to lesser of 4 sockets or 24 cores Limited to lesser of 4 sockets or 16 cores Limited to lesser of 1 socket or 4 cores Limited to lesser of 1 socket or 4 cores
Maximum compute capacity used by a single instance — Analysis Services or Reporting Services Operating system maximum Limited to lesser of 4 sockets or 24 cores Limited to lesser of 4 sockets or 16 cores Limited to lesser of 1 socket or 4 cores Limited to lesser of 1 socket or 4 cores
Maximum memory for buffer pool per instance of SQL Server Database Engine Operating System Maximum 128 GB 64 GB 1410 MB 1410 MB
Maximum memory for Columnstore segment cache per instance of SQL Server Database Engine Unlimited memory 32 GB 16 GB 352 MB 352 MB
Maximum memory-optimized data size per database in SQL Server Database Engine Unlimited memory 32 GB 16 GB 352 MB 352 MB
Maximum memory utilized per instance of Analysis Services Operating System Maximum Tabular: 16 GB MOLAP: 64 GB N/A N/A N/A
Maximum memory utilized per instance of Reporting Services Operating System Maximum 64 GB 64 GB 4 GB N/A
Maximum relational database size 524 PB 524 PB 524 PB 10 GB 10 GB

1 Enterprise Edition with Server + Client Access License (CAL) based licensing (not available for new agreements) is limited to a maximum of 20 cores per SQL Server instance. There are no limits under the Core-based Server Licensing model. For more information, see Compute Capacity Limits by Edition of SQL Server.

Оцените статью
Рейтинг автора
5
Материал подготовил
Илья Коршунов
Наш эксперт
Написано статей
134
Добавить комментарий