Re: request/response style profiling

Not having a public protocol certainly does NOT mean that there's no way to
parse the binary data. For example, some client access libraries such as ADO
have documented & even supported de-serialization methods which you can use
to reverse a byte stream to an instance of an object. This was a very common
technique amongst MSMQ developers years ago ( & even today ) as they would
often serialise an ADO recordset to a byte stream, pack it into a MSMQ
message, transmit it somewhere, then de-serialize it at the other end of the
wire. I don't have that code handy right now but can definitely dig it up if
you're looking to unpack older ADO stuff.

SQL Server's TDS protocol is documented to a reasonable extend here:
http://www.freetds.org. How useful this is to you will depend on which
version of SQL Server you're using (which you haven't stated) & also what
you're actually intending to do (eg script something for your own ad-hoc use
or build a toolset that you're planning to sell which requires significantly
more efffort).

The real trick here is to know what protocols you're intending to work with
& target them individually. Trying to build an all-encompassing solution
that covers all client access protocols probably isn't feasible, given the
number & versions of apis available.

I didn't mean to trivialise this when I suggested the idea. Whether this is
worth your while reallyy depends on how badly you need a solution to this.
If you're dealing with your own application, it may well be easier to simply
insert some extra code in your data layer & pluck the results from within
whatever library you're using.

Regards,
Greg Linwood
SQL Server MVP

"z f" <dont@xxxxxxxxxx> wrote in message
news:eI50ahn6FHA.1416@xxxxxxxxxxxxxxxxxxxxxxx
> does the protocol SQL server used is being parsed by ethereal (like HTTP )
> to not show only the binary data?
> is it public like HTTP?
> because if not there is no way to parse the data.
>
> thanks
>
>
>
>
> "Greg Linwood" <g_linwood@xxxxxxxxxxx> wrote in message
> news:%23fysOpi6FHA.2608@xxxxxxxxxxxxxxxxxxxxxxx
>> There's no way to get at the responses with SQL Profiler.
>>
>> The only way I'm aware of to get this information without changing your
>> app is to use a protocol analyser such as Ethereal. Good news is that
>> Ethereal is free & conveniently exports its captures to xml files which
>> are then fairly easy to work with.
>>
>> It wouldn't be too hard to write an xml parser to extract the first 10
>> rows from the output..
>>
>> Regards,
>> Greg Linwood
>> SQL Server MVP
>>
>> "z f" <dont@xxxxxxxxxx> wrote in message
>> news:eg0Uage6FHA.4076@xxxxxxxxxxxxxxxxxxxxxxx
>>> don't laugh,
>>>
>>> is there some utility that enables a request/response style profiling on
>>> SQL server.
>>> this is really needed.
>>>
>>> I mean not only seeing the SQL request like the SQL server profiler
>>> does, but seeing also the response in some way, lets say first 10 rows
>>> etc.
>>>
>>> it can really ease debugging
>>>
>>> if there is no such way but you know how to do this using some profiling
>>> API to SQL server it can also help.
>>>
>>>
>>> TIA.
>>>
>>>
>>>
>>>
>>
>>
>
>


.

Relevant Pages

  • Re: wierd send/recv problem
    ... It really depends on the structure of your protocol. ... all text data is inherently binary data as well. ... size of the body is transmitted with a Content-Length header. ... for send and recv part for handling it ...
    (microsoft.public.win32.programmer.networks)
  • Re: FreeTextTable on image column of document metadata
    ... The only way SQL Server 2000 FT Indexing ... would be able to *read* this binary data, is if the binary data was stored ... this binary data in the "MetaInfo" column was stored as recognized file ... >> If you did not store the readable data into a MS Word document, ...
    (microsoft.public.sqlserver.fulltext)
  • Re: bytes to string conversion
    ... I can connect sql server and retrive the data intoi the DataSet. ... mPASSWQORD field uses binary data type. ... I have to convert this binary data into the string so I can compare it. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: adding Ethernet
    ... >> I just added Ethernet capability to an instrument, ... >> to talk binary data to my embedded uP. ... Xport thing) to my customer two weeks ago, so he could try getting his ... software to talk the protocol to my box. ...
    (sci.electronics.design)
  • RE: Accessing external SQL Server
    ... To allow SBS with ISA to connect to external SQL Server, ... Click New and click Protocol. ... Note the above steps are for SQL 2000 which uses port 1433. ... TCP Ports Needed for Communication to SQL Server Through a Firewall ...
    (microsoft.public.windows.server.sbs)
Loading