ArcGIS Server Enterprise Configuration and Tuning for SQL Server

This course prepares Microsoft^® SQL Server^® database administrators to implement an ArcSDE enterprise geodatabase. You will become familiar with the ArcSDE architecture and learn how manage storage settings for loading vector and raster data. Techniques for maintaining geodatabase performance in an editing environment and solid strategies for maintaining and managing an ArcSDE geodatabase are presented.

This course is designed for experienced SQL Server database administrators who need to install and configure an ArcSDE enterprise geodatabase. You may choose to also enroll in Data Management in the Multiuser Geodatabase, which complements this course.

After completing this course, you will be able to

• Configure SQL Server to support ArcSDE.
• Install and configure ArcSDE.
• Create multiple ArcSDE workspaces.
• Customize storage for ArcSDE data.
• Configure, create, and monitor connections.
• Implement data management strategies for vector and raster data.
• Optimize ArcSDE.

• ArcSDE installation: Evaluating the configuration of SQL Server; Preparing SQL Server to use ArcSDE technology; Installing ArcSDE; Starting and stopping the ArcSDE server; Exploring ArcSDE system tables.
• Data loading: Creating storage space; Creating users and assigning privileges; Creating vector feature classes; Creating raster datasets; Examining feature class components; Customizing storage with the DBTUNE table.
• Monitoring data access: Creating application server and direct connections; Monitoring connections with ArcSDE and SQL Server tools.
• Editing in a nonversioned environment and managing a multiversioned geodatabase: Registering feature classes as versioned; Compressing the geodatabase; Monitoring changes to the adds, deletes, and system tables.

You should have experience with SQL Server database administration or application development. Although these courses are not required, you will benefit from completion of ArcGIS Desktop II: Tools and Functionality, ArcGIS Desktop III: GIS Workflows and Analysis, or Building Geodatabases.

This course is designed to work with the following software:

How do I know what ArcGIS Desktop software I have? [Flash] [Text]