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

AirWatch Database

AirWatch 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 AirWatch database maintenance guidelines.

Task Frequency Description Responsible Party

Transaction Log Backups

Nightly

Keeps high percentage of free space in the log file.

Customer DBA

AirWatch Purge Job

Nightly

Removes expired session data provided by AirWatch.

AirWatch 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

AirWatch Logs

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

The following DOS script can be used to delete AirWatch 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

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