select
db_name (resource_database_id) as DatabaseName
,count (*) as TotalSessions
from sys.dm_tran_locks
where resource_type = 'DATABASE'
group by db_name (resource_database_id)
order by db_name (resource_database_id)
asp.net,c#.net, MVC, WPF, WCF, JavaScript, JQuery, SQL Server, Interview Q&A
select
db_name (resource_database_id) as DatabaseName
,count (*) as TotalSessions
from sys.dm_tran_locks
where resource_type = 'DATABASE'
group by db_name (resource_database_id)
order by db_name (resource_database_id)