SQL Server 2000: Is there a way to find out server memory / CPU parameters in Query Analyzer?
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.