Capturing query metrics in PostgreSQL can be a challenge. Add in running that PostgreSQL database on Azure and things get even more challenging. However, Microsoft has a great addition to PostgreSQL when running in Azure Database, Query Store. This session will show the great query information available within the Query Store and how to query it.
Resources:
Query Store - Azure Database for PostgreSQL - Flexible Server
Using Azure Query Store to Understand PostgreSQL Performance
Query Store best practices - Azure Database for PostgreSQL - Flexible Server
About Grant Fritchey:
Grant Fritchey works for Red Gate Software as a Product Advocate. Grant has more than 30 years of experience in the industry as a DBA and developer. Grant has written many books including “SQL Server 2022 Query Performance Tuning”. Grant teaches classes on data management and databases to the smallest user groups and largest events, all around the world.
About MVPs:
Microsoft Most Valuable Professionals, or MVPs, are technology experts who passionately share their knowledge with the community. They are always on the "bleeding edge" and have an unstoppable urge to get their hands on new, exciting technologies. They have very deep knowledge of Microsoft products and services, while also being able to bring together diverse platforms, products and solutions, to solve real world problems. MVPs make up a global community of over 4,000 technical experts and community leaders across 90 countries/regions and are driven by their passion, community spirit, and quest for knowledge. Above all and in addition to their amazing technical abilities, MVPs are always willing to help others - that's what sets them apart. Learn more.
View/share our latest episodes on Microsoft Learn and YouTube!
Microsoft
