Administer > Database Administration

Database Administration

This section contains information about converting, maintaining, tuning, and troubleshooting your Relational Database Management System (RDBMS). The topics are intended for experienced Service Manager system and database administrators responsible for installing and implementing databases or individuals hosting Service Manager data and assisting in database conversion.

Other information contained in this section:

  • Information required to configure and use Service Manager databases
  • Practical information to learn about various methods used to perform queries against information contained in the database
  • Information and steps used to import, export, purge, and archive records
  • Information and steps used to run the Service Manager out-of-box maintenance utilities
  • Information about how to use IR Expert
  • Database tuning and troubleshooting tips
  • Best practices and examples using out-of-box data

Related topics

Database dictionary
Database performance tuning
Database record auditing
Exporting records
Importing records
IR Expert
Keys and indexes in Service Manager
Purging and archiving records
Queries
Record retrieval
Stored queries
Supported RDBMS
Time zones
Triggers
UTF-8 (Unicode) support
Work schedules
Backups