To determine current PVS size, see PVS troubleshooting. PVS is a part of each database, and is used to implement Accelerated Database Recovery. Check if high space utilization is due to a spike in the size of Persistent Version Store (PVS).For more information, see Manage file space in Azure SQL Database. In elastic pools, shrinking a database provides more storage for other databases in the pool. Shrink a database to reclaim unused space.If the database is in an elastic pool, then alternatively the database can be moved outside of the pool, so that its storage space isn't shared with other databases.See Scale single database resources and Scale elastic pool resources. Increase maximum data size of the database or elastic pool, or scale up to a service objective with a higher maximum data size limit.If you observe high storage space utilization, mitigation options include: For more information, see Storage space governance. In Premium and Business Critical service tiers, clients also receive an error message if combined storage consumption by data, transaction log, and tempdb for a single database or an elastic pool exceeds maximum local storage size. SELECT and DELETE statements remain unaffected. When data space used reaches the maximum data size limit, either at the database level or at the elastic pool level, inserts and updates that increase data size fail and clients receive an error message. For more information, see Query Tuning/Hinting. Optimizing queries to reduce CPU resource utilization of each query.Increasing the compute size of the database or elastic pool to provide the database with more compute resources.If you observe high compute utilization, mitigation options include: Under these conditions, queries may be queued by the service and are provided resources for execution as resources become free. When database compute CPU utilization becomes high, query latency increases, and queries can even time out. What happens when resource limits are reached Compute CPU For more information, see Request quota increases for Azure SQL Database. To obtain more DTU/eDTU quota, vCore quota, or more logical servers than the default number, submit a new support request in the Azure portal.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |