Pagelatch contention has two main causes; tempdb and the hot page issue. My blog at https://www.sqljared.com/blog/page-latch-waits/ 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. https://feedback.azure.com/d365community/idea/b211acea-6125-ec11-b6e6-000d3a4f0da0
I've posted a new blog on PSPO at https://www.sqljared.com/blog/pspo-update-and-observations/. 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
I've posted a second blog about PSP Optimization at https://sqljared.com/blog/variant-queries-in-query-store/. Check it out to see why you may need to update your Query Store scripts for #SQLServer2022. #sqlfamily #sqlblog
My latest blog on Parameter Sensitive Plan Optimization in SQL Server 2022 is up at https://www.sqljared.com/blog/parameter-sensitive-plan-optimization/. My next post will be on this subject as well, discussing an issue that may affect your Query Store scripts! #sqlfamily #sqlblog
Posted a new blog about Manual Halloween protections and how this coding technique can allow you to skip unnecessary write operations at https://www.sqljared.com/blog/manual-halloween/. #sqlfamily #sqlblog
My latest blog on the Halloween Problem is up at https://www.sqljared.com/blog/halloween-problem-examples-for-updates/. Complete with examples showing the typical protections and some performance numbers. #sqlfamily #sqlblog
My latest blog on tempdb contention is up at https://sqljared.com/blog/tempdb-contention-in-2023/. I discuss improvements that minimize its effects and have several useful links on the subject. #sqlblog #sqlfamily
Posted my last blog about being an introvert at #PASSDataCommunitySummit and how I approached the networking opportunities there at https://www.sqljared.com/blog/introversion-and-pass-summit/. Happy new year, #sqlfamily! #sqlblog
@AtlSql I've seen several references to the server @[email protected] created, and I just joined it. That might have enough gravity for #sqlfamily to reform there.
@arrowdrive lol. but seriously, looking forward to seeing you in Seattle.
SQL Server engineer and educator since 2003. Database Engineer for ChannelAdvisor. Anime and pizza enthusiast. Blogging at http://sqljared.com.