Applies to Product – Dynamics 365 Supply Chain Management
What’s happening?
The customer is experiencing an error when attempting to open the employee form, which is preventing them from creating sales orders. The error message indicates that "The elastic pool has reached its storage limit."
Reason:
The error message suggests that the database objects have been allocated enough space to meet the elastic pool storage limit, but there may be unused space in the data space allocation. This can occur when an elastic pool resize operation starts, and the scan may miss a database in a transient state, causing the database to retain the old resource governance setting.
Resolution:
- Review the document on Database file space management - Azure SQL Database | Microsoft Learn for scripts to find storage space information and reclaim unused allocated space.
- Consider increasing the elastic pool's storage limit.
- As a short-term solution, free up data space using the samples provided in the document on reclaiming unused allocated space.
- Be aware of the potential negative performance impact of shrinking database files, and refer to the section on index maintenance after shrink.