All Questions
5 questions
0
votes
1
answer
309
views
How does blocking increase sos_scheduler_yield wait?
What is the correlation between blocking and CPU? Because I am reaching the conclusion that the blocking is causing my sos_scheduler_yield wait type to increase, but I would like to understand the ...
- 817
2
votes
0
answers
316
views
Same temp table has created by different session and occurs blocking issue. how to avoid it?
It's a SQL Server 2012 EE.
One session (SID=90) executed a JOIN query, and it's generated a temp table internally by SQL Server.
But another sessions (SID=103, 109, 110,116) from totally different ...
- 61
4
votes
2
answers
2k
views
Contention on tempdb due to high concurrency temp table creation from multiple databases?
I have an environment with ~100 databases, all with the same schema. There is a stored procedure on each database that creates a #temp table and drops it, and is running very often (every 30 seconds ...
- 399
6
votes
1
answer
5k
views
How to solve blocking on tempdb
I am having tempdb contention (I guess, at least) on one of the servers (SQL Server 2008 R2).
Both the blocker and the waiters (10 of them) has PAGELATCH_EX wait type on database tempdb and all ...
- 1,550
1
vote
1
answer
1k
views
TempDB Query being Blocked
I have been monitoring Blocking issues on our SQL Server database. Very often the below query is running on tempdb and is blocked with LCK_M_S
What is this query used for and why does it run ...
- 1,414