General system and server information is available on the General page of the Server Properties dialog box. The information on the General page helps you determine the following:
- SQL Server edition
- Operating system version
- SQL Server version
- Platform and chip architecture
- Default language
- Amount of RAM installed on the system
- Number of CPUs
- Root directory location for the selected instance
- Default server collation
You can obtain similar information by using the extended stored procedure xp_msver
. Execute the following command:
exec xp_msver "ProductName", "ProductVersion", "Language", "Platform", "WindowsVersion", "PhysicalMemory", "ProcessorCount"
You also can use SQL Server PowerShell, as shown in the following example:
Invoke-Sqlcmd -Query "exec xp_msver 'ProductName', 'ProductVersion', 'Language', 'Platform', 'WindowsVersion', 'PhysicalMemory', 'ProcessorCount'" -ServerInstance "DataServer91\CorpServices"