SQL Server 2000: Server Memory / CPU Settings in Query Analyzer
3 answers
select * from sysperfinfo
it has everything perfmon has. plus make sure you check all sql config options by running sp_configure. also works xp_msver shows a bunch of more information about the sql server instance.
between these three I don't know what else you would like to know.
+2
source to share