set system_view allows you to determine the system view for a session, and controls the materialization of fake tables, such as sysprocesses and syslocks, which impact the output of stored procedures such as sp_who. The syntax is:
set system_view { instance | cluster | clear }
instance – sets the system view for the current instance.
cluster – sets the system view for the cluster.
clear – clears any session level setting, reverting to the system_view setting for the logical cluster hosting that spid. For example, enter select @@system_view to check the current value.
