如何增加数据分配大小 [英] How to grow data allocation size
问题描述
您好，
我确信有一个简单的答案，我忽略或找不到。
I'm certain that there is a simple answer to this that I am overlooking or not finding.
我有一个Azure SQL DW，我已将其最大尺寸扩展到20GB。 这在SMSS数据库属性和门户网站UI中得到确认
I have an Azure SQL DW that I have expanded it's Max Size to 20GB. This is confirmed in the SMSS db properties and via the portal UI
但是，数据文件大小已达到最大已用空间分配5GB，但最大大小为20GB。 这在Azure门户网站和t-sql查询中得到了确认。
However, the data file size has reached the max used space allocation of 5GB but Max Size is 20GB. This is confirmed in the Azure portal and via t-sql query.
如何启用额外15GB的使用？ 请帮忙，这会阻止我的Stream Analytics工作将我们的数据写入DW。 我认为弹性池可能就是答案，但我们需要将所有数据放在一个DW中。
How do I enable the usage of the additional 15GB? Please help, this is stopping my Stream Analytics job from being able to write our data to the DW. I thought an elastic pool might be the answer but we need all of our data in a single DW.
非常感谢！
推荐答案
您好bluesurf，
Hi bluesurf,
让您的解决方案再次运行的最简单方法是扩展数据仓库部署到更高的服务层但是，我对您当前的服务等级有疑问吗？
The easiest way to get your solution working again is to scale up for Data Warehouse deployment to a higher service tier but, I do have some questions with regard to your current service tier?
以下文档讨论了DW的容量限制： SQL数据仓库容量限制和
数据库对象部分表明您有更多可用的数据。按照本文档中的内容对您的实例进行扩展： 数据
仓库单位（DWU）和计算数据仓库单位（cDWU）
The following documentation discusses capacity limits of DW: SQL Data Warehouse capacity limits and the Database Objects section indicates you have a lot more gwoth available. Follow the insrtuctions in this document to scale your instance:Data Warehouse Units (DWUs) and compute Data Warehouse Units (cDWUs)
启动并运行您的解决方案后，您可以采取一些额外步骤来回收日志文件增长，但是，如果您已经达到最大限度，则需要扩展以运行这些任务，然后缩小规模。另外，用于管理SQL Server中
日志文件增长的工具不会直接转换为SQL DWH。下面的文章不适用于SQL DWH，所以我需要进一步调查，或者希望社区可以插入。
With your solution up and running, there are some additional steps you can take to reclaim log file growth but, if you are already maxed out you are going to need to scale up to run these tasks and then scale back down. Additionaly, the tools used to manage log file growth in SQL Server do not translate directly to SQL DWH. The below article does not apply to SQL DWH, so I need to invetigate this further, or hopefully the community can chime in.
这篇关于如何增加数据分配大小的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
