ArcGIS Server Enterprise Configuration and Tuning for SQL Server (10.0)

Description

This course prepares Microsoft SQL Server database administrators to maximize ArcSDE technology within an ArcGIS Server 10.0 enterprise geodatabase to centrally store and manage data, provide robust data security, and deliver multiuser access and editing capabilities. You will become familiar with the ArcSDE architecture and learn how to manage storage settings for spatial data. Techniques for maintaining geodatabase performance in an editing environment and strategies for maintaining and managing an enterprise geodatabase are also presented.

Who Should Attend

Microsoft SQL Server database administrators who need to install and configure an ArcGIS Server 10.0 enterprise geodatabase.

Note: Those who need to load and manage data in preparation for an enterprise geodatabase implementation may also want to enroll in Data Management in the Multiuser Geodatabase, which complements this course.

Learn How To

• Configure SQL Server to support ArcSDE.
• Install, configure, and optimize ArcSDE.
• Load and manage storage of vector and raster data.
• Configure, create, and monitor connections.
• Manage nonversioned and versioned editing environments.
• Perform data backup and recovery tasks.
• Upgrade a workgroup geodatabase to an enterprise geodatabase.

Esri will provide the following software to use during class:

• ArcGIS 10.0 for Desktop (ArcEditor or ArcInfo)
• ArcGIS 10.0 for Server Enterprise (Basic, Standard, or Advanced)
• Microsoft SQL Server Standard 2008

Geodatabase overview

• ArcSDE geodatabases
• Geodatabase elements and options
• ArcGIS Desktop licensing

Configuring SQL Server for ArcSDE

• SQL Server components and databases
• Memory considerations
• Transaction log
• File groups
• Authentication
• Security considerations
• SQL Server Management Studio

Installing ArcSDE

• SDEHOME directory
• Post installation overview
• Choosing schema
• ArcSDE repository setup and configuration files
• Creating an ArcSDE service
• Starting and stopping ArcSDE

ArcSDE components

• ArcSDE repository and data dictionary
• SDEHOME contents
• Stored procedures
• ArcSDE command syntax
• Configuration files
• Diagnostic files

ArcSDE architecture and connections

• Client/server model
• Application server connections
• Direct connects
• OLE DB connections
• Windows authentication
• Monitoring and terminating connections
• SDE_SERVER_CONFIG parameters and table

Vector data storage

• ArcSDE feature class basics
• ArcSDE compressed binary schema
• Spatial index concepts
• SDE_LAYERS table
• Controlling storage
• dbtune file format and parameters
• Feature class parameters
• Managing vector and raster data storage

SQL Server Spatial feature classes

• Using SQL Server Spatial with ArcSDE
• SQL Server 2008 Spatial Type
• Spatial index options
• Using geography or geometry data
• Monitoring changes to the adds, deletes, and system tables

Managing an editing environment

• Nonversioned and versioned editing workflows
• Database locking and concurrency
• Transaction isolation levels
• Repository versioning tables
• Delta table storage
• Indexes and statistics
• DBMS and geodatabase replication

Raster data storage

• ArcSDE raster basics
• Raster storage in SQL Server
• Binary raster dataset schema overview
• Raster repository table and storage parameters
• Pyramids
• Compression
• Configuring SQL Server for raster loading

Data recovery

• Data backup types and options
• ArcSDE backup considerations
• Simple, full, and bulk-logged recovery models
• Restoring a database
• Detaching and attaching a database

Experience with Microsoft SQL Server database administration or application development is required. Completion of ArcGIS Desktop II: Tools and Functionality, ArcGIS Desktop III: GIS Workflows and Analysis, or Building Geodatabases is recommended.