SQL Managed Instance

  1. Support for Proximity placement groups

    We're trying to use SQLDB Managed Instance in a migration from the mainframe.

    We need to do a huge aggregation process on the application VM, but the VM and DB latency is as slow as 1.5 milliseconds, causing performance problems.We also tested it using the Business Critical SKU, but the performance is still lacking.

    If the VM and SQLDB Managed Instance could be set up in the same PPG, this issue could be greatly improved.

    37 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  2. Option to configure the number of diff backups to take per day to save costs

    Deleting a large amount of data or temporarily enabling a high level of auditing will cause all subsequent diffs before the next full to be significant in size. As designed, I believe that MS takes two diffs a day, so assuming that we are paying per byte stored we are then forced to pay for twice the amount of storage compared to if we could configure the SQLMI to perform only a single diff for that period. By allowing the user to control how many diffs to take the user can better control costs around these times.

    25 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  3. Metric alerts on % storage usage

    Actually we can't monitor remaining storage space of SQL MI as there is no metric on % of storage used.

    It' important to have this metric to be able to define alerts on remaining storage space as we have on Azure SQL Database.

    10 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  4. Support DNS aliasing of an Azure SQL Managed Instance (at least for public endpoint)

    As it is already supported for Azure single SQL Database, it would be nice to be able to create an alias for the Managed Instance, especially for the public endpoint address. All clients connecting directly to the public endpoint would be able to use an alias instead of the real name of the instance. Switching instances, disaster recovery, migration scenarios would be a lot easier to handle.
    FYI, creating a public CNAME record redirecting to the public endpoint address of an MI (like instancename.public.***.database.windows.net) does NOT work : IP resolution is good, but no way to login to the instance…

    117 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    planned  ·  10 comments  ·  Flag idea as inappropriate…  ·  Admin →
  5. Create linked server to databrick hive tables

    We would like to use managed instance to be able to query hive tables instead of running a self hosted SQL server on a VM solely for this purpose.

    8 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  6. Change default Backup retention on entire Instance

    Azure SQL Managed Instance has the capability to change the backup retention policy from 7 up to 35 days, but there's no way to change this setting in an instance level.

    Since we're migrating existing On-premises DBs to MI and the retention must be at least 30 days, we have to manually change this setting on every DB migrated. There are around 6000 DBs planned to move to Azure SQL MI but with that limitation is gonna be really hard to cope and monitor this setting.

    It would be really nice if we could just set the default retention on…

    11 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    under review  ·  0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  7. Place the virtual cluster in the same resource group as the managed instance

    Right now the Managed Instance creation process places the Virtual Cluster resource inside the virtual network resource group even if you choose to place the Managed Instance in another resource group.
    This is annoying, not user friendly and breaks security policies and task delegations. We should be able to choose where resources are to be deployed.

    9 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  8. Implement Long term backup

    PITR of 35 days is not enough for our production databases.

    We need long-term backup as it's done on Azure SQL Database.

    101 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    14 comments  ·  Flag idea as inappropriate…  ·  Admin →

    Announcing limited public preview availability of LTR backup for up to 10 years for Managed Instance for EA and CSP subscriptions. There are limited number of seats available for whitelisting subscriptions and will be fulfilled on the first come – first serve basis. For customers enrolled, production support will be provided. The feature is now available through PowerShell only. Azure portal should be coming in a few months. To sign up create Azure support ticket: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-long-term-retention#managed-instance-support

    We sincerely appreciate your feedback.
    Managed Instance product group

  9. Dual login strategy for read only replicas

    Having the ability to have different users and permissions on read only replicas vs the primary replica will allow securing read only workloads in a way not possible today. If a user neglects to add the read only application intent to the connection string, they would be hitting the primary replica inadvertently. It would be good to have a different user for the read only replica that doesn't have read permissions on primary.

    4 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  10. Read only replica with dual indexing strategy

    Since Business Critical comes with read only replicas that can serve read only queries, having the ability to tune those RO replicas with different indexes than the primary replica would optimize read only workloads.

    4 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  11. Create a Database Snapshot

    Kindly support Database Snapshot

    12 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Flag idea as inappropriate…  ·  Admin →
  12. Need ability to copy individual Databases between sql managed instances and subscriptions easily.

    There appears to be no easy way to copy databases between sql managed instances across subscriptions. It would be very helpful to allow "Create Database2 As copy of Database1" to work this way or to have Azure CLI or Power Shell cmdlet options to do this. The only current way I know of is to take a backup only after disabling encryption and store it in Azure Storage Account then copy this restore to another Storage Account in another subscription and then restore. The process of disabling encryption and re-enabling it is problematic and at times there have been issues…

    5 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  13. Copy database from managed instance to another managed instance

    We have a managed instance with the wrong timezone so we want to create a new managed instance with the right timezone and copy the databases to the new managed instance.

    7 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  14. Provide Managed Instance reports on PITR usage and Managed Instance Set Retention

    @Jamal Blackwell

    We are charged for PITR that exceeds the allowable provided limit but do not know what databases are consuming excessive space. We have the ability to update the retention of each database to manage the PITR consumption, but are unaware of which databases are major contributors of consumption. It is essentially getting an invoice without billed item and just seeing a TOTAL DUE. I am suggesting the two following ideas that will assist in cost management of PITR:


    1. Total storage used for Azure automated backups per Managed Instance compared to non-charged allowable amount. It would be even better…

    2 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  15. windows authentication in azure sql db managed instance

    I have read in many forums that currently Azure SQL Database managed instance doesn't support "Windows Authentication". Is there any workaround for this? or ETA for MI to support Windows auth

    12 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    under review  ·  0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  16. Add connection to CosmosDbB

    SQL Managed Instance needs a connection to Azure Cosmos DB so we can access data stored in the db with procedures. This will allow us to join data between the two technologies. I know stand alone SQL server can do this the ODBC, but this is not an option on MI.

    2 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  17. sp_OACreate support for SQL MI

    It would be great to have the support for sp_OACreate in SQL MI as well. This is a blocker for customer who want to migrate to SQL MI from SQL Server in certain cases.

    1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  18. Increase log file throughput

    Actually log file thoughput on SQL Azure Managed Instance is limited to 48 MB/s in Business critical Tier
    Please increase this to improve bulk workloads

    7 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Flag idea as inappropriate…  ·  Admin →
  19. More granular vCore count i.e. 2,4,6,8,10,12,14,16. 2 for DEV/TEST

    More granular vCore count i.e. 2,4,6,8,10,12,14,16. 2 for DEV/TEST. The jump between 8 and 16 is too great. Need options in-between.

    1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  20. Enable ADSDSOObject support.

    We want to migrate our on-premise SQL databases to SQL managed instances. We currently depend upon the ability to query Active Directory using ADSDSOObject in Linked servers. The current status of SQL managed instances shows that ADSDSOObject is not registered. Please add ADSDSOObject support for querying and integrating with Active Directory.

    3 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
← Previous 1 3 4 5 6 7
  • Don't see your idea?

SQL Managed Instance

Categories

Feedback and Knowledge Base