September 9, 2019 at 5:53 pm
Hi Experts,
I have multiple questions in one thread. please excuse me. All related to one particular query.
We are seeing some pagelatch_up and pagelatch_sh waittypes for one of the query.
What are these waittypes means? Will they go hand in hand ? when do we see both together.
How can we minimize or eliminate these waittypes ?
Also, in sp_whoisactive it is shown on PFS page. my other doubt is that, is it PFS page contention is on tempdb or cmx_ors database?
Is there a way to log that tempdb allocation contention or specific database allocation contention happened in the ERRORLOG . Is there a trace flag to log such information in the errorlog? The reason why I am asking this is, we have a cx asking that we are seeing high waits for a query. if this info is logged somewhere, we can prove at that particular time frame, there was some contention happening. At this point, we are capturing sp_whoisactive output into a table every 15 mins.
Below is the screenshots of sp_whoisactive and some DPA information.
Thanks,
Sam
September 10, 2019 at 6:10 pm
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
September 10, 2019 at 8:01 pm
Common latch information
May be related since you mentioned tempdb. This helps with tempdb contention.
https://logicalread.com/sql-server-tempdb-best-practices-multiple-files-w01/#.XXgAuihKiUk
September 15, 2019 at 6:11 pm
Take a look at this library of wait types from SQLSKills.
Also, do you have any moniotring tools in place, like Database Performance Analyzer?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply