معلومات عامة عن العمليات بالسيرفر حاليا
select
spid,
loginame = rtrim(loginame),
database_name = db_name(dbid),
status = status,
program_name = rtrim(program_name),
mem_bytes = memusage * 8,
cpu,
physical_io,
blocked ,
command = cmd,
login_time,
last_batch,
hostprocess,
net_address
from
master..sysprocesses
where loginame <> 'sa'
order by
login_time desc ,1
الذاكرة المحجوزة بالسيرفر الان
select sum(memusage * as 'Memory in use'
from
master..sysprocesses
زمن المعالجة المستهلك الان
select sum(cpu) as 'CPU in use'
from
master..sysprocesses
الاجهزة المتصلة بالسيرفر الان
select Distinct net_address as 'PC Connected Now'
from
master..sysprocesses
where len(net_address) > 5
نوع الاوامر المنفذه على السيرفر
select loginame, cmd as 'Command Status Now',net_address as 'Pc'
from
master..sysprocesses
where cmd = 'SELECT' or cmd = 'AWAITING COMMAND'

حالة الاوامر المنفذه على السيرفر

select status as 'Status Now',net_address as 'Pc'
from
master..sysprocesses
where status = 'runnable'