CIS - network packets

[unknown]

If CIS setup is enabled and if loopback proc executed, do
this(the CIS component) add to the network traffic?

To try to be more clear - will enabling CIS add to or list
under(sysmon's) Total Network I/O Requests in "Network I/O
Management" section -> Total TDS Packets Received.

I would guess, e.g MDA table query, the acutal query being
sent and the resultset would be TDS packets, --> but having
to execute the mda procedure using CIS add any additional
network traffic as opposed to executing a non-CIS proc?

[Jeff Tallman [Sybase]]

Yes - CIS to loopback does add to network....ASE doesn't do anything
special in handling "loopback". However, the network calls won't leave
the TCP layers as most OS's these days recognize it is for the same host.

As far as MDA, that depends - ASE 12.5 or ASE 15.0??? For 12.5, MDA
used CIS when querying MDA tables - you can actually see both SPIDs in
sp_who. For ASE 15, for local querying MDA tables, ASE 15 implemented a
"materialized rpc" mechanism for system rpc's that avoids network calls
from CIS - CIS simply maps the table to the local system RPC. You can,
of course, install MDA tables to point at a remote server via
installmontables, however, in that case CIS would make network calls.

Jeff Tallman
Enterprise Data Management Products Technical Evangelism
***@sybase.com
http://blogs.sybase.com/database

Post by unknown
If CIS setup is enabled and if loopback proc executed, do
this(the CIS component) add to the network traffic?
To try to be more clear - will enabling CIS add to or list
under(sysmon's) Total Network I/O Requests in "Network I/O
Management" section -> Total TDS Packets Received.
I would guess, e.g MDA table query, the acutal query being
sent and the resultset would be TDS packets, --> but having
to execute the mda procedure using CIS add any additional
network traffic as opposed to executing a non-CIS proc?