What is a Blocking in SQL Server | Find blocking and troubleshooting steps | SQL Interview Q&A

Blocking is completely normal in SQL Server. You will typically be unaware of the many short blocks happening all the time.
Sometimes, blocks take longer than expected to resolve. Blocks of longer duration can create chains, where a blocked process blocks additional processes and so on. This type of blocking scenario is problematic.
The concern is not with blocking, but rather excessive blocking.
Video links below.
*What is Locking in SQL Server
• Locking in SQL Server ...
*Locking Resources in SQL Server
• Locking Resources in S...
*Locking modes in SQL Server
• What are the different...
*Microsoft Documentation on Blocking
learn.microsoft.com/en-us/tro...
*sp_Whoisactive documentation link(to download stored procedure)
github.com/amachanic/sp_whois...
--T-SQL scripts used in this video
**UPDATE in spid 52
begin tran
update table1
set Id = 6201
where Ext = 122
**in spid 54
select * from table1
select request_session_id, request_mode, request_type,
resource_type, resource_description
from sys.dm_tran_locks
select session_id, wait_duration_ms, wait_type,
blocking_session_id, resource_description
from sys.dm_os_waiting_tasks
select session_id, status, wait_time, wait_type, wait_resource, command
from sys.dm_exec_requests where
select * from sys.sysprocesses
sp_whoisactive @get_locks = 1
dbcc inputbuffer(52)
sp_who2 active
kill 52
EXEC sp_configure 'show advanced options', 1;
RECONFIGURE;
EXEC sp_configure 'blocked process threshold', 5
RECONFIGURE;

[@florincopaci6821]

You explain very well. Thank you.

[@tahirhanyildizoglu1461]

thank you for the practical information

[@albantfoot3876]

Just amazing. Thanks

[@tonyettah]

Well, explanatory. Thank you, sir,👍👍👍👍👍

[@Chinnurockbells]

very helping sir, thank you, much appririate , do the more videos on this

[@Malleshp-ec8yi]

Good video

[@shyamdular4800]

Hello sir aap bahut accha padhate hai thank you so much

[@burropoco]

Very helpful and well explained. Thank you.

[@harithad1757]

need session on performance tuning and also how to identify cpu and memory issues

[@shivachithambaram3127]

Hi sir your vidio is soo useful👏👏👏👏👏👏👏👏

[@tarunbisht4786]

U doing such an amazing job sir ,I have one request kindly please make a video that once we become sql dba after that how we can grow and which technology can help us for career growth as well income growth or you can reply on my comment .
In advance thank you so much u doing such an Amazing work 💗

[@righttolearnbk]

After you become SQL dba, focus on SSIS & SSRS and also Learn SQL Azure and do certification on Azure as well. You can also Learn another RDBMS like Oracle, Postgresql, DB2 because a person with multiple technologies have more value in the market.

[@sivasankar7013]

while i am executing sp_whoisactive it shows we cant find a storedprocedure

[@righttolearnbk]

You have to first create a stored procedure with that name. This script is available in Internet.

[@hanumatharaonisankarao5000]

brother can you make a complete video about migration ms SQL?

[@devakumar2911]

Hi can you please share the SQL dba real-time interview questions for senior candidates .

[@righttolearnbk]

👍

[@harithagolla6241]

Hi, please make the video about SQL architecture.

[@righttolearnbk]

Sure, will do it.

[@Malleshp-ec8yi]

I want to learn course bro

[@RaviKiran-sf7ns]

Hi Bro,
Mee videos almost chustunna
Mee laptop configuration enti
4 VMs install chesina Mee laptop Baga fast ga work avutundi, Please suggest best laptop

[@righttolearnbk]

If you install VM on SSD, its performance will be good.
Min 8gb RAM but if you work with more VM that need max RAM then go for 16GB
Intel i5/i7 10th generation

[@RaviKiran-sf7ns]

@@righttolearnbk Thanks for the kind response

[@laxmipriyanka2706]

Did u provide work support

[@righttolearnbk]

As of now, NO beacuse even I work for a company in real time