How to find SQL Server machine configration

I have SQL Server client installed on my machine, through which I connect to SQL Server A. Is there any way, in which I can find out the configration of the machine on which SQL Server A is installed. I am interested in finding out the number of processors and the amount of RAM.

If you're using SQL Server 2005 and have sysadmin privileges or more specifically the VIEW_SERVER_STATE permission you can run the following command:

SELECT * FROM sys.dm_os_sys_info

You can see [cpu_count] and [hyperthread_ratio] as well as [physical_memory_in_bytes]

For more information, please check out the Books Online documentation: http://msdn2.microsoft.com/en-us/library/ms175048.aspx.

Paul A. Mestemaker II
Program Manager
Microsoft SQL Server Manageability
http://blogs.msdn.com/sqlrem/

|||

Hi Paul,

Thanks for the info.

But I am currently trying to find the machine config of SQL Server 2000. Is there a equivalent query for that. Sorry I didn't specify the SQL Server version in the previous post.

|||

You should upgrade :-P

For SQL Server 2000, I'm not sure. Have you tried EXEC xp_msver?

Paul A. Mestemaker II
Program Manager
Microsoft SQL Server Manageability
http://blogs.msdn.com/sqlrem/

|||

EXEC xp_msver gives me the processor count and the processor type.

I think I can go ahead from there. Thanks