Category: SQL Tuning

Query Store for Azure PostgreSQL

Query Store is not just for Microsoft SQL Server and Azure SQL Database anymore. Microsoft announced back in Oct 2018 that Query Store was available in Public Preview for PostgreSQL. How cool is that! As Microsoft continues to expand the Azure Data Platform with including MySQL, PostgreSQL, and others, features that we know and love […]

New vCore Compute Levels for Azure SQL Database and Elastic Pools

Additional vCore-based elastic pools and single databases have been expanded for the general purpose, business critical, and hyperscale service tiers. This provides customers with more flexibility and options when migrating DTU-based deployments and right-sizing workloads for the cloud. Azure SQL Database, Elastic Pools, and Hyperscale have two processor types to select from. Gen 4 offers […]

Get OS Counter Memory Available Mbytes Using TSQL

I have been working recently in making sure that max memory is configured for the hundred plus database servers I support.  In reading numerous books, blog post and attending various talks on memory management people reference the OS memory counter “Available Mbytes” a lot. Various references state that this value should be between 150 and […]

Performance Impact from Page Splits

Recently I was brought in to help troubleshoot performance issues on a database server.  Going through my typical check list I noticed memory pressure on the box and made the recommendationof more memory which was simple to fix. What caught my attention though was that blocking was occurring on a transaction that was trying to […]