SQL Server GDB Performance Tuning Day 1

Service Description

The following is the Day 1 agenda for this 2-Day course: Day 1: • How to establish Attribute indexes • How to maintain Statistics • Manage attribute indexes and statistics • Spatial indexes • Maintaining geodatabase performance for versioned data • Schema locks removal • Create Indexes • Update statistics • Reconcile and Post • Address Conflicts • Compress the geodatabase • Rebuild indexes • Automate performance tasks Requirements: • Attendees will be asked to bring their issues to the class • Attendees will need admin access to both their workstation and database servers that will be used • Attendees will host their environment to work through these issues and be responsible for host control • Attendees will need to download and install the tools that will be emailed prior to the beginning of the course