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: