This is the equivalent of running sp_configure, or selecting from sys.configurations, except that it also compares values with defaults and warns if they have been changed.
|What It Shows||Comments|
|Value||Currently configured value|
|Value In Use||Value is only used if RECONFIGURE has been run after it was changed|
|Comments||Warns if this is a non-default value, or if Value and Value In Use are different|