Skip to main content

Maintenance jobs

This section describes the maintenance jobs of the Microsoft 365 functionality in Snow License Manager.

SQL Server Agent Job​

Several non-clustered indexes are created to enhance the query performance within the Microsoft 365 environment:

  1. Index name: XI_TenantID_UserPrincipalName

    Table: [o365].[ReadModelUsersPerSubscriptionPlan]

    Columns: TenantId, UserPrincipalName

    Included columns: AccountHolderName, AccountSKU

  2. Index name: XI_TenantID_UserPrincipalName

    Table: [o365].[User]

    Columns: TenantId, UserPrincipalName

  3. Index name: XI_UserId

    Table: [o365].[LinkedSlmUserDetails]

    Columns: UserId

    Included columns: TenantId, UserPrincipalName, OrgCheckSum

How it operates​

The SQL Server Agent Job o365.RebuildIndexesJob maintains index performance based on the level of fragmentation. The job is scheduled to run nightly at 01:00:00, and it performs maintenance as follows:

  • For fragmentation < 10%: No action, the index is skipped.

  • For fragmentation between 10% and 30%: The index is reorganized.

  • For fragmentation > 30%: The index is rebuilt.

This schedule can be adjusted to meet specific client requirements.

If you want to modify the schedule, do the following:

  1. Open SQL Server Management Studio.

  2. In the SQL Server Agent section, find the o365.RebuildIndexesJob job.

  3. To open and see its properties, double-click the job name.

  4. In the left-side menu, select the Schedules tab.

  5. Adjust the execution time as needed, and then save your changes.