sqljared
@sqljared.bsky.social
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.
www.sqljared.com
September 1, 2025 at 3:27 AM
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
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.
www.sqljared.com
June 15, 2025 at 7:08 PM
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
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.
www.sqljared.com
July 7, 2024 at 4:30 PM
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
#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
November 27, 2023 at 2:43 AM
#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.
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
September 4, 2023 at 3:51 PM
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