You can perform regular maintenance tasks on your Workspace ONE UEM environment to keep it fully functioning and healthy. Learn more about the maintenance you can perform on your databasses, how often to perform each maintenance task, and who is responsible for doing so.
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 |
Hourly (frequency should be adjusted based on server workload) |
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 Maintenance |
Nightly |
Reorganize or rebuild based on fragmentation percentage, 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 |
Deactivate 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 |
Archive Workspace ONE UEM Logs
Over time, it might 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 websites, 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.