SQL Managed Instance

  1. Enable Flag 4199

    The global APP "1C" ERP for enterprise needs Flag 4199.
    Ukraine, Russia, Czech Republic, Poland, Belarus - uses this app as for accounting.
    One of the problem to connect to SQL Managed Instance DB - Flag 4199.
    It's stops to migrate to SQL Managed Instance DB Thousands of enterprise companies.

    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. Upload custom certificat

    Native DNS name for smi is not user friendly.
    We could define a custom DNS but then we get trouble with encryption.
    There is option to "trustServerCertificate" but this option is not available for all client (ie Power BI desktop)

    It's should be great if we get ability to upload custom certificate (with alternate subject Name) to SMI.

    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 →
  3. 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

    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. Create a Database Snapshot

    Kindly support Database Snapshot

    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 →
  5. Migrate from Azure SQL database to a managed instance

    Add support to migrate from azure SQL database to managed instance

    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. 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

    1 vote
    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. Storage Auto Scaling on SQL Managed Instance

    Scaling a managed instance is a manual activity. We manually provision storage capacity based on anticipated application demands.

    Can we have a option scaling automatically scales storage capacity in response to growing database workloads, with zero downtime.

    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 →
  8. support for in-memory in Managed instance(BC Tier) during bacpac import

    While importing a bacpac from on-prem database with in-memory tables through SSMS v 18.1 on Managed instance (Business critical Tier), we get an error message related to filegroup. The MSDN doc suggests that in-memory objects are supported on BC tier and not in GP tier, but we are getting error messages in BC tier (attached file). Could you please let me know if it is a bug? and how to resolve this issue. The following is the create database script

    Error :

    Error SQL72014: .Net SqlClient Data Provider: Msg 10797, Level 15, State 2, Line 1 Only one MEMORYOPTIMIZED

    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. Allow virtual cluster naming

    We would like the ability to name the virtual cluster resource per our company standards and move to resource group we dedicated to sql managed instances.

    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. Looking for compatibility issues migrating SQLServer onprem to AzureSQLMI

    Could someone help me with all the compatibility issues while migrating SQLServer onprem to AzureSQLMI considering all features enabled at source server. And also issues/blockers migrating SSIS to Azure SQL MI.

    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 →
  11. Increase file disk size without having to grow the file

    Since the IOPS and MB/s performance is tied to the size of the disk (P10 128gb, 500 IOPS, 100 MB/s etc.), we should be allowed to assign larger disks to a file without having to grow the file first (as this activity evidently costs more money, but more importantly consumes unnecessary instance space). As a P10 disk would natively be assigned to host an application Db of 100gb, if this DB had a decent read write load from both the application and downstream reporting activities batching data into a DW etc., is not sufficient (not even close..). Therefore you are…

    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 →
  12. Increase reserved size limit of Business Critical Azure SQL Managed Instance to 8TB, 16 TB

    Add higher storage SKUs for business critical Azure SQL Managed instance. Currently for Gen5 Business Ctitical Service Azure SQL managed instance restricts max instance reserved storage size to 4 TB for 32, 40, 64, 80 vCores, there is no option for higher storage needs greater than 4TB.

    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. Enable timezone change for production instances

    The time zone of an existing managed instance can't be changed.
    I know we can provision a new instance and migrate the data but the downtime is a major blocker for my 24/7 application.

    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 →
  14. Allow multiple secondary replicas for SQL Managed Instance

    Would help to allow multiple secondary replicas for SQL Managed Instance. This would help to off load read access of different client data to be loaded to different replicas, Multiple reporting users and ad-hoc query users on a single secondary replica can slow down the overall performance.

    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. Logic Apps connector for Managed Instance

    Is there a Logic Apps connector available Managed Instance (Hyperscale or General Purpose or Business Critical) ?

    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 →
  16. Disable database backups for a time window to increase I/O for batch processes

    We are using SQL Server for an informational database (no online transactions) and are getting performance issues since database backups start at the time we are still processing ETL workloads (SSIS reading) this causes significant performance issues.

    It should be nice for us to set an exclusion window or set an start/end signal so no backup is needed for this period (our processes are on the fly and there's no point in restoring to any time point between the beginning and the end of the proccess).

    Other option is that this can be set by forcing database backups before our…

    3 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 →
  17. Azure SQL MI and Azure-hosted SharePoint 2016 and 2019 Farms

    Azure SQL MI is now generally available to host Azure-hosted SharePoint 2016 and 2019 farms, but how about in GOV?

    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. Higher performance using newer amd epyc rome 7742 cpus instead of older intel models

    The vCPUs and memory in Gen4/5 VMs isn't great. Our 5 year old servers we moved from have a higher per vCPU performance compared with whats available in azure. The newer epyc rome 7742 should enable enhanced performance for a managed instance for CPU, IO and memory bandwitdh and higher memory to core ratios.

    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 →
  19. Share the List of Patches applied on the SQL MI

    It would be great if we have the list of patches applied on the OS level and SQL Level. It's more of informational message.

    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. Monitor the Secondary replica

    Business critical Managed instance has additional secondary replica which can be used to offload read workload. However currently there is no mechanism to effectively monitor the secondary workload.

    dmdbresource_stats doesn't contain metadata for more than an hour. Please introduce effective mechanism to monitor the secondary replica of Managed Instance

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

SQL Managed Instance

Categories

Feedback and Knowledge Base