Enables or disables a trace flag on a local instance.
dbcc nodetraceon(trace_flag_number) dbcc nodetraceoff(trace_flag_number)
trace_flag_number – is the number of the trace flag you are enabling or disabling.
Enables trace flag 3604:
dbcc nodetraceoff(3604)
DBCC execution completed. If DBCC printed error messages, contact a user with System Administrator (SA) role.
dbcc traceon and dbcc traceoff apply trace flags for the entire cluster, while dbcc nodetraceoff and dbcc nodetraceon apply trace flags locally.
Sets the scope of the dbcc command to the cluster or instance and specifies what the scope is currently set to.
dbcc set_scope_in_cluster("cluster"|"instance"|"scope")
cluster – sets the dbcc command scope to the cluster. Subsequent dbcc commands have a cluster-wide effect.
instance – sets the dbcc command scope to the current instance. Subsequent dbcc commands affect only the local instance.
scope – displays the current scope of the dbcc command, either cluster or instance.
Example 1 Sets the dbcc scope to the cluster:
dbcc set_scope_in_cluster('cluster')
Example 2 Sets the dbcc scope to the instance:
dbcc set_scope_in_cluster('instance')
Example 3 Displays the current scope for dbcc commands:
dbcc set_scope_in_cluster('scope')
Displays the portion of the quorum device related to cluster membership, including the cluster view records that describe the state of the cluster.
dbcc quorum
Displays the contents of the quorum disk for the server:
dbcc quorum
Although you issue dbcc quorum from an instance, the output goes to the:
Terminal that started ASE by default
Client session if trace flag 3604 is on
Client session if trace flag 3605 is on.
dbcc quorum accepts an integer parameter for the number of view records to print. For example this prints the 20 most recent view records:
dbcc quorum(20)
If you do not include a parameter dbcc quorum prints the 10 most recent view records. Pass -1 to print all view records.
Issue dbcc quorum (-1) to view all records.
You must have the sa_role to run dbcc quorum.
