Workers
2 TopicsLesson Learned #458: High Login Impact on Azure SQL Database Worker Utilization: A Case Study.
Today, we encountered an interesting scenario with one of our customers. They reported a rapid increase in the number of workers in their Azure SQL Database, which they attributed to a high volume of logins. This situation presents an opportunity to delve into how logins, query durations, and potential blockings among queries can influence worker utilization.2.3KViews0likes0CommentsLesson Learned #337: HADR_SYNC_COMMIT wait type delay in Azure SQL Database
Today, I worked on a service request that our customer faced a performance issue in their business critical service tier database. Their main suspect was that the syncronization with the secondary replica has a delay.3.6KViews1like2Comments