This section describes some of the maintenance tasks to perform for your on-premises deployment.

Workspace ONE UEM Database

Workspace ONE UEM Database Regular database maintenance must be performed. Maintenance standards vary per company. Check with your local database team for best practices. The following table provides Workspace ONE UEM database maintenance guidelines.

Task Frequency Description Responsible Party

Transaction Log Backups

Nightly

Keeps high percentage of free space in the log file.

Customer DBA

Workspace ONE UEM Purge Job

Nightly

Removes expired session data provided by Workspace ONE UEM.

Workspace ONE UEM Built-In Function

Index Rebuild

Nightly

Routine index maintenance, especially after purge job.

Customer DBA

Daily Differential Backup

Nightly

Creates a back up file of database changes since the previous full back up.

Customer DBA

Weekly Full Backup

Weekly

Creates a back up file of the entire database. Full backups can be retained per your policies.

Customer DBA

Multiple Data Files

One time

This helps reduce the IO burden of their installation.

Customer DBA

Disable Hyperthreading

One time

Improves performance and decreases memory use on computers running SQL Server and BizTalk Server.

Customer DBA

Backup Validation

As Needed

Ensures full and differential backups are being performed and retained on schedule.

Customer DBA

Database Consistency Check (DBCC CHECKDB)

As Needed

Checks the logical and physical integrity of all database content.

Customer DBA

Resize Data Files

As Needed

This prevents VLFs and keeps enough free space in the log file.

Customer DBA

Resize Transaction Log

As Needed

This prevents VLFs and keeps enough free space in the log file.

Customer DBA

Workspace ONE UEM Logs

Over time, it may be necessary to archive or purge old Workspace ONE UEM log files to conserve disk space. If logging is set to verbose on Workspace ONE UEM services or Web sites, archiving or purging can occur more frequently. Hard disk space can be monitored, as noted. If disk space becomes low, Workspace ONE UEM recommends archiving or purging old log files.

The following DOS script can be used to delete Workspace ONE UEM logs with “LastAccessTime” greater than a set number of days in \AirWatch\Logs:

start /wait powershell -command "dir e:\AirWatch\logs -recurse | where {((getdate) - $_.LastAccessTime).days -ge 14} | remove-item -force –recurse"

Windows Update

Workspace ONE UEM recommends that auto-update functionality is turned off and manual updates are performed every 2–4 weeks or per your policy.