Stack Overflow
Stack Overflow

Questions tagged [azure-elasticpool]

87 questions
0
votes
0 answers

Delete Azure Elastic Pools if Empty

In C# I am using the Azure fluent API Microsoft.Azure.Management.Fluent to manage resources. I want to be able to delete an Elastic Pool if it is empty (e.g. I have just ran a process that deletes a DB within…
Michael Hancock
  • 2,673
  • 1
  • 18
  • 37
0
votes
1 answer

Azure Elastic Pool Database SQL Connections are Timing Out - DTU Purchasing model

We moved my application to the cloud I've moved a local VM SQL database to Azure SQL Elastic Pool databases 50 DTU. Our database size approximately 4Gb. The problem is that the connection to that new Azure SQL database is so slow and getting command…
Ramakrishna.p
  • 1,159
  • 12
  • 31
0
votes
3 answers

Setting LicenseType property of Azure SQL Database to enable Azure Hybrid Use Benefit (AHUB) using Terraform?

Using Terraform, how do I set the Azure SQL Database (and Azure Elastic Pool) LicenseType property to enable Azure Hybrid Use Benefit (aka AHUB, aka AHB)? Here's an example using Powershell: # Azure SQL Database: Set-AzSqlDatabase -DatabaseName…
John Delisle
  • 83
  • 1
  • 9
0
votes
1 answer

Elastic job agent should work with Azure Manage Instance database?

Actually In azure we are using Azure SQL Manage Instance. In or organization one MI server having similar 3 database with different name. Now we need to setup SQL jobs which run against all this three database. If we use SQL agent of MI then we need…
NP007
  • 659
  • 8
  • 21
0
votes
1 answer

How to access data of one DB from another using Elastic Job?

I am trying to access data from one DB to another DB.For that I am using Elastic Job.Using Elastic Job I am to create table from one DB to another.But not able to access data or transfer data.I tried it using External Data source and External…
akshaya parimaladevi
  • 39
  • 5
0
votes
1 answer

Azure Data Flow create many databases in SQL Elastic Pool from one database

I'm quite new in 'Azure'. Is it possible to create many databases in SQL Elastic Pool by Azure Data Factory (Data Flow)? Given: Table Row1 | Value1 Row2 | Value2 After execution I need to get two databases in specific elastic pool. One DB…
Alexey Klipilin
  • 1,866
  • 13
  • 29
0
votes
3 answers

Azure Elastic Database Pools, What is the Maximum Storage Capacity for a Database?

What is the maximum allowed storage capacity for a database for Azure SQL Elastic pool? We expect our database to be say 25-50 TB. Is this permitted? I saw something on Github saying its allowed, however did not see in a Microsoft…
user11912784
0
votes
1 answer

Do Azure Elastic Database Pools allow Cross Database transactions?

We have Stage database, which contains stored procedures, and transfers data into an OLTP Database. Do Elastic SQL Databases reside on same server, and give ability to conduct cross-db stored procedure transactions? Would Elastic databasepool allow…
user11912784
0
votes
2 answers

How to backup and restore databases through stored procedure in Azure SQL using Elastic Pool?

I have a C# ASP.NET MVC based web application in which there is a functionality of Archiving (backup) and Restoring Databases on the click of button. Currently, our system is On-Prem and so we are using the stored procedures in SQL Server to do the…
Hafsa Khan
  • 25
  • 5
0
votes
1 answer

Azure Elastic Pools and Meaning of Capacity DatabaseCapacityMax properties

I'm working through some automation scripts and attempting to identify Elastic Pools that have been defined, but are empty (no databases). Using Get-AzSqlElasticPool, I can grab the name of the pool and its associated properties. Capacity and…
Mike Oryszak
  • 298
  • 2
  • 10
0
votes
2 answers

Getting error at the time of Use-AzureSqlJobConnection -CurrentAzureSubscription

I am trying to execute the script on an elastic pool using powershell. When I execute this command, Use-AzureSqlJobConnection -CurrentAzureSubscription -ResourceGroupName {ABC} It is giving me error for, Use-AzureSqlJobConnection : No Elastic…
Fenil shah
  • 31
  • 4
0
votes
0 answers

After deploying site on azure decrease in response time and increase in database CPU usage

We have Azure-based SQL server in the elastic pool and our application is connected to it. Today, I deployed my .net core Web API on my personal desktop (not even on the server) and response time and CPU usage I can see is much better. When the same…
Dnyaneshwar123456
  • 70
  • 12
0
votes
2 answers

Does Azure elastic DB charge per developer?

So I've been getting my feet wet in Azure SQL databases, and one of the question that I can't quite figure out is whether Azure charges per SQL developer on top of the database costs. If there's a team of 5 DB administrators, are they all allowed to…
Yaga
  • 115
  • 3
  • 17
0
votes
1 answer

copyindex() ARM Template Elastic Pool

I try to minimize my ARM Template but I'm stuck here... My original template is : "parameters": { "subscriptionId": { "type": "String" }, "resourcegroupName": { "type": "String" }, ..... …
Chris
  • 77
  • 1
  • 5
0
votes
1 answer

How to calculate azure elastic pool storage utilization?

I've an Azure elastic pool (Standard, 300 eDTU ) with 105 databases. According to the azure dashboard I've a storage Utilization of 195.92 GB and a Storage capacity of 400 GB. While adding data to a database I got an error message "The elastic pool…
Wim
  • 1
  • 2
1 2 3 4
5
6