The LOGFILE_DEFAULTS keyword in SQL Server

The LOGFILE_DEFAULTS keyword contains parameters to specify the storage of ArcSDE log file tables. If custom logfile keywords are not created, the settings in the LOGFILE_DEFAULTS keyword are used to specify storage for log file tables for all connecting users.

TipTip:

See Custom configuration keywords for information on creating custom keywords.

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 sdedbtune command to change the parameter values after the geodatabase is set up. See Altering the contents of the DBTUNE table after it is created for instructions.

##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

END

Related Topics


11/18/2013