We just rolled a bunch of servers to SQL Server 2016, and we're now getting this in our event log, once every 5 minutes, for each server. On the plus side, I didn't know about telemetry_xevents before, and it looks like a nice new tool to query. However, I don't need these.
Here's how to prevent them from showing up. Super-simple exclusion.
INSERT INTO ENAudit_Exclusion_List
(exclusion_set,
exclusion_type,
excluded_value,
insert_datetime,
update_datetime,
active
)
VALUES ('aw', -- exclusion_set - char(2)
'ObjectName', -- exclusion_type - varchar(128)
'telemetry_xevents', -- excluded_value - varchar(128)
GETDATE(), -- insert_datetime - datetime
null, -- update_datetime - datetime
1 -- active - bit
)
Wednesday, March 1, 2017
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment