Azure SQL Database Managing your database on the

Azure SQL Database - Managing your database on the cloud

Event Sponsors Expo Light Sponsors

Agenda: • What is Cloud Computing? • What is a SQL Database? • How to manage a SQL Database?

Vitor Fava • • • SQL Server Database Consultant at Pythian Data Platform MVP Pass Chapter Leader at SQLManiacs You. Tube. com/vitortff Linkedin. com/in/vitorfava Facebook. com/vitortadeu. fava Instagram. com/vitor. fava @sqlservermaniac

What is Cloud Computing?

What is SQL Database? • Relational database service in the cloud; • Delivers predictable performance, scalability with no downtime, business continuity and data protection; • SQL Database supports existing SQL Server tools, libraries and APIs;

What is SQL Database? • Singleton; • Elastic Pool; • Managed Instance (Preview);

SQL Database – Singleton Service Tiers

What is DTU? • DTU = Database Throughput Units • Resources assigned to a database 40% CPU 30% Writes Utilization Reads • Unified measure of CPU+Memory+Read/write rates 65% 50% Memory

What is DTU – DTU Calculator • How to calculate the needed DTU to my SQL Database? • You can predict the service tier • Too much: Not cost effective. • Too less: You can put your database in trouble (and you!). • DTU Calculator • Online service (http: //dtucalculator. azurewebsites. net/) • Based on collected performance indicators. • Processor - % Processor Time • Logical Disk - Disk Reads/sec • Logical Disk - Disk Writes/sec • Database - Log Bytes Flushed/sec • Does not take into account: • Uptime SLA • Point in time Restore • Performance Objective

Demo Time

Scaling Up or Scaling Down

What is an Elastic Pool? • Provide a simple cost effective solution to manage the performance goals for multiple databases that have widely varying and unpredictable usage. • Elastic database pools ensure that databases get the performance resources they need, when they need it, while providing a simple resource allocation mechanism within a predictable budget • Advantage of all of the database as a service capabilities that are built into it;

SQL Database – EP Service Tiers

Demo Time

When should you consider a elastic pool?

Demo Time

Managing the SQL Database Azure Portal • Web-based application where you can create, update, and delete databases and logical servers and monitor database activity SSMS and Data Tools • Client tools that run on your computer and allow you to connect to, manage, and develop your database in the cloud. Command line tools • You can use command line tools such as Power. Shell to manage databases and elastic database pools, and to automate Azure resource deployments.

Monitoring a SQL Database DMVs Extended Events Query Performance Insight

Thank you!!!!!