Server Properties (General Page) - SQL Server Management Studio

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 Microsoft 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.

Description Field

View additional information on the server properties.

See Also

Concepts