Azure SQL Server错误:弹性池已达到其存储限制.弹性池的存储使用不能超过(204800) [英] Azure SQL Server Error : The elastic pool has reached its storage limit. The storage usage for the elastic pool cannot exceed (204800)

问题描述

当我尝试从应用程序或直接sql server数据库更新或插入多行时，出现以下错误.

When I am trying to update or insert multiple rows from the application or directly sql server database, I am getting the error as below.

消息1132，级别16，状态1，第1行弹性池已达到 储存空间限制.弹性池的存储使用量不能超过 (204800)MB.

Msg 1132, Level 16, State 1, Line 1 The elastic pool has reached its storage limit. The storage usage for the elastic pool cannot exceed (204800) MBs.

我不知道该如何处理.请帮忙.

I do not know how to handle this. Please help.

推荐答案

您应主动检查数据库的当前大小配额，以确保已按预期设置.为此，可以在目标数据库的上下文中使用以下语句:

You should proactively check the current size quota for your databases, to make sure it is set as expected. To do this, the following statement can be used in the context of the target database:

SELECT DATABASEPROPERTYEX(DB_NAME(), 'MaxSizeInBytes');

要解决此问题并扩大到具有更大最大配额的服务目标，请使用上图所示的ALTER DATABASE…MODIFY(MAXSIZE =…)命令显式更改配额以匹配最大配额(除非配额较低)希望保证将来能够缩小规模).更改以在线方式执行.

To solve this issue scale up to the service objective with a larger maximum size quota, explicitly change the quota to match the maximum by using the ALTER DATABASE … MODIFY (MAXSIZE = …) command as shown above (unless a lower quota is desired to guarantee being able to scale down in the future). The change is executed in an online manner.

ALTER DATABASE DB1 MODIFY (MAXSIZE = 10 GB);

在

On this documentation you will find a table that shows the resources available at each service tier, including the maximum storage.

这篇关于Azure SQL Server错误:弹性池已达到其存储限制.弹性池的存储使用不能超过(204800)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！