The meta data is from an SQL 2012 Server.
I have posted alot more, find the whole list here.
Goto Definition or MetaData
Definition:
sys.sp_flush_commit_table(bigint @flush_ts, bigint @cleanup_version)
MetaData:
CREATE PROC sys.sp_flush_commit_table (@flush_ts BIGINT, @cleanup_version BIGINT = NULL, @rowcount INT OUTPUT, @date_cleanedup DATETIME OUTPUT) AS
BEGIN
DECLARE @cleanup_ts BIGINT
SET @cleanup_ts = change_tracking_hardened_cleanup_version ()
IF @cleanup_ts > @cleanup_version
SET @cleanup_ts = @cleanup_version
DECLARE @start_ts BIGINT
SET @start_ts = (SELECT MAX(commit_ts) FROM sys.syscommittab)
IF @start_ts IS NULL OR @start_ts < @cleanup_ts
SET @start_ts = @cleanup_ts
INSERT sys.syscommittab
SELECT *
FROM OpenRowset (table SYSCOMMITTABLE, db_id (), @start_ts, 1)
WHERE commit_ts <= @flush_ts
IF @@ROWCOUNT > 10000
SET @rowcount = @@ROWCOUNT
ELSE
SET @rowcount = 10000
DELETE TOP(@rowcount) sys.syscommittab WHERE commit_ts < @cleanup_ts
SET @rowcount = @@ROWCOUNT
select @date_cleanedup=min(commit_time) from sys.syscommittab where commit_ts = (select min(commit_ts) from sys.syscommittab)
IF (@date_cleanedup is null)
SET @date_cleanedup = GETUTCDATE()
END
No comments:
Post a Comment