SQL Server 2000: Server memory / CPU parameters in Query Analyzer

Question

SQL Server 2000: Is there a way to find out server memory / CPU parameters in Query Analyzer?

Answer 1

not that i know of. you'll have to look in perfmon.

Answer 2

Try:

SELECT *
FROM sys.dm_os_sys_info

Sorry, that's 2005 only. In 2000, you can xp_cmdshell out to an external tool or use a COM object through sp_OA.

Answer 3

select * from sysperfinfo

it has everything in there that perfmon has. plus make sure you check out all the sql configuration parameters by running sp_configure. also running xp_msver shows a bunch more info about the sql server instance.

between those three i don't know what else you'd want to know.