SQL Managed Instance

  1. 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 →
  2. 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 →
  3. 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 →
  4. 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 →
  5. Add SQL Managed Instance quota to the subscription quota page

    Currently I can't see SQL Managed Instance quota usage and limit in the subscription quota page, which makes it difficult to manage.

    I've been told by support this functionality doesn't currently exist and can't be queried via PowerShell either.

    *Currently the only way to see the current limit is via logging a quota increase support ticket. But this doesn't show current usage of the quota, and is a pain to go check in each subscription.

    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 →
  6. 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 →
  7. 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 →
  8. Time of day control of Full Backups by Database

    Some large databases can take hours to do a full backup and we find this happens at the worst possible time of the day! We'd like to specify an ideal time window for when a full backup should to begin.

    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 →
  9. Backup history isn't visible within managed instance MSDB

    I'd like to be able to have visibility of the backup history within SQL for managing when database backup sizes get out of expected range, when and why.

    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 →
  10. 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 →
  11. 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 →
  12. 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 →
  13. Allow renaming of logical file names for Managed Databases

    When creating a Managed Database on a Managed Instance. I would like the ability to define the logical name of the database files. We are monitoring some aspects of performance. Some of which down to the particular files. Its is not clear which database data file is under load without joining to other DMVs to get this. Especially where 3rd party monitoring software is being used. Its not quite straightforward to take information from a dedicated tool and working out which database it belongs to when they mostly have the same name.

    Even if it was just a case of…

    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 →
  14. 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 →
  15. Enabling QDS for Read-only Replica provided with BC critical MI

    As we get a RO replica with a business-critical MI and if we are using it support our production load Its better to have it equipped that way as well for troubleshooting issues.

    Currently, we do face performance issues and we really can not do anything about it as with the Replica neither we are not able to use profiler or QDS nor we can see its utilization on resources

    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 →
  16. 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 →
  17. Add support for Linux SQL MI ODBC driver to support Azure AD MFA, similar to Windows driver for cross platform app development

    Add support for Linux SQL MI ODBC driver to support Azure AD MFA, similar to Windows driver, for cross platform app development

    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. 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 →
  19. 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 →
  20. 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 →
← Previous 1 3 4 5 6 7
  • Don't see your idea?

SQL Managed Instance

Categories

Feedback and Knowledge Base