Connection statistics information includes:
Statistic timestamp – time the statistic was generated.
Start timestamp – time the connection was last started.
Number of operations read since the connection was last started (primary connections only).
Number of active subscriptions (replicate connections only).
To get statistics information about a specific primary database connection, use sp_helpprimaryconn with the stats keyword and specify a database connection:
sp_helpprimaryconn stats, "conn_name"
where conn_name is the connection name in the form ds.db.
To get statistics information about a specific replicate database connection, use sp_helpreplicateconn with the stats keyword and specify a database connection:
sp_helpreplicateconn stats, "conn_name"
where conn_name is the connection name in the form ds.db.
To get statistics information about all primary database connections, use sp_helpprimaryconn with the stats keyword and without specifying a database connection:
sp_helpprimaryconn stats
To get statistics information about all replicate database connections, use sp_helpreplicateconn with the stats keyword and without specifying a database connection:
sp_helpreplicateconn stats
