| Breck Carter [TeamSybase] 2005-06-19, 8:23 pm |
| Please implement some mechanism for recording and/or accumulating some
real-time performance counters for short-lived connections such as
those created by web services and events.
These connections can be started and stopped at a furious rate,
especially for heavily-used web services, and an online monitoring
process that occasionally records samples of current connection
performance counters may (or will) miss most of these connections.
The same can be true for event connections, and sometimes even
ordinary user connections that are started and stopped quickly... but
it's web services and events that are a special concern.
If each event and web service was treated as a "single connection" as
far as continuously available performance counters (similar to those
returned by sa_conn_info and CONNECTION_PROPERTY)
are concerned, that
would be OK with me; e.g. the current cumulative counters for service
X are of more interest than a history of the individual details for
each of the last ten thousand connections created and dropped for
service X.
Of course, individual current connections should continue to show up
in sa_conn_info, etc... e.g., if a web service blocks or is blocked or
starts sucking up temp file space, we gotta know that :)
Breck
--
SQL Anywhere Studio 9 Developer's Guide
Buy the book: http://www.amazon.com/exec/obidos/A...7/risingroad-20
bcarter@risingroad.com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com
|