Shulou(Shulou.com)05/31 Report--

This article is about how to use sp_replflush in the database. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

EXEC sp_repldone @ xactid = NULL, @ xact_segno = NULL, @ numtrans = 0, @ time = 0, @ reset = 1

EXEC sp_repldone @ xactid = NULL, @ xact_segno = NULL, @ numtrans = 0, @ time = 0, @ reset = 0

Exec sp_replflush

With cte as (select replace (hostname,'','') as hostname,' + replace (program_name,'',') +'as program_name

, loginame, db_name (a.dbid) AS DBname,spid,blocked,waittime/1000 as waittime,a.status,a.lastwaittype,a.cmd

, Replace (substring (b.textjol 1340),'','') as sqlmessage,cpu

From sys.sysprocesses as a with (nolock)

Cross apply sys.dm_exec_sql_text (sql_handle) as b

Where a.blocked > 0 and sql_handle0x0000000000000000000000000000000000000000

And waittime > 2000)

Select replace (hostname,'','') as hostname,' + replace (program_name,'','') +''as program_name

, loginame, db_name (a.dbid) AS DBname,spid,blocked,waittime/1000 as waittime,a.status,a.lastwaittype,a.cmd

, Replace (substring (b.textjol 1340),'','') as sqlmessage,cpu

From sys.sysprocesses as a with (nolock)

Cross apply sys.dm_exec_sql_text (sql_handle) as b

Where exists (select blocked from cte where cte.blocked=a.spid)

And not exists (select spid from cte where cte.spid=a.spid)

Union all

Select * from cte

Thank you for reading! This is the end of the article on "how to use sp_replflush in the database". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, you can share it for more people to see!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.