The Provide Custom SQL Script window of the Add Custom Counter wizard allows you to enter or paste a T-SQL script for your custom counter. For more information about T-SQL scripts, see .
Refer to the following tips when using custom SQL Scripts:
go
command is not a Transact-SQL statement and you cannot use this command in custom SQL batches. The go command is a batch separator for Management Studio, Query Analyzer, sqlcmd, and osql.set transaction isolation level read uncommitted
set lock_timeout 20000
set implicit_transactions off
set language us_english
set cursor_close_on_commit off
set query_governor_cost_limit 0
set numeric_roundabort off
You can open the Add Custom Counter wizard by clicking Administration > Custom Counters, and then clicking Add in the Custom Counters view.
SQL Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > >
|