The remote access option controls whether remote SQL Servers are allowed logon access to the server. If set to zero (0), SQL Server will deny will deny access to remote SQL Servers. If you are utilizing replication or the Distributed Transaction Coordinator, you will need to turn this option on.

remote logon timeout option

The remote logon timeout option controls the amount of time, in seconds, that SQL Server will wait before returning an error to the client.

remote proc trans

This feature allows users to protect the actions of a server-to-server procedure through a DTC-coordinated distributed transaction.

remote query timeout

Thremote query timeout option controls the amount of time, in seconds, that SQL Server will waits before returning an error to the client process that was requesting the execution of a query on a remote server.

resource timeout

The resource timeout option controls the amount of time, in seconds, that SQL Server will wait before returning an error to the client If you are seeing a large number of logwait or bufwait timeout warnings in the SQL Server error log, you should increase this value.

set working set size

SQL Server will normally request memory from NT as it needs it. If you are using dynamic memory allocation, do not turn this one. If you are manually configuring memory, set this option to 1. By setting the set working set size to 1, you will force NT to allocate and lock the entire block of memory configured for SQL Server.

show advanced options

Certain configuration options are considered advanced options. These are normally options that require care in determining whether to change them. If this is set to 0, you will not see any of the advanced options displayed. In no instance have I ever found a problem with viewing a configuration option, so you should always set this to 1.

spin counter

The spin counter controls the number of times SQL Server will retry a resource request. Do not change this option unless directed to by Microsoft Technical Support.

time slice

Windows uses a preemptive multitasking model. However, the SQL Server kernel is not based on a preemptive model. The time slice controls the amount of time a SQL Server processor can utilize a processor before yielding to another process. Do not change this configuration option unless directed to by Microsoft Technical Support.

SQL Server 7.0 Server, Database, and Query options 1 2 3 4 5 6 7 8