英文:
SQL Server Object Explorer separates Azure SQL databases that are in one Azure SQL server
问题
在Azure中,我有几个连接到同一个SQL服务器的SQL数据库。当我在Visual Studio中查看SQL服务器对象资源管理器时,它们是分开显示的,不像我在本地的SQL服务器中的视图。
所有的查询和连接都按预期工作,但这只是我的一个小困扰。是否有一种方法可以将它们合并在一起?图像可能显示得更清楚。我希望这3个Azure数据库(红色)看起来像绿色。
英文:
In Azure, I have several SQL databases connected to one SQL server. When I look in the SQL server object explorer in Visual Studio, they are separated unlike the view of my on-premise SQL server.
All queries and connections work as expected but this is more of just a thorn in my side. Is there a way to combine these. The image may display better. I would like the 3 azure databases (red) to look the green.
答案1
得分: 1
正如您在评论中提到的,您可以使用标准的Azure SQL弹性池来实现相同的功能。
弹性池:
- 管理和扩展多个数据库的简单、成本效益的解决方案。
- 资源分配服务,用于扩展和管理性能和成本。
- 允许您为组购买资源。
注意:
当您有多个SQL数据库具有低平均利用率但不经常高利用率时,弹性池非常适合。
池大小:
- 建议将您需要用于个别数据库以满足容量峰值的综合资源大于弹性池所需容量的1.5倍,那么池将具有成本效益。
- 根据性能层级,我们可以将最多100个(或)500个数据库添加到单个池中。
以下是如何将数据库添加到SQL弹性池的步骤:
在上面的图像中,Sports DEV和Test是数据库,我有SQL服务器。
在资源组中创建一个名为SQL ELASTIC POOL的资源。
- 转到配置选项卡。然后添加数据库,然后单击保存。
我已将我的2个数据库添加到SQL弹性SQL池中,并在SQL池中列出它们。
以下是您如何管理SQL弹性池的步骤。
- 调整弹性池设置
- 存储大小和计算大小
- 在Azure SQL数据库中管理弹性池
调整弹性池设置:
- 您可以选择基于DTU或V-core的定价模型。
比较Azure SQL数据库的vCore和DTU基础购买模型
调整数据库设置:
- 这可以针对每个数据库完成。
- 在这里,我们可以更改特定数据库的最小和最大DTU。
在池中添加新数据库:
如果您想要添加新数据库,只需提供数据库的名称。
转到概述并创建数据库。
在SSMS中连接SQL弹性池:
英文:
As you have mentioned in the comment, you can use a standard Azure SQL elastic pool to achieve the same.
Elastic Pool:
- Simple,Cost Effective solution for managing and scaling multiple databases.
- Resource allocation service used to scale and manage the perfomance and manage the performace and cost.
- It allows you to purchase resources for the group.
Note:
Elastic pools are ideally suited, when you have several SQL databases that have a low average utilization, but infrequent, high utilization.
Pool Size:
-
Recomended that the combined resources you would need for individual database to meet the capacity spikes is more than 1.5 times the capacity required for the elastic pool, then pool will be cost effective.
-
Depending on the performace tier we can add up to 100 (or) 500 databases to single pool.
Below are the steps how you can add databases to SQL elastic pool:
in the above image Sports DEV and Test are databases and I have sql server.
Create a resource SQL ELASTIC POOL in your Resource group with server name.
- navigate to the configure tab . And add databases then click save .
I have added my 2 databases in SQL elastic sql pool and they listed in sql pool.
Below are the Steps how you can manage SQL elastic Pool.
- Adjust elastic pool settings
- Storage sizes and compute sizes
- Manage elastic pools in Azure SQL Database
Adjust elastic Pool Settings:
- You can choose DTU based(or) V-core based pricing model.
Compare vCore and DTU-based purchasing models of Azure SQL Database
Adjust database settings:
- This can be done Per Database
- Here we can change the MIN and MAX DTU's for particular database.
Add new database in the pool:
Incase you want add new database you have to just provide the name of the database.
Go to the Overview and create database.
Connecting the SQL elastic pool in SSMS:
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库,让每个人都能够通过互相帮助和分享经验来进步。
评论