Modernizing SSRS And A Step-by-Step Guide to Bringing ReportServer Databases to SQL Managed Instance
This article summarizes various options that can be taken to modernize SQL Server Reporting Services (SSRS) and then provides a detailed step-by-step guide to bringing report server databases to Azure SQL Managed Instance.
Changing default MAXDOP in Azure SQL Database and Azure SQL Managed Instance
To improve customer workload performance and reduce unnecessary resource utilization, the default MAXDOP setting for new databases and managed instances in Azure SQL is changing from the previous default of 0 (unlimited) to 8.Storage performance best practices and considerations for Azure SQL DB Managed Instance (General Purpose)
First published on MSDN on Jul 20, 2018 Reviewed by: Kun Cheng, Borko Novakovic, Jovan Popovic, Denzil Ribeiro, Rajesh Setlem, Arvind Shyamsundar, Branislav UzelacIn this article, we describe database storage architecture on Azure SQL Database Managed Instance (MI), for General Purpose (GP) instances specifically.
Increase data file size to improve HammerDB workload performance on General Purpose Managed Instance
The General Purpose tier of Managed Instance uses Azure Premium Storage to store database files. In Azure Premium Storage IO performance depends on the file size. Increasing file size might be an easy way to improve your performance. In this post you will see how to increase performance of HammerDB workload from 20K transactions/minute to 100K-300K transactions/minute by increasing the database file size.Monitoring options available for Azure SQL Managed Instance
For customers in production with Azure SQL Managed Instance, to ensure business continuity you might want to consider continuously monitoring and tuning the instance performance. This article provides a single point of view describing options available to you in setting up resource, performance monitoring and alerting on your managed instance.Introducing Azure SQL Managed Instance Next-gen GP
The next generation of the general purpose service tier for Azure SQL Managed Instance is a major upgrade that will considerably improve the storage performance of your instances while keeping the same price as current general purpose tier. Key improvements in the next generation of general purpose storage include support for 32 TB of storage, support for 500 DBs, lower storage latency, improved storage performance, and the ability to configure the amount of IOPS (I/O operations per second).
