Select Page
Identify log write limits on Azure SQL Managed Instance using QPI library

Identify log write limits on Azure SQL Managed Instance using QPI library

Azure SQL Managed Instance is fully managed SQL Server instance hosted in Azure cloud. Managed Instance introduces some limits such as max log write throughput that can slow down your workload. In this post you will see how to identify ... continue reading
Running Azure CosmosDB queries from SQL Server using ODBC driver

Running Azure CosmosDB queries from SQL Server using ODBC driver

Azure CosmosDB provides ODBC driver that enables you to query CosmosDB collections like classic databases. In this post you will see how to query CosmosDB collections from Sql Server using Transact-Sql. Why querying CosmosDB from SQL Server? Cosmos DB enables ... continue reading
Monitor local storage usage on General Purpose Azure SQL Managed Instance

Monitor local storage usage on General Purpose Azure SQL Managed Instance

Azure SQL Managed Instance has predefined storage space that depends on the values of reserved storage and vCores that you choose when you provision the instance. In this post you will see how to monitor storage space on the Managed ... continue reading
Sending resource alerts on Managed Instance using db_mail

Sending resource alerts on Managed Instance using db_mail

One of the biggest issue that you might experience in Managed Instance is reaching storage limit or finding out that you don’t have enough CPU. In this case you would need to get the bigger instance; however, this is not ... continue reading
Analyzing wait statistics on Managed Instance

Analyzing wait statistics on Managed Instance

Wait statistics are information that might help you understand why the query duration is long and identify the queries that are waiting for something in database engine. In this post, I will show to you how to identify why the ... continue reading
Measuring file io performance on Managed Instance using QPI

Measuring file io performance on Managed Instance using QPI

Checking file performance and comparing performance characteristics between SQL Server database engines in Azure cloud and your on-premises environment might be tricky and require some better knowledge of DM objects. In this post, you will see how to use one ... continue reading

Getting started with Azure SQL Managed Instance

Azure SQL Managed Instance is fully managed PaaS version of SQL Server hosted in Azure cloud and placed in you own VNet with private IP address. In this post, I will shortly explain how to configure and create Managed Instance ... continue reading

Recreate dropped database on Azure SQL Managed Instance

Azure SQL Database – Managed Instance is fully-managed PaaS service that provides advanced disaster-recovery capabilities. Even if you accidentally drop the database or someone drops your database as part of security attack, Managed Instance will enable you to easily recover ... continue reading
Azure SQL Managed Instance Business Critical tier is Generally Available

Azure SQL Managed Instance Business Critical tier is Generally Available

We are happy to announce General availability of Business Critical tier in Azure SQL Managed Instance – architectural model built for high-performance and IO demanding databases. After 5 months of public preview period Azure SQL Managed Instance Business Critical Service ... continue reading

Modify Azure SQL Database Managed Instance using Azure CLI

Azure SQL Managed Instance is fully-managed SQL Server Database Engine hosted in Azure cloud. With Managed Instance you can easily add/remove cores associated to the instance and change the reserved size of the instance. You can use Azure CLI to ... continue reading