SQL Server를 통해 성능카운터 / sys.dm_os_performance_counters 읽기 SQL Server내에서 SQL Server 관련 Perfmon Counter를 읽을 수 있는 카운터인 sys.dm_os_performance_counters 읽기 WITH CTE AS(SELECTROW_NUMBER() OVER (ORDER BY object_name,instance_name,counter_name) AS RN,RTRIM(object_name)AS object_name,RTRIM(counter_name)AS counter_name,RTRIM(instance_name)AS instance_name,cntr_value,cntr_type,CASE cntr_type WHEN 65792THEN '절대값 | Absolute Meaning' WHEN 65536THEN '절대값 | Absolute Me.. 더보기 Impersonate 되어있는 Login의 Grantor와 Grantee 찾기 Impersonate 되어있는 Login의 Grantor와 Grantee 찾기 /*Search a Grant Impersonate to login*//*2014-10-28 Taewwok Cha*/SELECTSP.grantor_principal_idAS GrantorPrincipalId,SPR.nameAS GrantorLoginName,SP.grantee_principal_idAS GranteePrincipalId,SPR2.nameAS GranteeLoginName,SP.class_descAS PrincipalClassName,SP.typeAS PermissionType,SP.permission_nameAS PermissionName,CASEWHEN sp.state='D' THEN 'D = DENY'WHE.. 더보기 SQL Server 2012 시스템뷰 ERD SQL Server 2012 System View Map (ERD) http://www.microsoft.com/en-us/download/details.aspx?id=39083 더보기 이전 1 ··· 4 5 6 7 8 9 10 ··· 12 다음