Подія
31 бер., 23 - 2 квіт., 23
Найбільший навчальний захід SQL, Fabric і Power BI. 31 березня – 2 квітня. Щоб заощадити 400 грн, скористайтеся кодом FABINSIDER.
Реєструйтеся сьогодніConfigure Database Engine Instances (SQL Server)
Applies to: 
SQL Server
Each instance of the Database Engine must be configured to meet the performance and availability requirements defined for the databases hosted by the instance. The Database Engine includes configuration options that control behaviors such as resource usage and the availability of features such as auditing or trigger recursion.
When a database is deployed into production there is often a service level agreement (SLA) defining areas such as the levels of performance required from the database and the required availability level of the database. The terms of the SLA typically drive configuration requirements for the instance.
An instance is usually configured immediately after it has been installed. The initial configuration is usually determined by the SLA requirements of the types of databases planned to be deployed to the instance. After the databases have been deployed, the database administrators monitor the performance of the instance and adjust the configuration settings as needed if the performance metrics show the instance is not meeting the SLA requirements.
| Task Description | Topic |
|---|---|
| Describes the various instance configuration options and how to view or change these options. | Server Configuration Options (SQL Server) |
| Describes how to view and configure the default locations of new data and log files in the instance. | View or Change the Default Locations for Data and Log Files (SQL Server Management Studio) |
| Describes how to configure SQL Server to use soft-NUMA. | Soft-NUMA (SQL Server) |
| Describes how to map a TCP/IP port to non-uniform memory access (NUMA) node affinity. | Map TCP IP Ports to NUMA Nodes (SQL Server) |
| Describes how to enable the Windows Lock Pages In Memory policy. This policy determines which accounts can use a process to keep data in physical memory, preventing the system from paging the data to virtual memory on disk. | Enable the Lock Pages in Memory Option (Windows) |
Додаткові ресурси
Навчання
Модуль
Configure databases for optimal performance - Training
Configure databases for optimal performance
Сертифікація
Microsoft Certified: Azure Database Administrator Associate - Certifications
Адмініструйте інфраструктуру баз даних SQL Server для хмарних, локальних і гібридних реляційних баз даних за допомогою пропозицій реляційних баз даних Microsoft PaaS.
Документація
-
Database Engine Instances (SQL Server) - SQL Server
Find out about Database Engine instances. View information on tasks you can perform on instances, such as configuring properties and enabling protocols.
-
Manage the Database Engine services - SQL Server
Get acquainted with services that are available in SQL Server. See how to start SQL Server Configuration Manager, which you can use to manage various services.
-
Run SQL Server With or Without a Network - SQL Server
Learn how to run SQL Server on a network and without one. For local use, see how to use a local pipe. For network use, see how to check for required services.