'data management view' Tag

• SQL Server Lock Listesi

  August 15, 2010

  Eğer SQL Server ınızda o anda var anda var olan lock ların listesini almak isterseniz. Aşağıdaki ufak script den faydalanabilirsiniz. SELECT resource_type, resource_subtype, resource_description, resource_associated_entity_id, request_mode, request_status, request_lifetime FROM sys.dm_tran_locks

  posted in SQL Server, T-SQL by sedat.salman

• Current Users, Session Counts & Authentication Type
  SQL Server da ki Kullanıcılar, Session Sayıları ve de Kimlik Doğrulama Türü

  June 2, 2010

  select ‘Authentication Method’=( case when nt_user_name is not null then ‘Windows Authentication’ else ‘SQL Authentication’ end), login_name as ‘Login Name’, ISNULL(nt_user_name,’-') as ‘Windows Login Name’, COUNT(session_id) as ‘Session Count’ from sys.dm_exec_sessions group by login_name,nt_user_name

  posted in SQL Server, SQL Server Administration / Yönetim, T-SQL by sedat.salman