Nex-G Innovations

Arcgis Server Enterprise Configratuion and Tuning For Sql Server (10.0)

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.

Code: NES_SK_7737

Duration: 80 Hrs / 8 Weeks / Customized

Mode: Online / Offline / Onsite


Module 1 Geodatabase overview

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

Module 2 Configuring SQL Server for ArcSDE

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

Module 3 Installing ArcSDE

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

Module 4 ArcSDE components

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

Module 5 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

Module 6 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

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

Module 8 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

Module 9 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

Module 10 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

More Information