Advertisement
Guest User

Untitled

a guest
Jul 24th, 2017
88
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.29 KB | None | 0 0
  1. CREATE EVENT SESSION [Test] ON SERVER
  2. ADD EVENT sqlserver.rpc_completed(
  3. ACTION(
  4. package0.callstack,
  5. package0.collect_cpu_cycle_time,
  6. package0.collect_current_thread_id,
  7. package0.collect_system_time,
  8. package0.event_sequence,
  9. package0.last_error,
  10. package0.process_id,
  11. sqlos.cpu_id,
  12. sqlos.numa_node_id,
  13. sqlos.scheduler_address,
  14. sqlos.scheduler_id,
  15. sqlos.system_thread_id,
  16. sqlos.task_address,
  17. sqlos.task_elapsed_quantum,
  18. sqlos.task_resource_group_id,
  19. sqlos.task_resource_pool_id,
  20. sqlos.task_time,
  21. sqlos.worker_address,
  22. sqlserver.client_app_name,
  23. sqlserver.client_connection_id,
  24. sqlserver.client_hostname,
  25. sqlserver.client_pid,
  26. sqlserver.context_info,
  27. sqlserver.database_id,
  28. sqlserver.database_name,
  29. sqlserver.is_system,
  30. sqlserver.nt_username,
  31. sqlserver.plan_handle))
  32. GO
  33. DROP EVENT SESSION [Test] ON SERVER
  34. GO
  35.  
  36. CREATE EVENT SESSION [Test] ON SERVER
  37. ADD EVENT sqlserver.rpc_completed(
  38. ACTION(
  39. package0.callstack,
  40. package0.collect_cpu_cycle_time,
  41. package0.collect_current_thread_id,
  42. package0.collect_system_time,
  43. package0.event_sequence,
  44. package0.last_error,
  45. package0.process_id,
  46. sqlos.cpu_id,
  47. sqlos.numa_node_id,
  48. sqlos.scheduler_address,
  49. sqlos.scheduler_id,
  50. sqlos.system_thread_id,
  51. sqlos.task_address,
  52. sqlos.task_elapsed_quantum,
  53. sqlos.task_resource_group_id,
  54. sqlos.task_resource_pool_id,
  55. sqlos.task_time,
  56. sqlos.worker_address,
  57. sqlserver.client_app_name,
  58. sqlserver.client_connection_id,
  59. sqlserver.client_hostname,
  60. sqlserver.client_pid,
  61. sqlserver.context_info,
  62. sqlserver.database_id,
  63. sqlserver.database_name,
  64. sqlserver.is_system,
  65. sqlserver.nt_username))
  66. GO
  67. DROP EVENT SESSION [Test] ON SERVER
  68. GO
  69.  
  70. package0.callstack,
  71. package0.collect_cpu_cycle_time,
  72. package0.collect_current_thread_id,
  73. package0.collect_system_time,
  74. package0.event_sequence,
  75. package0.last_error,
  76. package0.process_id,
  77. sqlos.cpu_id,
  78. sqlos.numa_node_id,
  79. sqlos.scheduler_address,
  80. sqlos.scheduler_id,
  81. sqlos.system_thread_id,
  82. sqlos.task_address,
  83. sqlos.task_elapsed_quantum,
  84. sqlos.task_resource_group_id,
  85. sqlos.task_resource_pool_id,
  86. sqlos.task_time,
  87. sqlos.worker_address,
  88. sqlserver.client_app_name,
  89. sqlserver.client_connection_id,
  90. sqlserver.client_hostname,
  91. sqlserver.client_pid,
  92. sqlserver.context_info,
  93. sqlserver.database_id,
  94. sqlserver.database_name,
  95. sqlserver.is_system,
  96. sqlserver.nt_username,
  97. sqlserver.plan_handle,
  98. sqlserver.query_hash,
  99. sqlserver.query_hash_signed,
  100. sqlserver.query_plan_hash,
  101. sqlserver.query_plan_hash_signed,
  102. sqlserver.request_id,
  103. sqlserver.server_instance_name,
  104. sqlserver.server_principal_name,
  105. sqlserver.server_principal_sid,
  106. sqlserver.session_id,
  107. sqlserver.session_nt_username,
  108. sqlserver.session_resource_group_id,
  109. sqlserver.session_resource_pool_id,
  110. sqlserver.session_server_principal_name
  111.  
  112. Microsoft SQL Server 2016 (SP1) (KB3182545) - 13.0.4001.0 (X64)
  113. Oct 28 2016 18:17:30
  114. Copyright (c) Microsoft Corporation
  115. 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