Advertisement · 728 × 90

Posts by sqljared

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.

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

7 months ago 2 1 0 0
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.

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

9 months ago 9 6 0 0

I've only used it a few times, and only recently. So I haven't seen CPU or thread exhaustion, but that's good to know.

1 year ago 0 0 1 0
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.

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

1 year ago 3 0 3 0

Travel safe and have fun!

2 years ago 1 0 0 0
Community Community

#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.

2 years ago 3 0 0 0

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

2 years ago 5 0 0 0