Azure SQL Database

Billing question

My DB invoice was too high last month. I need to understand the reason so that I can proactively manage it. I do have budget set up but I didn't get any notification and received a high invoice. My database and usage are not high to be charged $180…

How do I fix a connection access issue to my database server on azure?

|System.Data.SqlClient.SqlException: Database 'GetSketchy_QA' on server 'getsketchy-serverqa.database.windows.net' is not currently available. Please retry the connection later. If the problem persists, contact customer support, and provide them the…

HypeScale SQL DB, when will the "allocated" disk space auto increase? - Used space 10.07 TB Allocated space 10.1 TB

On my HypeScale SQL DB, when will the "allocated" disk space auto increase? currently Used space is 10.07 TB and Allocated space is 10.1 TB For Azure SQL Database Hyperscale, you do not manually increase the disk size from 10 TB to 11…

SQL Server instance CPU persistently high

We have a database pool that has been running well, however since ~13 May the pool has been consistently high CPU. There is a lot of noise of legit queries, so I am showing smaller windows. The last hour looks like this. Zooming to a similar time period…

How to resolve Databases inaccessible due to CMK TDE key access lost, configuration now correct but databases not recovering

Trying to raise a support ticket but it sent me here. Issue type: Technical Service: SQL Database Environment: Production Severity: Critical (users unable to access production system) Problem type: Security, Private and Compliance Summary:…

Elastic pool stuck in “Provisioning” after failed scale to 800 DTU — cannot revert to 50 DTU

I have an Azure SQL Elastic Pool that became stuck in a “Provisioning” state after a failed scale-up operation to a higher DTU level. The scale operation did not complete, and now the pool cannot be scaled up or down. Symptoms: The elastic pool shows…

Number of concurrent transactions supported for an Azure SQL 4 vCores (scalable within Serverless range)

Accidental switch to vCore model causing unexpected high accumulated charges on Dev Database

Hello Azure Support Team, I am writing to request a one-time billing concession for my current unbilled usage. I have a small development/testing Azure SQL Database that is normally kept on the DTU purchasing model, which costs me around $5 per…

sql server management studio 2018 user setup

how to set up user account and login for sql server management studio 2018 and connect to database

Why has my Azure SQL Database Hyperscale instance been effectively down for the past 30 minutes?

The database is Azure SQL Database Hyperscale (PRMS, 24 vCores). CPU utilization was consistently between 60–80%, then suddenly dropped to 0% about 30 minutes ago and has not recovered. The database appears unresponsive. Can you help determine: Whether…

Azure elastic job agent - lost user identity and cannot be updated

elastic job agent has User managed identity associated and used to access database. The UID disappeared today (and jobs cannot connect to the database) all attempts to re-establish the UID fail with an error: Operation nameCreate or update Azure SQL DB…

Azure SQL Database Query Performance, misleading as it includes primary and standby data

Query Performance is including information for primary and secondary (note this is a business critical read-only replica, not a geo). Take a query ID provided, go to query store, it shows on Secondary, not Primary. This gives misleading information as…

while importing an on-prem sqlserver 16 bacpac backup stored in azure blob, to create an azure sql database getting error

What is wrong in here? How can I fix this issue. Thanks, Jai {   "code": "ImportExportJobError",   "message": "The ImportExport operation with Request Id 'xxxx' failed due to 'The ImportExport operation with…

Database Latency issue

We are trying this sql database as centralized as we want the flow of data from different regions through the database. Right now this server is in west europe and we are trying to access in India and China at this time, In India the latency is about 5-6…

Azure SQL database audit logs (for CREATE/UPDATE/DELETE/DROP/ALTER) not working.

After enabling SQL Auditing on both the Azure SQL Server and Azure SQL Database, and configuring audit logs to be sent to the Log Analytics workspace, we are not seeing audit events for CREATE, UPDATE, DELETE, DROP, or ALTER operations in the…

SqlException in stored procedure of an Azure SQL database that goes away when updating stored procedure without any changes

We have a stored procedure in an Azure SQL database which uses OPENJSON to access a json value. The field containing the value is checked with ISJSON to make sure that it really contains valid json. This stored procedure randomly throws an SqlException…

unable to create free tier database

I am getting below error .I just activated my free teir ccount Your subscription does not have access to create a server in the selected region. For the latest information about region availability for your subscription, go to aka.ms/sqlcapacity. Please…

Understanding Temp Storage Cleanup and IOPS Utilization in Azure SQL Managed Instance

I have a couple of questions regarding Azure SQL Managed Instance storage and performance metrics. 1. TempDB Storage Behavior Our Azure SQL Managed Instance shows approximately 1.1 TB allocated for TempDB storage from the time the instance was…

Create SQL Database not allowing me to use the (US) East US region

I'm following along on creating a single database - Azure and when I try to use my "Free" subscription I get this error: Your subscription does not have access to create a server in the selected region. For the latest information about region…

Unable to Enable Zone Redundancy for Azure SQL Managed Instance in East US 2

Issue Summary We are attempting to enable Zone Redundancy for our Azure SQL Managed Instance deployed in the East US 2 region. According to Microsoft documentation and the Azure region availability information, East US 2 supports Zone Redundant…