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