February 2, 2015 at 6:07 am
There is one background block by process is running (spid:41) with sa user on User database.
this process is blocking to other processes at the same sql job is running same user database.
When i checked with sp-who2 its showing Host-name (server-name), command (insert), blk by db name (above database name) only other columns are empty.
can any one help-out me how can i fix it ?
February 2, 2015 at 7:41 am
Use the dynamic management views to gather better information. Sys.dm_exec_requests will show you the processes. That will let you more easily see what the query is of the blocking process:
SELECT * FROM sys.dm_exec_requests AS der
CROSS APPLY sys.dm_exec_sql_text(der.sql_handle) AS dest;
Just add a WHERE clause for the process id. sp_who2 is a very old school way to look at servers and their status. I strongly recommend you take a look at this book.
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply