LOGFILE DEFAULTS for SQL Server
LOGFILE DEFAULTS for SQL Server
|
Release 9.3 |
|
In general, the default settings for log file table storage in SQL Server databases is sufficient. If you want to alter them, though, you can change the values in the dbtune.sde file prior to creating the geodatabase. Or you can use the sdeconfig command to change the parameter values after the geodatabase is set up. Consult the ArcSDE Administration Command Reference included with the ArcSDE component of ArcGIS Server Enterprise for details on the sdeconfig command.
##LOGFILE_DEFAULTS
LD_CLUSTER_ALL 0
LD_CLUSTER_ROWID 1
LD_INDEX_ALL "WITH FILLFACTOR = 75"
LD_INDEX_ROWID "WITH FILLFACTOR = 75"
LD_STORAGE ""
LF_CLUSTER_ID 0
LF_CLUSTER_NAME 0
LF_INDEX_ID "WITH FILLFACTOR = 75"
LF_INDEX_NAME "WITH FILLFACTOR = 75"
LF_STORAGE ""
SESSION_INDEX "WITH FILLFACTOR = 75"
SESSION_STORAGE ""
SESSION_TEMP_TABLE 1
UI_TEXT "User Interface text description for LOGFILE_DEFAULTS"
END