Tip: Determine System and Server Information on SQL Server 2008

Follow Our Daily Tips

Twitter | Blog | RSS | Facebook

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"

From the Microsoft Press book Microsoft SQL Server 2008 Administrator’s Pocket Consultant,Second Edition by William R. Stanek.

Looking for More Tips?

For more tips onusing Microsoft products and technologies, visit the TechNet Magazine Tips library.