The most important point of mssql-conf is the validation rule, which adds to the flexibility, enabling the management of the configuration in a more dynamic way. Also, since SQL Server 2017 has already been ported to Linux, many non-SQL-DBAs can enjoy the flexibility to play with SQL. I feel that using the Oracle configuration files as a reference in this context helps many DBAs form the analogy and understand the architecture of the SQL Server 2017 better. T-SQL is used to adjust values or entries, or to commit them into the system without restarting the system. It is similar to sp_configure of SQL Server. SPFILE, on the other hand, is a binary file. Any changes made to the PFILE would take effect only when the database is restarted. The PFILE is text based, and can be edited in an editor like VI/VIM on UNIX/Linux or Notepad on Windows. This PFILE is read when the instance starts up, in order to get specific instance characteristics. PFILE (parameter file) is a text file used to initialize the database and setting configuration parameters.
I’d like to visit some of the key concepts of the Oracle parameter file (PFILE and SPFILE) here, with which the server configuration can be set/unset by adding/modifying entries in the configuration file. The primary function of this tool remains the same as that of the SQL Server Configuration Manager, but makes it easy for Oracle and Linux admins to work with SQL Server 2017 on Linux. On Linux, we have a configuration tool known as mssql-conf. On Windows, we are familiar with SQL Server Configuration Manager, the configuration tool used to manage and administer SQL Server services, configure the network protocols, and to manage network connectivity between the SQL Server and the client computers. This article outlines the use of mssql-conf in conjunction with other available tools, to manage SQL Server. SQL Server on Linux provides a wide range of options for configuration, management and administration. There are several tools that help with the process. However, configuring a system needs not necessarily be a daunting task. Configuration of any system plays a vital role in its working efficiently.
0 kommentar(er)
