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 instant operation. In this post, you will see how you can monitor resource usage and…


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 workload is waiting and what are the queries that are waiting on some resources.


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 open-source library that can help you to analyze and compare file performance.


How to get Azure SQL database size

There are multiple ways to achieve this and there are also some storage types you should be aware There is a good doc about this at https://docs.microsoft.com/en-us/azure/sql-database/sql-database-file-space-management


Azure Stream Analytics now supports Azure SQL Database as reference data input

Reference data is a dataset that is static or slow changing in nature which you can correlate with real-time data streams to augment the data. Azure Stream Analytics leverages versioning of reference data to augment streaming data by the reference data that was valid at the time the event was generated. One of the most…


Announcing the JDBC Driver 7.2 RTW!

We are pleased to announce the production release of the Microsoft JDBC Driver 7.2 for SQL Server! The 7.2 Release To World (RTW) includes the following items since the previous RTW release: Added Added APIs for DataSourceFactory and OSGI Framework #700 Added support for OffsetDateTime to be passed as ‘type’ in ResultSet.getObject() #830 Added support for Active…


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 including network environment, migrate your databases and manage databases after migration.


Lesson Learned #63: It is possible to create Linked Server in Azure SQL Managed Instance?

The answer is Yes!!! and to create it you only need to follow up the instructions provided in this URL   Unfortunately, nowadays, you only are able to use the SQL provider to connect to Azure SQL Database, SQL Server or Azure SQL Managed Instance. My lessons learned in this situation is you need to pay attention For Azure SQL Database: Please review…


Lesson Learned #57: Bacpac export process doesn’t include the automatic statistics

Hello Team, Today, I worked on a performance case that our customer claimed about a performance issue with a copied database from other one. The source database was working as they expected but the new database didn’t. Our customer mentioned that the database are identical. Working on this issue I found one item that represents the copied database hasn’t…


Lesson Learned #53: Why do you need to use dm_operation_status dynamic management view?

Hello, This week I worked in a new issue that remembered me the importance to use the dynamic management view called dm_operation_status in every operation that I’m doing with any database either Azure SQL Database or Azure SQL Managed Instance. As most probably you know every database creation, modification, deletion, copy , etc.. is asyncronous process,…