Wednesday, June 22, 2016

Most Blocking DB

select db_name(dbid), count(dbid) as processes ,sum(cpu) as usage from
sysprocesses where blocked != 0 group by dbid order by usage desc

No comments:

Post a Comment