Microsoft SQL Server Configuration Settings
Configuration setting
Configuration option regulations
Change configuration settings using Enterprise Manager
Configuration Settings Ventively Configured Options (Parameter), you can manage resources with optimization SQL Server. The configuration option can be set by using the SQL Server Enterprise Manager or the SP_Configure system pre-depreciation program. First we first discuss the configuration settings with the sp_configure pre-depreciation program. Execute the following command to use the sp_configure pre-store:
SP_Configure 'configuration option name', value
For example, the following is to use sp_configure to set the value of Max Worker Threads to 200:
SP_Configure 'max worker threads', 200
Go
With regard to the settings of the configuration option, there is a very detailed setting explanation in SQL Server "Online Books". The query method is to click the "Online Book" Search, enter "Configuration Options" in the strings you want to search, select the settings of the configuration option, you can read the explanation of the configuration option settings. The last one of this topic has a configuration option table, lists all the option names, and the minimum and maximum value of the option name, and introduces these effects after setting these values.
The configuration option specifies that some configuration options belong to the standard configuration option, and some are advanced configuration options; some settings can be executed immediately, while others need to be reopened. The following will we list all configuration options and look at the rules for performing configuration options:
Table A-1 SQL Server Configuration Options
The configuration options belong to the advancement option to reboot Affinity Mask is a need for unload updates. No need for awe enabled is a need for COST THRESHOLD for Parallelism. It is not necessary to default full-text language does not need default logage. No No Fill Factor is required for INDEX CREATE MEMORY. It is not necessary. Locks is required. Max Degree Of Parallelism is not need Max Server Memory No need Max Worker Threads is required for Media Ret1. Per Query is not required for MIN Server Memory, no NESTED TRIGGER is not needed to be NetWork packet size is not needed to be a need for priority boost is needed Query Wait is not needed to have Remote Accesses. No need Remote Access No No need remote login timeout does not require remote proc trans do not need no remote query timeout does not need to scan for startup procs No need set working set size is no need to show advanced options not need two digit year cutoff does not require user connections is no need for user options No need
Use Enterprise Manager Change Configuration Settings Set in Enterprise Manager to select a server to press the right button, select the content in the flash function table, you can enter the properties window changing configuration setting. The following is an introduction to each page: General Charges A-1 is the general tabs in the properties window. The substrate settings of the component option can be changed in the general tab, but the principles and parameters of several automatic startup can be set. Figure A-1 "SQL Server Attribute" window "General Terminal"
Memory Figure A-2 is displayed in the memory tab in the properties window. Here, you can decide whether to set a memory in a dynamic manner, or set a memory in a quantitative manner. The configuration options in this tab are: MIN Server Memory (Minimum Value of Dynamic Setting Memory) MAX Server Memory (Maximum) MIN MEMORY PER Query Displayed by Memory Per Query That is, the processor tab in the properties window. The configuration options that can be set in this tab are:
Figure A-2 "Memory" page sign in the "SQL Server Properties" window
Figure A-3 "Processor" page sign in the "SQL Server Properties" window
Affinity Mask (Similarity Mask) Max Worker Threads Priority Boost (Improve SQL Server Priority on Windows) Lightweight Pooling Max Degree Of Parallelism (Using All Processors) Cost Threshold for Parallelism (Minimum Query Plan Limit) Security Figure A-4 is displayed in the properties window. Here is mainly to set the verification mode to protect the security level.
Figure A-4 "Safety" tab in the "SQL Server Properties" window
Connect the line diagram A-5 is displayed in the properties window. The configuration options you can set here are:
Figure A-5 "Connection" page in the Window in the SQL Server Properties
User Connection User Options (User Preset Wire Options) Remote Access (Remote Server Wire) Remote Query Timeout Remote Proc Trans (Force Transfer Transaction) Server Set the value diagram A-6 is displayed for the server setting value page for the properties window. The options you can set here are:
Figure A-6 "Server Settings" Type in the "SQL Server Properties" window
DEFAULT LANGUAGE ALLOW UPDATES NESTED TRIGGERS (Allow Nest Trigger) Query Governor Cost Limit (Query Exemplar) Two Digit Year Cutoff (Two Years Support) Database Settings Figure A- 7 Displayed is the page sign for the database in the properties window. The options you can set here are: Fill Factor Media Retent (Backup Retention Term)
Recovery Interval
Figure A-7 "SQL Server Properties" window "Database Settings" Type
Drawing Figure A-8 is displayed for a replication tab in the properties window to see the issuance and distribution options. The Activity Directory Figure A-9 is displayed for the Active Directory Type Sign in Properties Windows to modify the Active Directory input. Figure A-8 "Supreme" page in the "SQL Server Properties" window
Figure A-9 "Active Directory" page in the "SQL Server Properties" window
