In a clustered server, system_view is a session-specific setting that allows you to control the scope of monitoring data that queries return from the monitoring tables, sysprocesses, sp_who, and other commands. When you set system_view to cluster, queries on the monitoring tables return data from all active instances in the cluster. When you set system_view to instance, queries against the monitoring tables return data only for processes or objects that are active on the instance to which the client is connected.
Use the set command to configure the scope of the session:
set system_view {instance | cluster | clear}
where:
instance – returns statistics for only the local instance. Cross-cluster requests are not sent to any other instance in the cluster.
cluster – returns statistics for all instances in the cluster.
clear – returns the system view to the configured default.
If you do not specify an InstanceID when you query a monitoring table or call a monitoring table RPC, the instance uses the current system_view configuration.
The session system view is inherited from its host logical cluster. Select the @@system_view global variable to determine the current system view.