SQL Server 2000: Server Memory / CPU Settings in Query Analyzer

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

+1


source to share


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


Not that I know. You need to look perfmon

.



0


source


Try:

SELECT *
FROM sys.dm_os_sys_info

      

Sorry, only in 2005. In 2000, you can xp_cmdshell

go to an external tool or use a COM object via sp_OA

.

-1


source







All Articles