Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE EVENT SESSION [Test] ON SERVER
- ADD EVENT sqlserver.rpc_completed(
- ACTION(
- package0.callstack,
- package0.collect_cpu_cycle_time,
- package0.collect_current_thread_id,
- package0.collect_system_time,
- package0.event_sequence,
- package0.last_error,
- package0.process_id,
- sqlos.cpu_id,
- sqlos.numa_node_id,
- sqlos.scheduler_address,
- sqlos.scheduler_id,
- sqlos.system_thread_id,
- sqlos.task_address,
- sqlos.task_elapsed_quantum,
- sqlos.task_resource_group_id,
- sqlos.task_resource_pool_id,
- sqlos.task_time,
- sqlos.worker_address,
- sqlserver.client_app_name,
- sqlserver.client_connection_id,
- sqlserver.client_hostname,
- sqlserver.client_pid,
- sqlserver.context_info,
- sqlserver.database_id,
- sqlserver.database_name,
- sqlserver.is_system,
- sqlserver.nt_username,
- sqlserver.plan_handle))
- GO
- DROP EVENT SESSION [Test] ON SERVER
- GO
- CREATE EVENT SESSION [Test] ON SERVER
- ADD EVENT sqlserver.rpc_completed(
- ACTION(
- package0.callstack,
- package0.collect_cpu_cycle_time,
- package0.collect_current_thread_id,
- package0.collect_system_time,
- package0.event_sequence,
- package0.last_error,
- package0.process_id,
- sqlos.cpu_id,
- sqlos.numa_node_id,
- sqlos.scheduler_address,
- sqlos.scheduler_id,
- sqlos.system_thread_id,
- sqlos.task_address,
- sqlos.task_elapsed_quantum,
- sqlos.task_resource_group_id,
- sqlos.task_resource_pool_id,
- sqlos.task_time,
- sqlos.worker_address,
- sqlserver.client_app_name,
- sqlserver.client_connection_id,
- sqlserver.client_hostname,
- sqlserver.client_pid,
- sqlserver.context_info,
- sqlserver.database_id,
- sqlserver.database_name,
- sqlserver.is_system,
- sqlserver.nt_username))
- GO
- DROP EVENT SESSION [Test] ON SERVER
- GO
- package0.callstack,
- package0.collect_cpu_cycle_time,
- package0.collect_current_thread_id,
- package0.collect_system_time,
- package0.event_sequence,
- package0.last_error,
- package0.process_id,
- sqlos.cpu_id,
- sqlos.numa_node_id,
- sqlos.scheduler_address,
- sqlos.scheduler_id,
- sqlos.system_thread_id,
- sqlos.task_address,
- sqlos.task_elapsed_quantum,
- sqlos.task_resource_group_id,
- sqlos.task_resource_pool_id,
- sqlos.task_time,
- sqlos.worker_address,
- sqlserver.client_app_name,
- sqlserver.client_connection_id,
- sqlserver.client_hostname,
- sqlserver.client_pid,
- sqlserver.context_info,
- sqlserver.database_id,
- sqlserver.database_name,
- sqlserver.is_system,
- sqlserver.nt_username,
- sqlserver.plan_handle,
- sqlserver.query_hash,
- sqlserver.query_hash_signed,
- sqlserver.query_plan_hash,
- sqlserver.query_plan_hash_signed,
- sqlserver.request_id,
- sqlserver.server_instance_name,
- sqlserver.server_principal_name,
- sqlserver.server_principal_sid,
- sqlserver.session_id,
- sqlserver.session_nt_username,
- sqlserver.session_resource_group_id,
- sqlserver.session_resource_pool_id,
- sqlserver.session_server_principal_name
- Microsoft SQL Server 2016 (SP1) (KB3182545) - 13.0.4001.0 (X64)
- Oct 28 2016 18:17:30
- Copyright (c) Microsoft Corporation
- Developer Edition (64-bit) on Windows Server 2012 R2 Standard 6.3 <X64> (Build 9600: ) (Hypervisor)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement