message analyzer parsers for sql - interop events · sql ma parsers dev plan overview analysis...
TRANSCRIPT
Message Analyzer Parsers Overview
Windows Parsers
Office and SharePoint
Parsers
Exchange, Skype
Parsers
SQL Parsers
Core and Common Parsers
Microsoft Message Analyzer (MMA)
SQL MA Parsers Dev Plan Overview
Analysis Services parser package covers 3 protocols MS-ASUR, MS-SSAS, MS-SSAST (coming soon)
Reporting Services parser package covers 1 protocol MS-RSREST (coming soon)
Network Connectivity and Application Development parser package covers 1 protocol MS-TDS (already published in Microsoft Common parser package)
Features
Parsing the raw data based on the message syntax defined in Microsoft open specification.
Decoding encoded XML stream to provide a clear structure layout in UI.
Recognize those messages belong to SQL protocols.
Value definition MappingShowing not only the parsed data in UI, but also the definition behind the data which is defined in Microsoft open specification
Beyond the message syntax validation, parsers can also provide the protocol level restriction validation
Demo 1 – Basic Parser Features Show
Capture Protocol: MS-TDS over TCP
Use SQL Server Management Studio insert a Row data in a table in a database.
• Show Basic Parser Features• Show MA feature
Flat Message ListDiagnosis error report
Demo 2- Directly open .cap file
Directly open .cap file
Protocol: MS-SSAS over SOAP
• Show features1) SSAS parser shows message info more concise than SOAP layer2) How to open OPN source code in MA
Resources
All the OPN parsers source code
C:\Users\[UserName]\AppData\Local\Microsoft\MessageAnalyzer\OPNAndConfiguration
Microsoft OPN Programming Guide v4.4
http://download.microsoft.com/download/3/E/8/3E845130-349C-4EFC-B634-C7DBD46140B7/OPN%20Programming%20Guide%20v4.4.docx
Demo 1 – Basic Parser Features Show
Capture Protocol: MS-TDS over TCP
Use SQL Server Management Studio insert a Row data in a table in a database.
• Show Basic Parser Features• Show MA feature
Flat Message ListDiagnosis error report