rs_helpcounter stored procedure examples

The examples for the rs_helpcounter procedure in Replication Server Reference Manual are incorrect. Replace them with the following:

Examples

Example 1 Lists all module names and syntax for using rs_helpcounter to find detailed information:

1> rs_helpcounter
2> go



ModuleName
------------------------------
CM
DIST
DSI
DSIEXEC
REPAGENT
RSI
SQM
SQMR
SQT
STS
SYNC
SYNCELE
(12 rows affected)

rs_helpcounter

How to Use rs_helpcounter

----------------------------------------------------------------

rs_helpcounter [intrusive | sysmon | rate | duration | internal
                | must_sample | no_reset | keep_old | configure]
rs_helpcounter ModuleName [, {type | short | long}]
rs_helpcounter keyword    [, {type | short | long}]

(return status = 0)

Example 2 Displays all of the counters with the SQMR module name:

1> rs_helpcounter sqmr, type
2> go

Display Name                   Module Name  Counter Type  Counter Status
------------------------------ ------------ ------------ --------------
BlocksRead                     SQMR         Total         0000008c
BlocksReadCached               SQMR         Total         0000008c
CmdsRead                       SQMR         Total         0000008c
SleepsStartQR                  SQMR         Total         00000000
SleepsWriteQ                   SQMR         Total         00000004
XNLInterrupted                 SQMR         Total         00000000
XNLPartials                    SQMR         Total         00000000
XNLReads                       SQMR         Total         00000000

(8 rows affected)

Table 2 shows the definitions of the bitmap strings in the Counter Status column. For more information, see the Replication Server Administration Guide.

**Table 2: Status column definitions**
Bitmap string	Datatype	Definition
CNT_INTRUSIVE	int	0x001
CNT_INTERNAL	int	0x002
CNT_SYSMON	int	0x004
CNT_MUST_SAMPLE	int	0x008
CNT_NO_RESET	int	0x010
CNT_DURATION	int	0x020
CNT_RATE	int	0x040
CNT_KEEP_OLD	int	0x080
CNT_CONFIGURE	int	0x100