| 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="lock_counter_final" maxMemory="4" eventRetentionMode="allowSingleEventLoss" trackCausality="true" dispatchLatency="30" maxEventSize="0" memoryPartitionMode="none">
<templateCategory>
<!-- _locID_text="templateCategory" _locComment = "" -->Locks and Blocks</templateCategory>
<templateName>
<!-- _locID_text = "templateName" _locComment = "" -->Count Query Locks</templateName>
<templateDescription>
<!-- _locID_text = "templateDescription" _locComment = "" -->This template counts the number of locks acquired by each query based on the query_hash value. You can use this template to identify the most lock intensive queries for investigation and tuning.</templateDescription>
<event package="sqlserver" name="lock_acquired">
<action package="sqlserver" name="query_hash" />
<predicate>
<and>
<leaf>
<comparator name="greater_than_uint64" package="package0"></comparator>
<event name="lock_acquired" package="sqlserver" field="database_id"></event>
<value>4</value>
</leaf>
<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="histogram">
<parameter name="filtering_event_name" value="sqlserver.lock_acquired" />
<parameter name="source" value="sqlserver.query_hash" />
</target>
</event_session>
</event_sessions>