| 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 : /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="connection_problems" maxMemory="4" eventRetentionMode="allowSingleEventLoss" trackCausality="true" dispatchLatency="30" maxEventSize="0" memoryPartitionMode="none">
<templateCategory>
<!-- _locID_text="templateCategory" _locComment = "" -->System Monitoring</templateCategory>
<templateName>
<!-- _locID_text = "templateName" _locComment = "" -->Connection Tracking</templateName>
<templateDescription>
<!-- _locID_text = "templateDescription" _locComment = "" -->This template tracks connection activity for a server. Normal connection activity is tracked using the login and logout events, and problems are recorded using the connectivity_ring_buffer_recorded event.</templateDescription>
<event package="sqlserver" name="connectivity_ring_buffer_recorded">
<action package="sqlserver" name="client_app_name" />
<action package="sqlserver" name="client_connection_id" />
<action package="sqlserver" name="client_hostname" />
<action package="sqlserver" name="context_info" />
<action package="sqlserver" name="server_principal_name" />
<action package="sqlserver" name="session_id" />
</event>
<event package="sqlserver" name="login">
<action package="sqlserver" name="client_app_name" />
<action package="sqlserver" name="client_connection_id" />
<action package="sqlserver" name="client_hostname" />
<action package="sqlserver" name="context_info" />
<action package="sqlserver" name="server_instance_name" />
<action package="sqlserver" name="server_principal_name" />
<parameter name="collect_options_text" value="1" />
</event>
<event package="sqlserver" name="logout">
<action package="sqlserver" name="client_app_name" />
<action package="sqlserver" name="client_connection_id" />
<action package="sqlserver" name="client_hostname" />
<action package="sqlserver" name="context_info" />
<action package="sqlserver" name="server_instance_name" />
<action package="sqlserver" name="server_principal_name" />
<action package="sqlserver" name="session_id" />
</event>
<target package="package0" name="ring_buffer" />
</event_session>
</event_sessions>