| Server IP : 180.180.241.3 / Your IP : 216.73.216.252 Web Server : Microsoft-IIS/7.5 System : Windows NT NETWORK-NHRC 6.1 build 7601 (Windows Server 2008 R2 Standard Edition Service Pack 1) i586 User : IUSR ( 0) PHP Version : 5.3.28 Disable Function : NONE MySQL : ON | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : C:/Program Files (x86)/Microsoft SQL Server/110/Tools/Templates/sql/xevent/ |
Upload File : |
<event_sessions xmlns="http://schemas.microsoft.com/sqlserver/2008/07/extendedeventsconfig">
<event_session name="test" maxMemory="4" eventRetentionMode="allowSingleEventLoss" trackCausality="true" dispatchLatency="30" maxEventSize="0" memoryPartitionMode="none">
<templateCategory>
<!-- _locID_text="templateCategory" _locComment = "" -->Query Execution</templateCategory>
<templateName>
<!-- _locID_text = "templateName" _locComment = "" -->Query Wait Statistic</templateName>
<templateDescription>
<!-- _locID_text = "templateDescription" _locComment = "" -->This template tracks internal and external wait statistics for individual query statements, batches and RPCs. This template also collects the query hash and query plan hash for every statement it tracks. Events are only collected from 20% of the active sessions on the server at any given time. You can change the sampling rate by modifying the filter for the event session.</templateDescription>
<event package="sqlos" name="wait_info">
<action package="sqlserver" name="client_app_name" />
<action package="sqlserver" name="database_id" />
<action package="sqlserver" name="query_hash" />
<action package="sqlserver" name="query_plan_hash" />
<action package="sqlserver" name="session_id" />
<predicate>
<and>
<and>
<leaf>
<comparator name="divides_by_uint64" package="package0"></comparator>
<global name="session_id" package="sqlserver"></global>
<value>5</value>
</leaf>
<leaf>
<comparator name="greater_than_uint64" package="package0"></comparator>
<global name="database_id" package="sqlserver"></global>
<value>4</value>
</leaf>
</and>
<leaf>
<comparator name="equal_boolean" package="package0"></comparator>
<global name="is_system" package="sqlserver"></global>
<value>false</value>
</leaf>
</and>
</predicate>
</event>
<event package="sqlos" name="wait_info_external">
<action package="sqlserver" name="client_app_name" />
<action package="sqlserver" name="database_id" />
<action package="sqlserver" name="query_hash" />
<action package="sqlserver" name="query_plan_hash" />
<action package="sqlserver" name="session_id" />
<predicate>
<and>
<and>
<leaf>
<comparator name="divides_by_uint64" package="package0"></comparator>
<global name="session_id" package="sqlserver"></global>
<value>5</value>
</leaf>
<leaf>
<comparator name="greater_than_uint64" package="package0"></comparator>
<global name="database_id" package="sqlserver"></global>
<value>4</value>
</leaf>
</and>
<leaf>
<comparator name="equal_boolean" package="package0"></comparator>
<global name="is_system" package="sqlserver"></global>
<value>false</value>
</leaf>
</and>
</predicate>
</event>
<event package="sqlserver" name="rpc_completed">
<action package="sqlserver" name="client_app_name" />
<action package="sqlserver" name="database_id" />
<action package="sqlserver" name="query_hash" />
<action package="sqlserver" name="session_id" />
<predicate>
<and>
<and>
<leaf>
<comparator name="divides_by_uint64" package="package0"></comparator>
<global name="session_id" package="sqlserver"></global>
<value>5</value>
</leaf>
<leaf>
<comparator name="greater_than_uint64" package="package0"></comparator>
<global name="database_id" package="sqlserver"></global>
<value>4</value>
</leaf>
</and>
<leaf>
<comparator name="equal_boolean" package="package0"></comparator>
<global name="is_system" package="sqlserver"></global>
<value>false</value>
</leaf>
</and>
</predicate>
</event>
<event package="sqlserver" name="rpc_starting">
<action package="sqlserver" name="client_app_name" />
<action package="sqlserver" name="database_id" />
<action package="sqlserver" name="query_hash" />
<action package="sqlserver" name="session_id" />
<predicate>
<and>
<and>
<leaf>
<comparator name="divides_by_uint64" package="package0"></comparator>
<global name="session_id" package="sqlserver"></global>
<value>5</value>
</leaf>
<leaf>
<comparator name="greater_than_uint64" package="package0"></comparator>
<global name="database_id" package="sqlserver"></global>
<value>4</value>
</leaf>
</and>
<leaf>
<comparator name="equal_boolean" package="package0"></comparator>
<global name="is_system" package="sqlserver"></global>
<value>false</value>
</leaf>
</and>
</predicate>
</event>
<event package="sqlserver" name="sp_statement_completed">
<action package="sqlserver" name="client_app_name" />
<action package="sqlserver" name="database_id" />
<action package="sqlserver" name="query_hash" />
<action package="sqlserver" name="query_plan_hash" />
<action package="sqlserver" name="session_id" />
<parameter name="collect_object_name" value="1" />
<parameter name="collect_statement" value="1" />
<predicate>
<and>
<and>
<leaf>
<comparator name="divides_by_uint64" package="package0"></comparator>
<global name="session_id" package="sqlserver"></global>
<value>5</value>
</leaf>
<leaf>
<comparator name="greater_than_uint64" package="package0"></comparator>
<global name="database_id" package="sqlserver"></global>
<value>4</value>
</leaf>
</and>
<leaf>
<comparator name="equal_boolean" package="package0"></comparator>
<global name="is_system" package="sqlserver"></global>
<value>false</value>
</leaf>
</and>
</predicate>
</event>
<event package="sqlserver" name="sp_statement_starting">
<action package="sqlserver" name="client_app_name" />
<action package="sqlserver" name="database_id" />
<action package="sqlserver" name="query_hash" />
<action package="sqlserver" name="query_plan_hash" />
<action package="sqlserver" name="session_id" />
<predicate>
<and>
<and>
<leaf>
<comparator name="divides_by_uint64" package="package0"></comparator>
<global name="session_id" package="sqlserver"></global>
<value>5</value>
</leaf>
<leaf>
<comparator name="greater_than_uint64" package="package0"></comparator>
<global name="database_id" package="sqlserver"></global>
<value>4</value>
</leaf>
</and>
<leaf>
<comparator name="equal_boolean" package="package0"></comparator>
<global name="is_system" package="sqlserver"></global>
<value>false</value>
</leaf>
</and>
</predicate>
</event>
<event package="sqlserver" name="sql_batch_completed">
<action package="sqlserver" name="client_app_name" />
<action package="sqlserver" name="database_id" />
<action package="sqlserver" name="query_hash" />
<action package="sqlserver" name="session_id" />
<predicate>
<and>
<and>
<leaf>
<comparator name="divides_by_uint64" package="package0"></comparator>
<global name="session_id" package="sqlserver"></global>
<value>5</value>
</leaf>
<leaf>
<comparator name="greater_than_uint64" package="package0"></comparator>
<global name="database_id" package="sqlserver"></global>
<value>4</value>
</leaf>
</and>
<leaf>
<comparator name="equal_boolean" package="package0"></comparator>
<global name="is_system" package="sqlserver"></global>
<value>false</value>
</leaf>
</and>
</predicate>
</event>
<event package="sqlserver" name="sql_batch_starting">
<action package="sqlserver" name="client_app_name" />
<action package="sqlserver" name="database_id" />
<action package="sqlserver" name="query_hash" />
<action package="sqlserver" name="session_id" />
<predicate>
<and>
<and>
<leaf>
<comparator name="divides_by_uint64" package="package0"></comparator>
<global name="session_id" package="sqlserver"></global>
<value>5</value>
</leaf>
<leaf>
<comparator name="greater_than_uint64" package="package0"></comparator>
<global name="database_id" package="sqlserver"></global>
<value>4</value>
</leaf>
</and>
<leaf>
<comparator name="equal_boolean" package="package0"></comparator>
<global name="is_system" package="sqlserver"></global>
<value>false</value>
</leaf>
</and>
</predicate>
</event>
<event package="sqlserver" name="sql_statement_completed">
<action package="sqlserver" name="client_app_name" />
<action package="sqlserver" name="database_id" />
<action package="sqlserver" name="query_hash" />
<action package="sqlserver" name="query_plan_hash" />
<action package="sqlserver" name="session_id" />
<predicate>
<and>
<and>
<leaf>
<comparator name="divides_by_uint64" package="package0"></comparator>
<global name="session_id" package="sqlserver"></global>
<value>5</value>
</leaf>
<leaf>
<comparator name="greater_than_uint64" package="package0"></comparator>
<global name="database_id" package="sqlserver"></global>
<value>4</value>
</leaf>
</and>
<leaf>
<comparator name="equal_boolean" package="package0"></comparator>
<global name="is_system" package="sqlserver"></global>
<value>false</value>
</leaf>
</and>
</predicate>
</event>
<event package="sqlserver" name="sql_statement_starting">
<action package="sqlserver" name="client_app_name" />
<action package="sqlserver" name="database_id" />
<action package="sqlserver" name="query_hash" />
<action package="sqlserver" name="query_plan_hash" />
<action package="sqlserver" name="session_id" />
<predicate>
<and>
<and>
<leaf>
<comparator name="divides_by_uint64" package="package0"></comparator>
<global name="session_id" package="sqlserver"></global>
<value>5</value>
</leaf>
<leaf>
<comparator name="greater_than_uint64" package="package0"></comparator>
<global name="database_id" package="sqlserver"></global>
<value>4</value>
</leaf>
</and>
<leaf>
<comparator name="equal_boolean" package="package0"></comparator>
<global name="is_system" package="sqlserver"></global>
<value>false</value>
</leaf>
</and>
</predicate>
</event>
<target package="package0" name="event_file">
<parameter name="filename" value="query_wait_analysis.xel" />
</target>
</event_session>
</event_sessions>