#1 most frequent
United States of America
61.6%682 installations of 1,107
What is Azure SQL Managed Instance?
Azure SQL Managed Instance is a scalable cloud database service that combines SQL Server database engine compatibility with a fully managed and evergreen platform as a service.
Categories & Use Cases
Product Demos
Top Performing Features
Ease of building user interfaces
Ability to build flexible user interfaces using drag-and-drop tools
Category average: 8
Scalability
Ease of scaling up or down to meet demand
Category average: 8.3
Platform management overhead
Resources required to keep platform up and running
Category average: 7.7
Areas for Improvement
Issue monitoring and notification
Integrated monitoring and notification of issues and problems
Category average: 7.3
Issue recovery
Ease of recovery from problem state
Category average: 7.2
Upgrades and platform fixes
Ease of deployment of major upgrades or problem fixes
Category average: 7.7
Who Buys & Uses Azure SQL Managed Instance
#2 most frequent
Canada
8.2%91 installations of 1,107
#3 most frequent
United Kingdom of Great Britain and Northern Ireland
5.9%65 installations of 1,107
Azure_SQL a good rdbms for cloud
Use Cases and Deployment Scope
Run our supply chain applications using Azure*SQL developed in micro-services architecture.
Pros
- executes the queries efficiently
- has tools/dashboards to show where the query problems lie
- alerting for problems
Cons
- be able to find situation where it uses a bad query plan due to lack of right stats
- auto scale the CPU when load requires it
- auto update stats has opportunities in it. so people still have to restart to stopping auto update stats for some situations
Return on Investment
- it had a positive impact to my business and allowed me to be able to move my workload from on-premise to cloud.
Usability
Alternatives Considered
IBM Informix
Azure SQL great for our data
Use Cases and Deployment Scope
This handles our database instances for web based applications. Azure SQL Instances are a better use of our web based data than any other instance, and we can use it amongst other Microsoft products to create dynamic data driven content for leadership to make quick, decisive decisions that can benefit our customer base.
Pros
- ease of use with microsoft products
- data management
- GUI interfacing
Cons
- hard to use without Microsoft knowledge
- Intimidating CLI
- Commands are not intuitive
Return on Investment
- Decision Driven decisions have been quicker
- Negatively cumbersome at start when training
- Positive use of PaaS services instead of devoting VMs
Alternatives Considered
MySQL
Other Software Used
Microsoft 365, Azure Virtual Machines, Microsoft IIS