We are getting an error while loading data from one table to another. We do some monthly/quarterly roll ups on the first table data which is inserted into another table
将数据从一个表加载到另一个表时,我们收到错误。我们对插入另一个表的第一个表数据进行每月/每季度的汇总
The source table has clustered column store index. We have billions of rows in the source data table.
源表具有聚簇列存储索引。我们在源数据表中有数十亿行。
the SELECT part of the load script has a WHERE clause which filters data based on month and year.
加载脚本的SELECT部分有一个WHERE子句,它根据月份和年份过滤数据。
The error is below
错误如下
'The database 'tempdb' has reached its size quota. Partition or delete data, drop indexes, or consult the documentation for possible resolutions.'
'数据库'tempdb'已达到其大小配额。分区或删除数据,删除索引或查阅文档以获取可能的解决方案。
1 个解决方案
#1
3
SQLAzure enforces different limits,some are applicable irrespective of tiers,some limits may be higher depending on your service tier.Below is the way Azure handles those limits
SQLAzure强制执行不同的限制,一些适用于层而不管层,根据您的服务层,某些限制可能更高.Below是Azure处理这些限制的方式
Enforcement of limits
Resources other than CPU, Memory, Log I/O, and Data I/O are enforced by denying new requests when limits are reached. When a database reaches the configured maximum size limit, inserts and updates that increase data size fail, while selects and deletes continue to work. Clients receive an error message depending on the limit that has been reached.
通过在达到限制时拒绝新请求来强制执行CPU,内存,日志I / O和数据I / O以外的资源。当数据库达到配置的最大大小限制时,增加数据大小的插入和更新将失败,而选择和删除将继续有效。客户端收到错误消息,具体取决于已达到的限制。
so this answers your question on whether we can increase size of TEMPDB
所以这回答了我们是否可以增加TEMPDB的大小的问题
Below are the limits for TEMPDB
以下是TEMPDB的限制
This Page Azure SQL Database Resource Limits contains entire Limits in detail, i will try to add all the details when time permits or when i find the Github page ,so that link rot can be avoided
此页面Azure SQL数据库资源限制详细包含整个限制,我将尝试在时间允许或找到Github页面时添加所有详细信息,以便可以避免链接腐烂
#1
3
SQLAzure enforces different limits,some are applicable irrespective of tiers,some limits may be higher depending on your service tier.Below is the way Azure handles those limits
SQLAzure强制执行不同的限制,一些适用于层而不管层,根据您的服务层,某些限制可能更高.Below是Azure处理这些限制的方式
Enforcement of limits
Resources other than CPU, Memory, Log I/O, and Data I/O are enforced by denying new requests when limits are reached. When a database reaches the configured maximum size limit, inserts and updates that increase data size fail, while selects and deletes continue to work. Clients receive an error message depending on the limit that has been reached.
通过在达到限制时拒绝新请求来强制执行CPU,内存,日志I / O和数据I / O以外的资源。当数据库达到配置的最大大小限制时,增加数据大小的插入和更新将失败,而选择和删除将继续有效。客户端收到错误消息,具体取决于已达到的限制。
so this answers your question on whether we can increase size of TEMPDB
所以这回答了我们是否可以增加TEMPDB的大小的问题
Below are the limits for TEMPDB
以下是TEMPDB的限制
This Page Azure SQL Database Resource Limits contains entire Limits in detail, i will try to add all the details when time permits or when i find the Github page ,so that link rot can be avoided
此页面Azure SQL数据库资源限制详细包含整个限制,我将尝试在时间允许或找到Github页面时添加所有详细信息,以便可以避免链接腐烂