Edit

Server Properties (General page)

Applies to: SQL Server

Use this page to view read-only information about your SQL Server installation.

Property grid

View properties for the selected server, such as the server name, server operating system, or number of processors.

Name

Displays the name of the server instance.

Product

Displays the edition of SQL Server currently running.

Operating System

Displays the Windows operating system currently running.

Platform

Describes the operating system and hardware running SQL Server.

Version

Displays the version number of the SQL Server edition currently running.

Language

Displays the language supported by the running instance of SQL Server.

Memory

Lists the amount of RAM installed on the server.

Processors

Displays the number of CPUs installed.

Root Directory

Displays the path to the location of the SQL Server instance, typically C:\Program Files\Microsoft SQL Server\.

Server Collation

Displays the collation supported by the server. A collation specifies the particular code page and sort order to use for Unicode and non-Unicode data.

Is Clustered

Displays True if the server instance is configured in a SQL Server failover cluster or False if the server instance isn't clustered.

Is HADR Enabled

Displays True if the Always On availability groups feature is enabled or False if the Always On availability groups feature is disabled. For information about enabling or disabling Always On availability groups, see Enable or disable Always On availability group feature.

Description Field

View additional information on the server properties.