How scale SQL with Serverless Subtitle Here Andrea
How scale SQL with Serverless Subtitle Here Andrea Tosato, Microsoft MVP, Cloud Solution Architect, 4 ward
Own your career with interactive learning built by community and guided by data experts. Get involved. Get ahead. Explore your PASS community Free online webinar events Local user groups around the world Connect with the global data community . org Online special interest user groups Learning on-demand delivered to you Get involved
Missed PASS Summit 2019? Get the Recordings Download all PASS Summit sessions on Data Management, Analytics, or Architecture for only $399 USD More options available at PASSstuff. com
We are covering all bases to ensure our community can continue reaching new and exciting heights. Plans are underway for the in-person event you all know and love along with a new venture, a new opportunity: a PASS Summit 2020 Virtual Event. Find out more at PASS. org/summit
Thank you to our Global Sponsors and Supporters
Thank you to our Local Sponsors and Supporters
This event was sponsored by Microsoft Learn more about SQL Server 2019 today: -Get free training: aka. ms/sqlworkshops -Download the SQL 19 e. Book: aka. ms/sql 19_ebook
Azure Function Internal From v 1 to v 2 to v 3 Programming Languages Deployment Bindings Azure Functions Host Custom Binding Durable Functions Premium Plan and scalability
Functions runtime 1. 0 vs 2. 0 Functions 1. 0 Functions 2. 0 . NET Support . NET Framework 4. 7. 1 . NET Core 2. 1 Assembly isolation No Yes Bindings versions Runtime versions User controlled Language options Limitations in languages and versions Languages are external to the host Node. js version Node. js 6 only Node. js 8 & 10 + future versions Node. js native modules Not supported Supported HTTP triggers HTTP and specialized Webhooks HTTP (supports Webhooks) Language Runtime Multiple languages per function app Single language per function app Functions Proxies GA GA Open. API definition Preview Not supported Observability Application Insights/Web. Jobs dashboard App Insights
Serverless Functions Serverless Linux Functions Containers Kubernetes Functions Open Source Hosting Io. T Functions On Prem Functions Application Delivery Execution Isolation Infrastructure Operating System Azure Managed Customer Managed
https: //github. com/microsoft/containerregistry/blob/master/clientfirewall-rules. md docker run -d -p 5010: 80 mcr. microsoft. com/azure-functions/dotnet: latest https: //hub. docker. com/_/microsoft-azure-functions-base
Kubernetes Event-driven Autoscaling https: //keda. sh/ Distributed Application Runtime https: //dapr. io/
JS C#
Azure Functions Host – Functions 1. 0 Host Assembly Load Context (default) Load. From Context Windows. Azure. Storage 9. 3. 2 7. 2. 0 Windows. Azure. Storage 7. 2. 0 public static Run(…, Cloud. Block. Blob blob, …)) { //Function code. . . ; }
Azure Functions Host – Functions 2. 0 Host Assembly Load Context (default) Function Assembly Load Context Windows. Azure. Storage 9. 3. 1 Windows. Azure. Storage 9. 5. 0 public static Run(…, Cloud. Block. Blob blob, …)) { //Function code. . . ; }
Language Process Host Process Storage, Event. Hub, Cosmos DB, … Node Worker HTTP request Web Host Script Host IPC Java Worker IPC Server Python Worker
DEMO CUSTOM BINDING
• Maximum Instances allows you to predict your maximum possible bill each month • Minimum Instances • VNET connect to a VNET and securely access resources in a private network (already in App Service Plan)
In the Premium plan there is the ability to specify a number of pre-warmed instances that are kept warm with your code ready to execute. When your application needs to scale, it first uses a pre-warmed instance with no cold start. Your app immediately pre-warms another instance in the background to replenish the buffer of pre-warmed instances. This model allows you to avoid any delay on the execution for the first request to an idle app, and also at each scaling point.
Classic Deployment Issues: Solutions: 1. Not atomic => inconsistent files 1. Externally hosted zip file 2. Files in use get locked 2. Zip file hosted within your app 3. Multi-region inconsistencies 4. Difficult rollback
Ricordatevi di compilate il feedback form https: //speakerscore. com/JTKD Thank you #Sql. Sat 921
- Slides: 33