Tip: Determine System and Server Information on SQL Server 2008
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"