Transcription

Message Analyzer Parsers for SQLBin GuoSoftware Engineer

Agenda

Choose Microsoft Message Analyzer to capture and analyzeMicrosoft SQL Protocol Messages4321012Series33Series24Series156

Choose Microsoft Message Analyzer to capture and analyzeMicrosoft SQL Protocol Messages1012Series33Series2Series1456

Choose Microsoft Message Analyzer to capture and analyzeMicrosoft SQL Protocol Messages2Has MS-TDS Parser100.511.5Series322.5Series23Series13.544.5

Choose Microsoft Message Analyzer to capture and analyzeMicrosoft SQL Protocol Messages4321012Series33Series24Series156

Choose Microsoft Message Analyzer to capture and analyzeMicrosoft SQL Protocol Messages4321012Series33Series24Series156

MA SQL parsers make debugging SQL protocolimplementation easier

What SQL Protocol Parsers does MA provide?Network Connectivity and Application Development parser package

Get MA SQL parsersWindowsParsersCore and Common ParsersMicrosoft Message Analyzer (MA)MS-TDS Parser

Get MA SQL parsersWindowsParsersSQLParsersCore and Common ParsersMicrosoft Message Analyzer (MA)

Get MA SQL parsers

Get MA SQL parsers

Get MA SQL parsersC: Users [UserName] AppData Local Microsoft MessageAnalyzer OPNAndConfiguration OPNs

What do parsers do?E4074C69736110Recognize thosemessagesbelongE4 074C69736110 to SQL protocols.Type 0xE4Age Reassemble packets in toName a long message.Length 0x070x4C6973610x10Parsing the raw data based on the message syntaxdefined in Microsoft open specification.Value definitionMappingType PersonShowingnot onlyLength 6 the parsed data in UI, but also thedefinitionNamebehind Lisathe data which is defined in Microsoftopen specificationAge 16Decoding encoded stream to make it human-readable.

What do parsers do?Recognize those messages belong to SQL protocols.Reassemble packets in to a long message.Parsing the raw data based on the message syntaxdefined in Microsoft open specification.Value definitionMappingShowing not only the parsed data in UI, but also thedefinition behind the data which is defined in Microsoftopen specificationDecoding encoded stream to make it human-readable.Beyond the message syntax validation, parsers can alsoprovide the protocol level restriction validation

Demo 1 – Message Analyzer: Start Local Trace

Demo 2 – Demonstrate Capture Filter and debugging MS-TDStest suite1) Create a capture session, configure provider andcapture filter.2) Start MS-TDS Test Suite Test case and start capturing3) See whether the messages are parsed clearly4)Show Viewpoints,Grouping Analyzing Function.3) Export selected messages into .CAP file.

Demo 3 – Open an MS-SSAS-T capture fileSee the difference comparing parsing result with andwithout MSSSAS OPN.

ResourcesMicrosoft Message Analyzer download ils.aspx?id 44226Microsoft Message Analyzer Operating yzer/microsoft-message-analyzeroperating-guideThe Open Protocol Notation (OPN) Programming Guide ng%20Guide%20v4.4.docxAll the OPN parsers source installed ft\MessageAnalyzer\OPNAndConfiguration\OPNs

Summary MA is the best to capture and analyze Microsoft SQL Protocols 3 SQL Protocol Parser packages of MA SQL parser features How to Get MA SQL parsers Demo:MA SQL parsers make debugging SQL protocolimplementation easier

Thank you