Microsoft SQL Server 2000 Administrators Companion

3 4

The SQL Server: User Settable object contains a set of counters that you can define. You can set these counters from within any SQL statement by calling the system stored procedures sp_user_counter1 through sp_user_counter10 followed by an integer value to set the counter with. You can read these counters through Performance Monitor by viewing the following counter:

• Query Represents the user-settable value. This counter has 10 instances associated with it: User counter 1 through User counter 10. The value displayed is the value that your program or SQL statement has set.