Storage capacity enforcement module for Power Platform Center of Excellence Starter Kit

Applies to: Dynamics 365

The storage capacity enforcement solution is used as an optional and complimentary set of components for the Center of Excellence (CoE) Starter Kit. This solution provides you with the capability of enforcing storage capacity limits. It also automates the assessment of consumed capacity versus approved capacity and placing environments that are over approved capacity into Administration Mode. Dataverse environments in this state can only be accessed by those users who have System Administrator or System Customizer security roles assigned to their accounts.

Important

There is an additional cost associated with jobs executed using an Azure Automation account. You can review the Process automation pricing and use the Azure Pricing Calculator to create a projected estimate. A single execution of the enable or disable runbook jobs averages 30 seconds of job run time but can vary.

Solution components

The solution is made up of three primary component areas: notifications, automation, and reporting/audit.

Notifications

The following notifications are included as a part of this solution and act as the primary mechanism to inform administrators and environment owners on storage capacity warnings and enforcement status.

• Close to capacity emails - Notify environment owner and CoE admins when an environment exceeds 80% (adjustable) but is still less than 100% of approved capacity.

• Enforcement applied/removed emails - Notify environment owner and CoE Admins when environment has capacity enforcement enabled or disabled.

• Enforcement removal in-app notifications - Notify CoE admin of environment status when running the manual Flow to disable capacity enforcement from CoE Power Platform Admin View app.

Automation

Power Automate flows are used to facilitate the automation for sending notifications and apply/remove administration mode.

• 100% capacity – Disable environment - Environment consumed capacity reaches 100% of approved for any capacity type (database, file, or log). A scheduled flow places the environment into admin mode.

• Disabled environment < 80% capacity – Enable environment - Disabled environment consumption is below 80% of approved capacity for all defined capacity types. A scheduled flow disables admin mode, allowing users access.

• Remove admin mode – Manual Flow in Power Platform Admin View - Provides CoE admins with the option to remove admin mode from specific environments, directly from the Power Platform Admin View app.

Reporting & auditing

The following reporting and audit components are included and provide visibility into environment storage capacity analytics.

Environment views in the Power Platform Admin View app

• Environments disabled by capacity enforcement – List of the environments currently disabled (administration mode) due to storage capacity overage.

• Environments excused from capacity enforcement – List of the environments that are excused and won't be assessed as a part of the storage capacity enforcement solution.

• Environments with no storage capacity limits – Environments that don't have any storage capacity limits currently defined.

  Note

  Environments in this scenario will not be assessed or enforced since there are no storage capacity limits configured

• Environments without environment owner – The solution uses the CoE Starter Kit "environment owner" field for sending notifications. If an environment owner isn't defined for an environment, notifications are only sent to the CoE Admin email.

Environments in Power BI

The solution adds pages to the existing CoE Power BI dashboard that provide details on disabled environments, including the following list:

• Total number of environments that are switched off

• Number of environments disabled in past 30, 90 days

• Count of disabled environments by environment type

• Top 10 environments - % of approved capacity used

• Datapoints for approved, consume and % used for database, file and log capacities per environment

Prerequisites

The following prerequisites must be deployed and configured before you can deploy the Storage Capacity Enforcement solution.

• Install the CoE Starter Kit: Core Components solution.

• Enable In-app Notifications for the Power Platform admin view app in your CoE Starter Kit environment

• Azure subscription

  Create an Azure Automation account. We recommend creating the Automation account in the same region as your CoE Starter Kit Dataverse environment.

  Tip

  You can learn which region your environment is hosted in by suing the Synapse Link for Dataverse guide. The guide provides this information on the initial setup page. You don't have to complete the setup, and you can close the wizard once you've identified the region. This step is just to get the information about region and datacenter.

  The following image illustrates the information you see when you select a storage account:

  

Solution download

Download the storage capacity enforcement solution on GitHub.

Related resources

• Center of Excellence (CoE) overview - Power Platform

• Set up the CoE Starter Kit - Power Platform

• Environment capacity management & alerting - Power Platform