ArcGIS Server Banner

LOGFILE DEFAULTS for SQL Server

LOGFILE DEFAULTS for SQL Server

Release 9.3 E-mail This TopicPrintable VersionGive Us feedback
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

See Also

  • Log file keywords
  • Log file configuration options