Premium Subscription

Anytime. Anywhere.

Learn MoreSubscribe Now

OnBase Database Administration: Overview

SECTION 1: Introduction

01 Introduction 5 m
02 Activity: Download the Scripts

SECTION 2: Install and Configure

03 Installation Basics 2 m
04 Database Components 6 m
05 SQL Server Database Settings 9 m

SECTION 3: Maintenance and Monitoring

06 Maintenance: Backups Overview & Strategy 8 m
07 Creating and Configuring a Backup 4 m
08 Integrity Checks 7 m
09 Optimizations 9 m
10 Setting Up a Maintenance Plan 6 m
11 Monitoring and Baselines 4 m

SECTION 4: Conclusion

12 Troubleshooting 5 m
13 Tips and Tricks 5 m
14 Want more extensive information?

SECTION 5: Final Assessment (Earn 80% or higher to earn credit)

15 Final Assessment

Calling all DBAs! This course provides all the basics for understanding, maintaining, and troubleshooting your OnBase Database.

Hyland Database Analysts will guide you to become a more confident database administrator. With a high level overview of a DBA's responsibilities and many practical SQL queries, you will finish this course with a good idea of how to analyze and optimize your system. For more extensive information on topics mentioned in this course, see the related courses listed under Resources & Links.

Please note: This course is best viewed in full screen mode.

  • Premium
  • P1547
  • Expert
  • 1 hr 10 mins
  • Available with Premium Subscription

This course requires a Premium Subscription. Login to learn more.


Prerequisites
There are no prerequisites for this course.
Topics Covered
  • Checking your SQL version
  • Listing machine and instance name
  • Checking last restart date
  • Listing all databases in an instance
  • Checking the tables for the OnBase database
  • Listing indexes for a specific table
  • Checking memory allocation for SQL Server
  • Checking parallelism configuration
  • Checking optimize for ad hoc workloads configuration
  • Viewing file and growth settings
  • Evaluating your current backup process
  • Determining your recovery strategy
  • Establishing a SLA
  • Restoring a database from a backup
  • Checking for corruption
  • Checking to see last time statistics were updated
  • Manually updating specific statistics
  • Updating all statistics on a table
  • Rebuilding an index
  • Rebuilding all indexes for a table
  • Scheduling a maintenance plan
Learning Paths with This Course