Share via

  • Article

Server Properties (General Page) - SQL Server Management Studio

Use this page to view read-only information about your Microsoft 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 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.