Jan 13, 2016: Azure SQL DB Monitoring & Performance Tuning

Download the Introduction to Statistics presentation slides and demo script here.
 

Julie Koesmarno
Azure SQL DB Monitoring & Performance Tuning

Choosing appropriate performance levels, monitoring and optimizing resource usage of Azure SQL database is of primary interest to SQL database users. Azure SQL DB now has a number of great tools to help sizing, scaling, monitoring and performance tuning your database solutions. This talk will provide an overview of resource usage monitoring, scaling capabilities and techniques as well as performance tuning tools that you can use today, such as Query Store, Index Advisor, Extended Events and DMVs

Julie’s presentation deck is available here.  She maintains an active blog with a lot of very useful information.  Her latest post about our meeting is here.

Julie Koesmarno Julie, MCSE Data Platform, and MCSE Business Intelligence, MCT, is a Senior Program Manager at Microsoft, with a Bachelor’s degree in IT. She has over 10 years of experience working with SQL Server for large-scale and multi-million-dollar OLTP and ETL projects as a SQL Server developer and system analyst/designer. Her past projects include delivering a SQL Server 2012 data warehouse and BI solutions in the US and Australia. She now works with hybrid, cloud and on-prem SQL projects.


Vern Rabe
Introduction to Statistics

When the SQL Server optimizer evaluates a query to determine how best to execute it, the statistics are quite possibly the most important tool at its disposal. In this introductory session, we’ll discuss what statistics are, how the optimizer uses them, and some general guidelines for their maintenance.

Vern Rabe Vern (LinkedIn) is an independent SQL Server consultant and contract trainer in Portland, OR. He has attained MCSE, MCITP (both Administration and Development), and MCT certifications, among others. Vern has been working with databases since 1992, and has worked with SQL Server since version 4.21a. He provides broad technical SQL Server skills gained from the mixture of academic and practical experiences acquired from his classroom instructing and varied consulting contracts.

Register NowDon’t miss this meeting!

Refreshments graciously provided.

Featured Sponsor: Idera
Visit our website for more details.


We wish to acknowledge the OSHU Information Technology Group for supporting Oregon SQL by generously providing the meeting venue.


This entry was posted in Announcements. Bookmark the permalink.