Copy the script in SQL Management Studio
Run it.
-- open transaction details
set nocount on
--SELECT
--er.session_id
----,er.open_transaction_count
--FROM sys.dm_exec_requests er
--where open_transaction_count > 0
--GO
declare @session_id nvarchar(50)
DECLARE session_id CURSOR FOR
SELECT
er.session_id
--,er.open_transaction_count
FROM sys.dm_exec_requests er
where open_transaction_count > 0
OPEN session_id
FETCH NEXT FROM session_id INTO @session_id
WHILE @@FETCH_STATUS = 0
BEGIN
declare @cmd nvarchar(4000);
Set @cmd = 'dbcc inputbuffer(' + @session_id + ')';
select @cmd
exec(@cmd)
FETCH NEXT FROM session_id INTO @session_id
END
CLOSE session_id
DEALLOCATE session_id
set nocount off 
The script will be helpful to kill all the user sessions before performing the refresh of the database.
2019-05-03 (first published: 2011-03-29)
2,622 reads
2019-05-03 (first published: 2010-12-15)
2,929 reads
There can be a great difference in the performance of a particular routine in a test database, and in a fully loaded production system. When you hit performance problems in a database under load, and there is excessive locking and blocking, how can you determine exactly where the problems lie, in order to fix them?
2010-10-22
3,228 reads
This article analyzes the performance gains of batching multiple DML statements into a single transaction. New author Manor Lev-Tov examines the effect of grouping statements together instead of running them all as separate transactions.
2010-01-21
6,062 reads