Getting statistics information for connections

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 all primary database connections

Use sp_helpprimaryconn with the stats keyword, without specifying a database connection:
```
sp_helpprimaryconn stats
```

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 replicate database connections

Use sp_helpreplicateconn with the stats keyword, without specifying a database connection:
```
sp_helpreplicateconn stats
```