June 6, 2012

sp_MSwritemergeperfcounter (Transact-SQL MetaData) Definition

Please note: that the following source code is provided and copyrighted by Microsoft and is for educational purpose only.
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_MSwritemergeperfcounter(int @agent_id
, int @thread_num
, nvarchar @counter_desc
, int @counter_value)

MetaData:

 create procedure sys.sp_MSwritemergeperfcounter   
(
@agent_id int,
@thread_num int,
@counter_desc nvarchar(100),
@counter_value int
)
AS
begin
-- only sysadmin or db_owner have access to call this function
if is_member('db_owner') <> 1
return 1

if object_id('MSmerge_perfcounters') is NULL
begin
create table dbo.MSmerge_perfcounters
(
agent_id int NOT NULL,
thread_num int NULL,
counter_desc nvarchar(100) NOT NULL,
counter_value int NOT NULL,
cur_time datetime NOT NULL
)
end

insert into dbo.MSmerge_perfcounters values (@agent_id, @thread_num, @counter_desc, @counter_value, getdate())

return 0
end

No comments:

Post a Comment

Total Pageviews