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 are sufficient. Any values that are blank will use the SQL Server default values for table or index storage.

If you want to alter any of the parameter values, use the sdedbtune command. The sdedbtune command is installed with the ArcSDE application server instsallation. See the ArcSDE Administration Command Reference included with the ArcSDE application server installation and Altering the contents of the DBTUNE table for instructions on changing parameter values.

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

8/21/2013