What is blocking and how would you troubleshoot it? : sql server database administration
- 1 Answers
- 1121 Views
- I also Faced
- E-Mail Answers
Answer Posted / Mohit Madaan
Blocking in SQL Server occurs when one transaction holds a resource (like a table or row) that another transaction needs, causing the second transaction to wait. To troubleshoot blocking, you can use DBCC INPUTBUFFER and DBCC OPENQUERY to identify the blocked queries, SP_WhoIsActive to get detailed information about active sessions, and DBCC BLITZCACHE to check cached query plans.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to provide default values to function parameters?
How do I find the sql server version?
Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60
How to connect php with different port numbers?
What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?
If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?
What is the difference between upgrade and migration in sql server?
How can I check that whether automatic statistic update is enabled or not?
If any stored procedure is encrypted, then can we see its definition in activity monitor?
What is an indexed view?
What is standby servers? Explain types of standby servers.
what is the difference between openrowset and openquery?
Can we shrink data file in sql server?
Can sql servers link to other servers like oracle?
What is temporary table in sql server? Why we use temp table?
