Metamodel

Instance

14. 4. 2023
  • Audit Level

    Audit level. Possible values are none, success, failure, and all. Audits are written to the error log and to the Windows Event Viewer.

  • Audit Level ID

    ID of the Audit Level set in registry. None = 0, Successful Logins Only = 1, Failed Logins Only = 2, Both Failed and Successful Logins = 3

  • Build CLR Version

    Version of the Microsoft.NET Framework common language runtime (CLR) that was used while building the instance of SQL Server.

  • Cluster Name

    Name of the WSFC cluster that hosts the instances of SQL Server that are enabled for Always On availability groups.

  • Cluster Quorum State

    State of the WSFC quorum (one of UNKNOWN_QUORUM_STATE, NORMAL_QUORUM, FORCED_QUORUM)

  • Cluster Quorum Type

    Type of quorum used by this WSFC cluster (one of NODE_MAJORITY, NODE_AND_DISK_MAJORITY, NODE_AND_FILE_SHARE_MAJORITY, NO_MAJORITY:_DISK_ONLY, UNKNOWN_QUORUM, CLOUD_WITNESS.

  • Collation

    Name of the default collation for the server.

  • Collation ID

    ID of the SQL Server collation.

  • Comparison Style

    Windows comparison style of the collation.

  • Computer Name Physical Net BIOS

    NetBIOS name of the local computer on which the instance of SQL Server is currently running.
    For a clustered instance of SQL Server on a failover cluster, this value changes as the instance of SQL Server fails over to other nodes in the failover cluster.
    On a stand-alone instance of SQL Server, this value remains constant and returns the same value as the MachineName property.
    Note: If the instance of SQL Server is in a failover cluster and you want to obtain the name of the failover clustered instance, use the MachineName property.

  • Default Backup Directory
  • Default Data Path

    Name of the default path to the instance data files.

  • Default Log Path

    Name of the default path to the instance log files.

  • Edition

    Installed product edition of the instance of SQL Server. 64-bit versions of the Database Engine append (64-bit) to the version.

  • Edition ID

    EditionID represents the installed product edition of the instance of SQL Server.

  • Engine Edition

    Database Engine edition of the instance of SQL Server installed on the server.

  • Engine Edition ID

    Database Engine edition ID of the instance of SQL Server installed on the server.

  • Error Log File Name

    Active error log file.

  • Error Log File Path

    Error log files path.

  • Error Log Files
  • Filestream Configured Level

    The configured level of FILESTREAM access.

  • Filestream Effective Level

    The effective level of FILESTREAM access. This value can be different than the FilestreamConfiguredLevel if the level has changed and either an instance restart or a computer restart is pending.

  • Filestream Share Name

    The name of the share used by FILESTREAM.

  • Full-Text Service Account

    Account under which the Full-Text Search service is running. This account is authorized to control the service. This account can start or stop the service, or modify service properties.

  • Full-Text Service File Name

    The path and filename of the Full-Text Search executable.

  • Full-Text Service Name

    Name of the Full-Text Search service.

  • Full-Text Service Process Id

    The process ID of the Full-Text Search service.

  • Full-Text Service Startup Type

    The start mode of the Full-Text Search service.

  • Full-Text Service Status

    The current status of the Full-Text Search service.

  • Host Distribution

    Description of the operating system.

  • Host OS Language Version

    Windows locale identifier (LCID) of the operating system.

  • Host Platform

    The type of operating system: Windows or Linux

  • Host Release

    Microsoft Windows operating system release (version number).

  • Host Service Pack Level

    Service pack level of the Windows operating system. For Linux, returns an empty string.

  • Host Sku

    Windows Stock Keeping Unit (SKU) ID.

  • Install ID

    ID of the installation.

  • Instance Name

    Name of the instance to which the user is connected. Returns NULL if the instance name is the default instance.

  • Is Advanced Analytics Installed

    Returns 1 if the Advanced Analytics feature was installed during setup; 0 if Advanced Analytics was not installed.

  • Is Big Data Cluster

    Returns 1 if the instance is SQL Server Big Data Cluster; 0 if not.

  • Is Case Sensitive

    Returns 1 if the default instance collation is case sensitive.

  • Is Clustered

    Server instance is configured in a failover cluster.

  • Is External Authentication Only

    Returns whether Azure AD-only authentication is enabled. Applies to: Azure SQL Database and Azure SQL Managed Instance.

  • Is Fulltext Installed
151
Share: