Azure / Azure/azure-powershell

New-AzSqlDatabaseImport extremely slow start

Open
#28,729 2 comments 0 reactions 0 assignees View on GitHub
act-codegen-extensibility-squad customer-reported question Service Attention SQL
Dominant language
C#
Stars
4.8k
Forks
4.3k
Avg merge
2d 17h
Merged PRs (30d)
51

Description

### Description

Hi,

I have a CICD process which restores an Azure SQL Database bacpac from an Azure Storage container. The issue is that it is extremely slow to start. Sometimes taking up to 5hrs to create the database and start the import.

The import itself maybe runs in between 15min-40min max on an S7 database. I cannot seem to understand why this is happening, again it is not the import itself, the process gets stuck on 0/1% for hours which then suddenly kicks off.

There is also a second issue but is less critical, the InProgress can easily get stuck on 100% for hours sometimes up to a day. Is this behavior normal?

Thanks

### Script or Debug output

```PowerShell

```

### Environment data

```PowerShell

```

### Module versions

```PowerShell

```

### Error output

```PowerShell

```

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.