Administering ArcSDE for SQL Server
Administering ArcSDE for SQL Server
Release 9.3
Note:
This topic was updated for 9.3.1.
This topic contains links to administration concepts and instructions. Some of these are topics that apply to all database management systems; others are specific to ArcSDE for Microsoft SQL Server.
Setting up the geodatabase
Be sure to read the
ArcSDE for SQL Server installation guide
for specific preinstallation, installation, and postinstallation setup steps for your operating system. The following are links to provide summaries and help with configuring the geodatabase.
Tuning tips to configure the DBMS to work with ArcSDE
SQL Server initialization parameters
Minimize disk I/O contention in SQL Server
Tuning memory in SQL Server
User logins and permissions
The ArcSDE administrative account
User permissions
User permissions for geodatabases in SQL Server
Operating system authentication
Using Windows-authenticated users or groups in SQL Server
ArcSDE for SQL Server dbo-schema geodatabases
Installing ArcSDE for SQL Server
Installation summary for the ArcSDE component for SQL Server
Managing multiple ArcSDE component installations on the same machine
Using multiple geodatabases in SQL Server
Upgrade summary for ArcSDE geodatabases
Postinstallation setup
The following are topics about tuning the ArcSDE geodatabase repository creation:
The giomgr.defs file and the SERVER_CONFIG system table
ArcSDE initialization parameters
The dbinit.sde file
The dbtune file and the DBTUNE table
DBTUNE configuration keywords
Default configuration keywords specific to SQL Server
Composite configuration keywords
Making configuration keywords available in ArcGIS
The DATA_DICTIONARY keyword
SQL Server DATA_DICTIONARY keyword
The DEFAULTS keyword
SQL Server DEFAULTS keyword
Log file configuration options
Log file keywords
LOGFILE_DEFAULTS for SQL Server
DBTUNE configuration parameter name-configuration string pairs
SQL Server DBTUNE configuration parameters
Text in row option for SQL Server 2000 and 2005
These topics discuss other geodatabase setup configurations:
Language support in the geodatabase
Language support for SQL Server
XML columns in the geodatabase
Configuring a SQL Server database to support XML columns
Making connections to the geodatabase
The following are general topics about connecting to a geodatabase:
An overview of ArcSDE geodatabase connections
Compatibility between clients and geodatabases
ArcSDE connection syntax
Creating spatial database connections
These topics are specific to making connections using an ArcSDE service:
Starting an ArcSDE service
Stopping an ArcSDE service
Pausing and resuming an ArcSDE service
Accessing an ArcSDE service through a firewall
Displaying ArcSDE service statistics and session information
Removing ArcSDE service user processes
Troubleshooting the ArcSDE service
These topics deal with direct connections to the geodatabase:
Properties of a direct connection to an ArcSDE geodatabase
Setting up a direct connection to SQL Server
Troubleshooting direct connections to an ArcSDE geodatabase
Working with the geodatabase
These topics cover working with data in an ArcSDE geodatabase:
About data types
SQL Server data types
About geometry storage types
Registering tables to be used by ArcGIS Desktop
Granting and revoking privileges on datasets
SQL Server backups
Recovery models for SQL Server
Using database views
Views in SQL Server
Locators in the geodatabase
About compressing a geodatabase
Compressing an ArcSDE geodatabase licensed under ArcGIS Server Enterprise
Updating statistics on a geodatabase licensed under ArcGIS Server Enterprise
Updating geodatabase statistics in SQL Server databases
It would also be helpful to understand how the geodatabase is structured and how data is stored in it. For this, consult the section "Geodatabase data storage and schema" found in this help. There is a specific book for SQL Server in this section: "Inside a geodatabase in SQL Server."
See Also
An overview of ArcSDE geodatabase administration
