Traffic Analyzer Report details
Traffic Analyzer Report details
The traffic analyzer report displays the statistical summary of SQL traffic such as read/write queries, queries in transaction, SQL version etc. Additional information on SSL connections, MARS traffic session count, traffic bifurcation in transaction can also be viewed.
ScaleArc Traffic Analyzer: v1.7.0.1
Date-Time:20_Jul_2017_12_30_34
Processing file : 68_upload_20_Jul_2017_10_27_23_first_capture_2.pcap
Analysis done for database type: MSSQL
Analysis done for port: 2393
------------------------------------------------------------
SUMMARY
------------------------------------------------------------
Load-balancing
Read Queries : 35.79 %
Write Queries : 64.21 %
Stored Procedures: 0.00 %
Unknown(Non Standard Queries): 0.00 %
Traffic Characterstics
TDS Version:
TDS version on the client side:
TDS7.3: 1806
TDS version on the server side:
TDS7.2: 2499
TDS7.3: 1806
Multiple Active Result Sets(MARS) : 0.00 %
Authentication Type
Kerberos: NO
NTLM v1: NO
NTLM v2: NO
Negoex : NO
SQL Authentication: YES
Transactions: 40.32 %
SSL: NO
Cursors: 0.00 %
------------------------------------------------------------
DETAILS
------------------------------------------------------------
Total Queries Analyzed : 11768
Total Read Queries: 4212
Total Write Queries: 7556
Total Stored Procedures: 0
Transactional Details
Total Queries : 4745
Implicit transaction statements: 4092(34.77 %)
Explicit transaction statements: 0(0.00 %)
In transaction statements: 653(5.55 %)
Cursors: 0
Number of SQL sessions in SSL: 0
Multiple Active Result Sets(MARS): 0
Number of SQL sessions: 4334
Authentication
Kerberos: 0
NTLM v1: 0
NTLM v2: 0
Negoex: 0
SQL Authentication: 1806
Undetermined Authentication: 2528
-------------------------------------------------
On this page
Comments