In this blog post, I discussed some facts about Azure SQL Database Serverless. If someone wants to avoid those limitations and disable ‘Auto-pause,’ how costly is it? Suppose a serverless database is not paused and configured with 4 max vCores and 0.5 min vCores corresponding to 2.1 GB min memory. Then the minimum compute bill […]
Serverless is a compute tier for single databases in Azure SQL Database that automatically scales compute based on workload demand and bills for the amount of compute used per second. The serverless compute tier also automatically pauses databases during inactive periods when only storage is billed and automatically resumes databases when activity returns. https://docs.microsoft.com/en-us/azure/azure-sql/database/serverless-tier-overview Few […]
We might not be together for PASS Summit this year, but we are still together for #sqlrun. Join other attendees as we walk/run/jog, from where we are each attending PASS Summit this year. If you do not have a Strava account, create one at Strava.com. Join the “PASS SQL Run 2020” club anytime starting Monday, […]
I want to thank all of the participants of T-SQL Tuesday #132. If I missed your post, it was not intentional. Please let me know, and I will add it here. I am proud of this community and feel lucky to be a small part of it. I admire everyone who joined the blog party […]
Accessing runtime information of a query execution plan is vital to get a precise understanding of resource usage, execution patterns to resolve performance issues. Runtime statistics is beneficial while debugging query performance issues, such as long-running queries, and queries that run indefinitely and never finishes. Historically query completion was a prerequisite for the availability of […]
