Share via


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.

See Also

Other Resources

Setting Server Configuration Options

Help and Information

Getting SQL Server 2005 Assistance