- SQL Server 2017 Administrator's Guide
- Marek Chmel Vladimír Mu?n?
- 472字
- 2025-04-04 17:46:08
SQL Server services configuration node
The administrator can call for a pop-up menu from every record shown in the right pane. Special attention should be focused on SQL Server itself and on SQL Server Agent.
SQL Server may be shown in several records because every instance has its own configurations so the first good thing is to select the right record. Following image shows the properties dialog box.
As shown on preceding image, Properties dialog box for every instance allows you to set the following:
- Log On tab: The context of the Windows account that will be used by the instance to log in to the operating system. This configuration needs restarting if changed.
- Service tab: The only setting enabled on this tab is Startup mode, which should be set to automatic.
- FILESTREAM tab: This tab contains FILESTREAM settings. As described earlier, FILESTREAM is a special kind of storage for binary data such as pictures or documents stored in relational data directly to a database. From administrator's point of view, FILESTREAM must be enabled for at least T-SQL Access. When enabled, databases can contain FILESTREAM file groups, which are actual representations of the binary storage. There's enhancement called file tables for which the second two textboxes (allow for I/O... and enable remote clients...) must be switched on.
- Startup Parameters tab: This tab contains three startup parameters as default:
- d: The location of the primary data file of the database master (must be reconfigured when the master database is moved)
- l: The location of the log file of the database master (must be reconfigured when the master database is moved)
- e: The default path for error logs written by SQL Server
- Additional parameters like trace flags and others can be added if needed.
- AlwaysOn High Availability tab: AlwaysOn is an advanced concept of data availability and reliability built on top of Microsoft Cluster Service (MSCS). When certain instances would attend to the AlwaysOn group, it must be enabled on this tab. MSCS must already be present before this configuration is done.
- Advanced tab: This tab actually has no advanced settings, just error reporting and usage feedback to Microsoft.
Special attention should be given to SQL Server Agent. SQL Server Agent is installed with every single instance of SQL Server. In other words, every instance of SQL Server has its own SQL Server Agent. Immediately after installation, SQL Server Agent is set to manual startup mode, which is not good enough for production environments.
That's why one of the first post-installation configurations should be to change SQL Server Agent's startup mode to automatic because SQL Server Agent is an invaluable service for a lot of regular administrator tasks as well as automated tasks done by SQL Server itself (for example, data collection, strong diagnostics tool, and collecting performance statistics using SQL Server Agent jobs).