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
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.
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
Travel safe and have fun!
#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
