SESSION Details

Different dimensions of monitoring and tuning performance for Azure SQL

You moved to the Azure SQL Database, so your job is done - right? No, you still need to monitor and performance tune your database.
It can be overwhelming having to learn a whole new set of tools and new performance constraints. In the cloud, improving performance can directly lower your costs, making it important to manage and optimize.

In this demo centric session, we will show you how to monitor and troubleshoot Azure SQL/Managed Instance database performance issues. We will see the differences between on-prem SQL Server Vs Azure SQL/Managed Instance cloud database performance troubleshooting. And we will also see how to juggle between cost and performance to find the optimal ground with low cost and high performance of your Azure SQL database with scalability. We will generate Power BI powered database scorecards for trend analysis.
After this session you would be empowered with knowledge and tools to monitor and tune your Azure SQL database.

feedback link: https://sqlb.it/?7049

Starts: 12:00 10th Mar 2022
Ends: 12:50 10th Mar 2022

Q&As

Short Description
- Azure SQL performance capabilities, how to configure and maintain your Azure SQL for higher performance. We will explore various monitoring tools and pick few scenarios for deeper troubleshooting. In this demo centric session, we will tune our database and find an optimal ground to manage cost. We will generate Power BI powered database score card for trend analysis.

Speakers

Surbhi Pokharna
Deepthi Goguri

Tags

AzureMoving to the CloudOn PremisesIAAS VM BasedFuture DBAOperational DatabasesVisualising and Actioning DataDevelopingManagingMonitoringOptimisingAzure SQL DatabaseDatabase EngineManaged InstanceMove to the CloudPower BIQuery StoreSQL 2019SQL 2022IntermediateHow

The SQL Bits Story

SQLBits was formed in 2007 by a group of volunteers who were passionate about the SQL Server product suite and wanted to provide much-needed community-driven education to the data community.

As one of the largest data platform conferences in the world, we offer more opportunities to a wider audience.

15 Years

We’ve grown and expanded a lot since 2007.

2500 Participants

SQLBits is the best place to meet fellow data professionals.

82 Countries

We welcome data professionals from all over the globe.

1140 recorded sessions

All the live sessions are recorded and offered for free, year round.

Experience the SQLBits Conference

Previous
Next

Want to be part of the SQLBits community?

Attend the London conference in-person or virtually on 

March 8-12, 2022 at ExCel London, UK.