SELECT SERVERPROPERTY ('servername') as Servername, name, [value], [value_in_use]
FROM [sys].[configurations]
WHERE [name] like '%memory%' or name like '%ad hoc%' or name like '%cpu%'
GO
select
scheduler_id,cpu_id,
status,
is_online from sys.dm_os_schedulers
where status='VISIBLE ONLINE'
No comments:
Post a Comment