rs_helpcounter

Description

Displays information about counters.

Syntax

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

Parameters

intrusive: Displays information about counters that affect server performance.

sysmon: Displays information about counters reported by the admin statistics, sysmon command.

rate: Displays information about counters that measure rate. Rate is the sampling total divided by dSTATS sleep time or elapsed time since last dSTATS sleep. Rate is measured per second.

duration: Displays information about counters that measure duration. Time intervals are measured in one-hundedths of a second.

internal: Displays information about counters used by Replication and by other counters.

must_sample: Displays information about counters that must keep sampling even if sampling is not enabled.

no_reset: Displays information about counters that are not reset after initialization. Used for internal counters.

keep_old: Displays information about counters that keep both current and previous values.

configure: Displays information about counters that keep the run value of a Replication Server configuration parameter.

module_name: The name of a module: dsi, dsiexec, sqt, cm, dist, rsi, sqm, or repagent.

type: Tells Replication Server to print the display name, module name, counter type, and counter status of the counters specified.

short: Tells Replication Server to print the display names, module names, and counter descriptions of counters specified.

long: Tells REplication Server to print values for every column in the rs_statcounters table.

keyword: Search keyword.

Examples

Example 1

Lists all module names and syntax for using sp_helpcounter to find detailed information.

sp_helpcounters

ModuleName
---------------------
CM
DIST
DSI
DSIEXEC
REPAGENT
RSI
SQM
SQT
STS
How to Use rs_helpcounter
---------------------------------------------------
rs_helpcounter [intrusive | sysmon | rate 
	| duration |interal | must_sample | no_reset 
	| contigure]
rs_helpcounter ModuleName [, {type | short | long }]
rs_helpcounter keyword [, {type | short | long }]

Usage

rs_helpcounter allows users to search the rs_statcounters system table.
When used with no parameters, rs_helpcounter prints out a list of modules and syntax to find more detailed information.

Permissions

Any user can execute this command.