I've posted two blogs on testing methods of reducing page latch contention. I set up some tables for testing here (www.sqljared.com/blog/page-la...), then tested several approaches and provided results here (www.sqljared.com/blog/page-la...). #sqlfamily #sqlblog
Page Latch Testing - sqljared
I want to test some methods for eliminating page latch waits. Let's set up a test environment with a few tables and make sure we get the waits we expect.
sqljared.com
I've posted a new blog on metrics from Query Store and their relative value at www.sqljared.com/blog/useful-.... I only realized the value of one recently, so I wanted to point it out. #sqlfamily #sqlblog
Five Useful Metrics in Query Store
A discussion of some useful metrics and why they are valuable. One I only realized the utility of recently and wanted to share.
sqljared.com
Pagelatch contention has two main causes; tempdb and the hot page issue. My blog at www.sqljared.com/blog/page-la... provides several possible solutions for the second. #sqlfamily #sqlblog
Page Latch Waits and Solutions - sqljared
Page latch waits have two main causes. One is largely resolved in Microsoft SQL Server 2022, and here are some options for the other.
sqljared.com
#sqlfamily, consider upvoting this feedback to add a filter for an object id\name in Query Store. This will help make variant queries from Parameter Sensitive Plan Optimization more visible and allow us to see a procedure's activity in one view.
Community Community
feedback.azure.com
I've posted a new blog on PSPO at www.sqljared.com/blog/pspo-up.... This blog has links for a known issue, updates a previous script using sys.query_store_query_variant, and discusses PSPO plans with multiple variables. #sqlfamily #sqlblog