Skip to content

Instantly share code, notes, and snippets.

@ichiroku11
Created May 24, 2017 23:38
Show Gist options
  • Select an option

  • Save ichiroku11/4300e794b065ab086d36f189b6925b2b to your computer and use it in GitHub Desktop.

Select an option

Save ichiroku11/4300e794b065ab086d36f189b6925b2b to your computer and use it in GitHub Desktop.
トレースイベントと拡張イベントの対応を確認するクエリ
select
te.trace_event_id as te_event_id,
te.name as te_event_name,
xe.package_name as xe_package_name,
xe.xe_event_name as xe_event_name
from sys.trace_events as te
inner join sys.trace_xe_event_map as xe
on te.trace_event_id = xe.trace_event_id
where
te.name in (N'RPC:Completed', N'SQL:BatchCompleted');
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment