Monthly Archives: July 2023
3. 9, 53, 56. DTU-based purchasing model, Server vs Serverless So if that is the Vcobased purchasing model, what is the DTU based purchasing model? Well, DTU are little units. They’re called database transaction units. And they are packages of maximum number of compute, memory and input output or read and write resources for each… Read More »
DP-300 Microsoft Azure Database – Configure Azure SQL Database resource for scale and performance
1. 9. configure Azure SQL Database for scale and performance In this section we’ll be looking at how to configure Azure SQL database for scale and performance. So let’s go to Azure SQL and we create a new SQL database. So there are three different types. Single database. So this is obviously a single database.… Read More »
DP-300 Microsoft Azure Database – Identify performance-related issues Part 2
3. 49. identify sessions that cause blocking In this video, we’re going to have a look at blocking. What is blocking? Well, here we have an update statement. So it’s going to update this table. So where the city is equal to Toronto, it’s then going to say, well, make the city equal to Toronto… Read More »
DP-300 Microsoft Azure Database – Identify performance-related issues
1. 48, 60. Query Store – an introduction Hello. And in this section we’re going to be identifying performance related issues. First of all we’re going to be using the Query Store to help us. What is the Query Store? Well, it contains three different stores. A plan store for executing plan data, a runtime… Read More »
26. Azure Databricks – Sending logs to Azure Monitor In this chapter, I am going to give just a quick note on sending the application logs from Azure Databricks onto Azure Monitor. I’m also going to include this link as a resource on to this chapter. So this link actually gives you the way in… Read More »
24. Azure Stream Analytics – Diagnostics setting And welcome back. Now in this chapter I just want to go through the diagnostic settings that is available for your Azure Stream antics job. So even earlier on we had seen that we could actually direct the logs the pipeline runs when it came on to Azure… Read More »
22. Azure Stream Analytics – More on partitions Now in this chapter, I just want to go through some more notes when it comes to your partitions in Azure Steam Attics. So when it comes to your Stream antics job, there is something known as a compatibility level. Now, by default, the compatibility level at… Read More »
20. Azure Event Hubs and Stream Analytics – Partitions Now in this chapter I want to talk about partitions. Now when it comes to Azure Event Hubs, you can actually have partitions in place and then you can also make use of these partitions when it comes to your Azure Steep Antics job, they’re actually… Read More »
18. Azure Stream Analytics – The importance of time So in the previous chapter, we had looked at the metric of the watermark delay. In this chapter, I just want to stress the fact about how important time is when it comes to Azure Stream antics, because all of the queries that you actually write… Read More »
13. Azure Data Factory – Pipeline Failures Now in this chapter, I just want to give a quick note when it comes to your pipeline failure runs. Now, what I’ve done is I’ve created two pipelines, pipeline one and pipeline two. So if I go on to pipeline one here I just have a simple… Read More »