728x90

@echo off

 

 set/p host=host Address: 

 set logfile=Log_%host%.log

 

 echo Target Host = %host% >%logfile%

 for /f "tokens=*" %%A in ('ping %host% -n 1 ') do (echo %%A>>%logfile% && GOTO Ping)

 :Ping

 for /f "tokens=* skip=2" %%A in ('ping %host% -n 1 ') do (

     echo %date% %time:~0,2%:%time:~3,2%:%time:~6,2% %%A>>%logfile%

     echo %date% %time:~0,2%:%time:~3,2%:%time:~6,2% %%A

     timeout 1 >NUL 

     GOTO Ping)

 

728x90
728x90

use rtcdyn

 

-- 모임 참석자 리스트 쿼리
select FE.Fqdn, P.ConfId, P.UserAtHost, RC.ProvisionTime, P.JoinTime, RC.ExpiryTime from Participant P with(nolock)
Join ParticipantSignalingSession PS with(nolock) ON PS.ConfId = P.ConfId and P.PartId = PS.PartId
Join [rtc].[dbo].[Conference] RC with(nolock) ON RC.ConfId = P.ConfId
Join FrontEnd FE with(nolock) ON FE.FrontEndId = PS.FrontEndId
Order by RC.ProvisionTime, P.ConfId, FE.Fqdn

-- 모임 F/E서버 및 모임방ID별 참석자 수
select FE.Fqdn, P.ConfId, Count(*) as Join_Cnt, RC.ExpiryTime from Participant P with(nolock)
Join ParticipantSignalingSession PS with(nolock) ON PS.ConfId = P.ConfId and P.PartId = PS.PartId
Join [rtc].[dbo].[Conference] RC with(nolock) ON RC.ConfId = P.ConfId
Join FrontEnd FE with(nolock) ON FE.FrontEndId = PS.FrontEndId
Group By FE.Fqdn, P.ConfId, RC.ExpiryTime

 


select
--ActiveConference
[ActiveConference].[ConfId]
,[Title]
,[LastEnterprisePartLeaveTime]
,'|' as '|'
--ActiveMCU
,[LastActivityTime] MCULastActivityTime
,'|' as '|'
--Conference
,[ProvisionTime]
,[ExpiryTime]
,[LastUpdateTime]
,[LastActivateTime]
,'|' as '|'
--Participant
,[UserAtHost]
,[EnterpriseId]
,[Privilege]
,[JoinTime]
FROM [rtcdyn].[dbo].[ActiveConference]
left outer join [rtcdyn].[dbo].[Participant]
on [Participant].ConfId = [ActiveConference].ConfId
left outer join [rtcdyn].[dbo].[ActiveMcu]
on ActiveMcu.ConfId = ActiveConference.ConfId
and UserAtHost not like 'CAS%'
and MediaId = 4
left outer join [rtc].[dbo].[Conference]
on Conference.ConfId = ActiveConference.ConfId

--where ActiveConference.ConfId in (select ConfId from [rtcdyn].[dbo].[Participant] where UserAtHost like '%dgardiner.test%') --Name of the application/OwnerURI scheduling the conference

 

728x90
728x90

특정단어찾기


[파일명찾기. 제목찾기]


특정 문자열이 존재하는 행 찾기
dir /s /b | find /i "원하는문자열입력"
-> C:\Users\TY\Desktop\log>dir /s /b | find /i "원하는문자열입력" C:\Users\TY\Desktop\log\원하는문자열입력.txt

dir /s /b | find /i "원하는문자열입력"
-> 해당사항없음

dir /s | find "원하는문자열입력"
-> C:\Users\TY\Desktop\log>dir /s | find "원하는문자열입력"
2019-05-20 오전 11:03 3 원하는문자열입력.txt

dir /s | find "원하는문자열입력"
-> 해당사항없음

 



[파일내용찾기. 원하는문자열찾기]


findstr /s "원하는문자열입력" *.txt
-> C:\Users\mani4u\log>findstr /s "원하는문자열입력" *.txt
a\zzz.txt:123

findstr /s "원하는문자열입력" *.*
-> /s가 하위경로까지 찾으므로 매우많이나옴. 특정 경로에 들어가서 입력 시 조금 나음
findstr "원하는문자열입력" *.*

findstr /n "원하는문자열입력" *mobile.log*
-> /n을 붙이면 라인수가 같이 표기됨
mobile.log:874736:DEBUG|2019-06-11,14:41:41.973|mobile|원하는문자열입력|어쩌구저쩌구

ex)
findstr /s "원하는문자열입력" frameplus.log
findstr /n "원하는문자열입력" *mobile.log*

findstr /s "원하는문자열입력" *.xml

728x90
728x90

wmic process get caption, creationdate | findstr 프로세스명

 

wmic process get caption, creationdate | findstr excel.exe

excel.exe 20200206073039.779888+540

 

728x90
728x90

SQL Server 2014: 실습9 SELECT, FROM, WHERE, BETWEEN, AND, IN, LIKE, ANY, ALL 등

–앞으로 사용할 DB 생성–

 

sqlDB 데이터베이스 생성

 

–사용할 테이블 생성–

테이블 userTbl, buyTbl 작성

–데이터 입력–

데이터 입력.

userTbl 정보

buyTbl 정보

–DB 백업–

USE tempdb;
BACKUP DATABASE sqlDB TO DISK=’D:\DB_Backup\sqlDB2016.bak’ WITH INIT;

참고로 백업 및 복원은 https://archmond.net/?p=7083 에서 알아봤음.

–기본 WHERE 절–

WHERE절은 조회 시 조건을 줄 수 있다.

USE sqlDB;
SELECT * FROM userTbl WHERE name=’김경호’;

김경호 사용자만 추출

SELECT * FROM userTbl WHERE birthYear >= 1970 AND height >= 182;

1970년 이후 출생, 182cm 이상인 사람

SELECT userID, name FROM userTbl WHERE birthYear >= 1970 OR height >= 182;

1970년 이후 출생 or(또는) 182cm 이상인 사람은 7명

–BETWEEN, AND 사용–

SELECT userID, name FROM userTbl WHERE height >= 180 AND height <= 183;

키가 180에서 183cm인 사람 찾기

SELECT userID, name FROM userTbl WHERE height BETWEEN 180 AND 183;

동일한 값을 찾기 위해 BETWEEN A AND B를 사용함.

–IN 사용–

SELECT userID, name FROM userTbl WHERE addr=’경남’ OR addr=’전남’ OR addr=’경북’;

지역이 경남, 전남, 경북인 사람 찾기

–LIKE–

SELECT name, height FROM userTbl WHERE name LIKE ‘김%’;

성이 김씨인 사람 찾기

SELECT name, height FROM userTbl WHERE name LIKE ‘_종신’;

앞 한 글자 + 종신 이라는 이름을 가진 사람 찾기. %는 무엇이든. _는 한 글자. 도서에 의하면 검색 문자열의 앞에 _나 %가 들어가면 SQL Server 성능에 나쁜 영향을 끼칠 수 있다고 함.(name 열의 인덱스가 있어도 전체 데이터를 검색한다고 함)

–서브쿼리(SubQuery, 하위쿼리)–

쿼리문 속에 또다시 쿼리문이 있는 서브쿼리.

먼저 김경호의 키는 177이다.

SELECT name, height FROM userTbl WHERE height > (SELECT height FROM userTbl WHERE name=’김경호’);

김경호보다 키가 큰 사람 출력.

김경호가 177cm이므로 방금 전 쿼리와 동일한 결과가 나옴.

–ANY구문–

SELECT name, height FROM userTbl WHERE height >= (SELECT height FROM userTbl WHERE addr=’경남’);

지역이 경남인 사람보다 키가 크거나 같은 사람을 찾기. 오류가 난다. 하위 쿼리가 값을 둘 이상 반환했다고 알려줌.

서브쿼리가 173, 170 이렇게 두 개의 값을 반환하기 때문.

SELECT name, height FROM userTbl WHERE height >= ANY (SELECT height FROM userTbl WHERE addr=’경남’);

>= 연산자 뒤에 ANY를 넣는 것으로 170, 173cm보다 큰…(결국 170보다 큰) 사람을 반환함

–ALL구문–

이번엔 ALL을 써보자. 7명만 출력됨. 170보다 크거나 같을 뿐 아니라, 173보다도 크거나 같아야 한다 -> 결국 173보다 크거나 같은 사람만 반환.

–ANY 구문–

SELECT name, height FROM userTbl WHERE height = ANY (SELECT height FROM userTbl WHERE addr=’경남’);

170이거나 173cm인 사람을 출력.

–IN 구문–

SELECT name, height FROM userTbl WHERE height IN (SELECT height FROM userTbl WHERE addr=’경남’);

=ANY와 IN은 같은 의미.

 

 

참고 사이트

https://archmond.net/?p=7181

728x90
728x90

1. Command 창을 띄웁니다.

2. wmic 입력

3. "memorychip"  또는 "wmic memorychip" 입력

아래와 같이 나옵니다.

Attributes BankLabel Capacity Caption ConfiguredClockSpeed ConfiguredVoltage CreationClassName DataWidth Description DeviceLocator FormFactor HotSwappable InstallDate InterleaveDataDepth InterleavePosition Manufacturer MaxVoltage MemoryType MinVoltage Model Name OtherIdentifyingInfo PartNumber PositionInRow PoweredOn Removable Replaceable SerialNumber SKU SMBIOSMemoryType Speed Status Tag TotalWidth TypeDetail Version
1 BANK 0 8589934592 실제 메모리 2400 1200 Win32_PhysicalMemory 64 실제 메모리 ChannelA-DIMM0 12 Samsung 0 0 0 실제 메모리 M471A1K43BB1-CTD 00000000 26 2667 Physical Memory 0 64 128
1 BANK 2 8589934592 실제 메모리 2400 1200 Win32_PhysicalMemory 64 실제 메모리 ChannelB-DIMM0 12 Samsung

 

윗 방법이 귀찮을 경우

1. Command 창을 띄움니다.

2. "wmic memorychip get capacity" 입력

아래와 같이 나옵니다.
Capacity
8589934592
8589934592

 

감사합니다.

728x90
728x90

lync_monitor Supported Performance Counters

Last Updated ‎September 3, 2019

This article describes the supported performance counters of the Microsoft Lync Server Monitoring (lync_monitor) probe.

nmp

This article describes the supported performance counters of the Microsoft Lync Server Monitoring (lync_monitor) probe.

Contents

Supported Performance Counters for 2010

Following is a list of supported performance counters grouped under various Microsoft Lync Server functions:

  • All Servers

  • Front End Servers

  • Edge Server

  • Back End Server

  • Mediation Server

  • A/V Conferencing Server

 

All Servers

 

 

 

Profile Name

Object

Performance Counter

SIP - Load Management : Average Holding Time For Incoming Messages

LS:SIP - 07 - Load Management

SIP - 000 - Average Holding Time For Incoming Messages

SIP - Peers : Average Outgoing Queue Delay

LS:SIP - 01 - Peers

 

SIP - 020 - Average Outgoing Queue Delay

USrv - Https Transport : Number of failed connects attempts / Sec

LS:USrv - 21 - Https Transport

USrv - 003 - Number of failed connection attempts / Sec

Front End Servers

The performance counters are further categorized in the following listed categories:

  • Lync Server Modalities

  • Individual Processes

  • SIP/IMMCU/Database Store

 

Lync Server Modalities

 

 

 

Profile Name

Object

Performance Counter

RGS - Response Group Service Hosting: Duration of the call in milliseconds

LS : RGS- Response Group Service Hosting

RGS - Duration of call in milliseconds

RGS - Response Group Service Workflow : Attempts to open a connection to Match Making

LS:RGS- Response Group Service Workflow

RGS - Attempts to open a connection to Match Making

CPS - Call Park Service Hosting : Number of the Orbit Request failures

LS:CPS - Call Park Service Hosting

CPS - Number of the Orbit Request failures

CPS - Call Park Service Planning : Current parked calls

LS : CPS - Call Park Service Planning

CPS: Current Parked Calls

Individual Processes

 

 

 

Profile Name

Object

Performance Counter

Instance

Process: % processor time

Process

% Processor Time

_Total

Process: (ASMCUSvc) % Processor time

Process

% Processor Time

ASMCUSvc

Process: (IMMCUSvc) % Processor time

Process

% Processor Time

IMMCUSvc

Process: (MediationServerSvc) % Processor time

Process

% Processor Time

MediationServerSvc

Process: (OcsAppServerHost#1) % Processor time

Process

% Processor Time

OcsAppServerHost#1

Process: (OcsAppServerHost#2) % Processor time

Process

% Processor Time

OcsAppServerHost#2

Process: (OcsAppServerHost#3) % Processor time

Process

% Processor Time

OcsAppServerHost#3

Process: (OcsAppServerHost#4) % Processor time

Process

% Processor Time

OcsAppServerHost#4

Process: (RtcHost) % Processor time

Process

% Processor Time

RtcHost

Process: (RTCSrv) % Processor time

Process

% Processor Time

RTCSrv

SIP/IMMCU/Database Store Performance Counters

 

 

 

Profile Name

Object

Performance Counter

Instance

USrv - DB Store : Queue Latency (msec)

LS:USrv - 01 - DBStore

USrv - 002 - Queue Latency (msec)

 

USrv - DBStore: Sproc Latency (msec)

LS:USrv - 01 - DB Store

USrv - 004 - Sproc Latency (msec)

 

USrv - DB Store : Throttled requests/sec

LS:USrv - 01 - DBStore

USrv - 020 - Throttled requests/sec

 

USrv - Endpoint Cache : Active registered endpoints

LS:USrv -13 - Endpoint Cache

USrv - 001 - Active Registered Endpoints

 

SIP - Load Management : Average Holding Time For Incoming Messages

LS:SIP - 07 - Load Management

SIP - 000 - Average Holding Time For Incoming Messages

 

SIP - Load Management : Incoming Messages Held Above High Watermark

LS:SIP - 07 - Load Management

SIP - 004 - Incoming Messages Held Above High Watermark

 

SIP - Load Management : Incoming Messages Held Above High Overload Watermark

LS:SIP - 07 - Load Management

SIP - 005 - Incoming Messages Held Above High Overload Watermark

 

SIP - Load Management : Incoming Messages Timed Out

LS:SIP - 07 - Load Management

SIP - 006 - Incoming Messages Timed Out

 

SIP - Responses : Local 500 Responses/sec

LS:SIP - 04 - Responses

SIP - 053 - Local 500 Responses/sec

 

SIP - Responses : Local 503 Responses/sec

LS:SIP - 04 - Responses

SIP - 055 - Local 503 Responses/sec

 

SIP - Responses : Local 504 Responses/sec

LS:SIP - 04 - Responses

SIP - 057 - Local 504 Responses/sec

 

SIP - Peers : Sends Outstanding

LS:SIP - 01 - Peers

SIP - 017 - Sends Outstanding

_Total

ImMcu - MCU Health and Performance : MCU Health State

LS:ImMcu - 02 - MCU Health and Performance

IMMCU - 005 - MCU Health State

 

USrv - Conference Focus Factory : Add Conference requests succeeded

LS:USrv - 23 - Conference Focus Factory

USrv - 012 - Add Conference requests succeeded

 

USrv - Conference Control : Local C3P failure responses

LS: USrv - 24 - Conference Control

USrv - 018 - Local C3P failure responses

 

USrv - Conference Mcu Allocator : Factory Unreachable failures

LS:Usrv - 26 - Conference Mcu Allocator

USrv - 009 - Factory Unreachable Failures

 

USrv - Conference Mcu Allocator : Factory Calls Timed-Out

LS:USrv - 26 - Conference Mcu Allocator

USrv - 010 - Factory Calls Timed-Out

 

USrv - Conference Mcu Allocator : Create Conference Mcu Unreachable Failures

LS:USrv - 26 - Conference Mcu Allocator

USrv - 016 - Create Conference Mcu Unreachable Failures

 

MSSQL$RTC:Buffer Manager : Page life expectancy

MSSQL$RTC:Buffer Manager

Page life expectancy

 

USrv - Conference Mcu Allocator : Create Conference Requests Timed-out

LS:USrv - 26 - Conference Mcu Allocator

USrv - 017 - Create Conference Requests Timed-Out

 

DATAMCU - DATAMCU Conferences : Number of Data MCU users in any role

LS:DATAMCU - 00 - Data MCU Conferences

DATAMCU - 025 - Number of Data MCU users in any role

 

DATAMCU - MCU Health and Performance : MCU Health State

LS:DATAMCU - 04 - MCU Health And Performance

DATAMCU - 005 - MCU Health State

 

DATAMCU - MCU Health and Performance : MCU Draining State

LS:DATAMCU - 04 - MCU Health And Performance

DATAMCU - 006 - MCU Draining State

 

AsMcu - CCCP Processing : CCCP Messages Retried/sec

LS:AsMcu - 02 - CCCP Processing

AsMCU - 017 - CCCP Messages Retried/sec

 

AsMcu - CCCP Processing : Current CCCP Message Queue Size

LS:AsMcu - 02 - CCCP Processing

ASMCU - 019 - Current CCCP Message Queue Size

 

AsMcu - CCCP Processing : Number of add user requests failed

LS:AVMCU - 03 - CCCP Processing

AVMCU - 030 - Number of add user requests failed

 

Edge Server

The performance counters of the edge server are classified as follows:

  • Access Edge SIP Component

  • Http Relay

 

Access Edge SIP Component

 

 

 

Profile Name

Object

Performance Counter

Instance

SIP - Access Edge Server : External Messages/sec With Internally Supported Domain

LS:SIP - 09 - Access Edge Server Messages

SIP - 001 - External Messages/sec With Internally Supported Domain

 

SIP - Access Edge Server : External Messages/sec Received With a Configured Allowed Domain

LS:SIP - 09 - Access Edge Server Messages

SIP - 009 - External Messages/sec Received With a Configured Allowed Domain

 

SIP - Access Edge Server Messages - External Messages/sec Received With Allowed Partner Server Domain

LS:SIP - 09 - Access Edge Server Messages

SIP - 003 - External Messages/sec Received With Allowed Partner Server Domain

 

HTTP Relay

 

 

 

Profile Name

Object

Performance Counter

WebRelay - Reach Web relay Server : Active Sip Connection

LS:WebRelay - 00 - Reach Web Relay Server

WEBRELAY - 000 - Active Sip Connections

Backend Server

 

 

 

Profile Name

Object

Performance Counter

Instance

Memory: % Committed Bytes In Use

Memory

Committed Bytes

 

Memory: Available Mbytes

Memory

Available MBytes

 

Memory: Cached Bytes Peak

Memory

Cache Bytes Peak

 

Network Interface: Bytes Total/sec

Network Interface

Bytes Total/sec

Select the NIC card installed on the lync server

Physical Disk: Avg. Disk Queue Length

Physical Disk

Avg. Disk Queue Length

_Total

Physical Disk : Avg. Disk sec/Read

Physical Disk

Avg. Disk sec/Read

_Total

Physical Disk : Avg. Disk sec/Write

Physical Disk

Avg. Disk sec/Write

_Total

Process: % processor time

Process

% Processor Time

_Total

Process: % privilege Time

Process

% Privilege Time

_Total

Process: % Private Bytes

Process

Private Bytes

_Total

Process: % Virtual Bytes

Process

Virtual Bytes

_Total

Processor Information: % Processor Time

Processor Information

% Processor Time

_Total

Processor Information: % Interrupt Time

Processor Information

% Interrupt Time

_Total

MSSQL$RTC:Databases (rtc) : Active Transactions

MSSQL$RTC:Databases

Active Transactions

rtc

MSSQL$RTC:Databases (rtcdyn) : Active Transactions

MSSQL$RTC:Databases

Active Transactions

rtcdyn

MSSQL$RTC:Databases (tempdb) : Active Transactions

MSSQL$RTC:Databases

Active Transactions

tempdb

Mediation Server

 

 

 

Profile Name

Object

Performance Counter

Instance

MediationServer - Global Per Gateway Counters : Total failed calls caused by unexpected interaction from a gateway

LS:MediationServer - Global Per Gateway Counters

Total failed calls caused by unexpected interaction from a gateway

_Total

Audio/Video Conferencing Server

 

 

 

Profile Name

Object

Performance Counter

USrv - Conference Control Notification : Incoming Get Conference requests

LS:USrv - Conference Control Notification

USrv - Incoming Get Conference requests

USrv - Conference Focus Base : ACKs received

LS:USrv - Conference Focus Base

USrv - ACKs received

Performance Baselines

 

 

 

Profile Name

Object

Performance Counter

Instance

MSSQL$RTC - Database Mirroring : Bytes Received/sec

MSSQL$RTC:Database Mirroring

Bytes Received/sec

 

MSSQL$RTC - Database Replica : File Bytes Received/sec

MSSQL$RTC:Database Replica

File Bytes Received/sec

_Total

MSSQL$RTCLOCAL - Database Mirroring : Bytes Received/sec

MSSQL$RTCLOCAL:Database Mirroring

Bytes Received/sec

 

MSSQL$RTCLOCAL - Database Replica : File Bytes Received/sec

MSSQL$RTC:Database Replica

File Bytes Received/sec

_Total

MSSQL$LYNCLOCAL - Database Mirroring : Bytes Received/sec

MSSQL$LYNCLOCAL:Database Mirroring

Bytes Received/sec

 

MSSQL$LYNCLOCAL - Database Replica : File Bytes Received/sec

MSSQL$LYNCLOCAL:Database Replica

File Bytes Received/sec

_Total

WEB - Location Information Service : Average processing time for a successful Get Locations In City request in milliseconds

LS:WEB - Location Information Service

WEB - Average processing time for a successful Get Locations In City request in milliseconds

 

USrv - Authorize delegate sproc : Number of calls

LS:USrv - Authorize delegate sproc

USrv - Number of calls

 

PDP - Core - Video : Active BW Reservations

LS:PDP - Core - Video

PDP - Active BW Reservations

 

DATACOLLECTION - Exchange Archiving Adaptor : No Task Finish in Expected Time

LS:DATACOLLECTION - Exchange Archiving Adaptor

UDC - No Task Finish in Expected Time

 

DATACOLLECTION - SQL Archiving Adaptor : Number of conference activities dropped

LS:DATACOLLECTION - SQL Archiving Adaptor

UDC - Number of conference activities dropped

 

Supported Performance Counters for 2013

This section contains performance counters for Lync Server 2013.

 

 

 

Profile Name

Object

Performance Counter

Instance

RGS - Response Group Service Hosting : Duration of the call in milliseconds

LS:RGS - Response Group Service Hosting

RGS - Duration of the call in milliseconds

 

RGS - Response Group Service Workflow : Attempts to open a connection to Match Making

LS:RGS - Response Group Service Workflow

RGS - Attempts to open a connection to Match Making

 

CPS - Call Park Service Hosting : Number of the Orbit request failures

LS:CPS - Call Park Service Hosting

CPS - Number of the Orbit request failures

 

CPS - Call Park Service Planning : Current parked calls

LS:CPS - Call Park Service Planning

CPS - Current parked calls.

 

DATACOLLECTION - SQL Archiving Adaptor : Number of conference activities dropped

LS:DATACOLLECTION - SQL Archiving Adaptor

UDC - Number of conference activities dropped

 

MediationServer - Global Counters : Total failed calls caused by unexpected interaction from the Proxy

LS:MediationServer - Global Counters

-Total failed calls caused by unexpected interaction from the Proxy

 

MediationServer - Global Per Gateway Counters : Total failed calls caused by unexpected interaction from a gateway

LS:MediationServer - Global Per Gateway Counters

-Total failed calls caused by unexpected interaction from a gateway

_Total

USrv - Conference Control Notification : Incoming Get Conference requests

LS:USrv - Conference Control Notification

USrv - Incoming Get Conference requests

 

USrv - Conference Focus Base : ACKs received

LS:USrv - Conference Focus Base

USrv - ACKs received

 

MSSQL$RTC - Database Mirroring : Bytes Received/sec

MSSQL$RTC:Database Mirroring

Bytes Received/sec

 

MSSQL$RTC - Database Replica : File Bytes Received/sec

MSSQL$RTC:Database Replica

File Bytes Received/sec

 

MSSQL$RTCLOCAL - Database Mirroring : Bytes Received/sec

MSSQL$RTCLOCAL:Database Mirroring

Bytes Received/sec

 

MSSQL$RTCLOCAL - Database Replica : File Bytes Received/sec

MSSQL$RTCLOCAL:Database Replica

File Bytes Received/sec

_Total

MSSQL$LYNCLOCAL - Database Mirroring : Bytes Received/sec

MSSQL$LYNCLOCAL:Database Mirroring

Bytes Received/sec

 

MSSQL$LYNCLOCAL - Database Replica : File Bytes Received/sec

MSSQL$LYNCLOCAL:Database Replica

File Bytes Received/sec

_Total

USrv - Authorize delegate sproc : Number of calls

LS:USrv - Authorize delegate sproc

USrv - Number of calls

 

WEB - Location Information Service : Average processing time for a successful Get Locations In City request in milliseconds

LS:WEB - Location Information Service

WEB - Average processing time for a successful Get Locations In City request in milliseconds

 

PDP - Core - Video : Active BW Reservations

LS:PDP - Core - Video

PDP - Active BW Reservations

 

DATACOLLECTION - Exchange Archiving Adaptor : No Task Finish in Expected Time

LS:DATACOLLECTION - Exchange Archiving Adaptor

UDC - No Task Finish in Expected Time

 

Processor : %Idle Time

Processor

% Idle Time

_Total

SIP - Peers (Clients) : Connections Active

LS:SIP - Peers

SIP - Connections Active

Clients

ImMcu - IMMcu Conferences : Active Conferences

LS:ImMcu - IMMcu Conferences

IMMCU - Active Conferences

 

ImMcu - MCU Health And Performance : MCU Health state

LS:ImMcu - MCU Health And Performance

IMMCU - MCU Health State

 

SIP : Peers : Incoming Requests/sec

LS:SIP - Peers

SIP - Incoming Requests/sec

_Total

SIP : Peers : TLS Connections Active

LS:SIP - Peers

SIP - TLS Connections Active

_Total

SIP : Peers : Connections Active

LS:SIP - Peers

SIP - Connections Active

_Total

SIP - Protocol : Incomming Messages/sec

LS:SIP - Protocol

SIP - Incoming Messages/sec

 

SIP - Responses : Local 503 Responses/sec

LS:SIP - Responses

SIP - Local 503 Responses/sec

 

SIP - Load Management : Average Holding Time For Incoming Messages

LS:SIP - Load Management

SIP - Average Holding Time For Incoming Messages

 

SIP - Access Edge Server Messages : External Messages/sec Received With Allowed Partner Server Domain

LS:SIP - Access Edge Server Messages

SIP - External Messages/sec Received With Allowed Partner Server Domain

 

USrv - DBStore: Sproc Latency (msec)

LS:USrv - DBStore

USrv - Sproc Latency (msec)

 

SQLServer - User Settable (UserCounter 1) - Query

SQLServer:User Settable

Query

User counter 1

AsMCU - CCCP Processing : Number of add conference requests failed

LS:AsMcu - CCCP Processing

ASMCU - Number of add conference requests failed

 

USrv - Rich presence service SQL calls : Publications/Sec

LS:USrv - Rich presence service SQL calls

USrv - Publications/Sec

 

USrv - Endpoint Cache : Active registered endpoints

LS:USrv - Endpoint Cache

USrv - Active Registered Endpoints

 

USrv - Https Transport : Number of failed connects attempts / Sec

LS:USrv - Https Transport

USrv - Number of failed connection attempts / Sec

 

USrv - Conference Focus Factory : Add Conference request succeeded

LS:USrv - Conference Focus Factory

USrv - Add Conference requests succeeded

 

USrv - Conference Control : Local C3P failure responses

LS:USrv - Conference Control

USrv - Local C3P failure responses

 

USrv - Conference Mcu Allocator : Factory Unreachable Failures

LS:USrv - Conference Mcu Allocator

USrv - Factory Unreachable Failures

 

WebRelay - Reach Web Relay Server : Active Sip Connection

LS:WebRelay - Reach Web Relay Server

WEBRELAY - Active Sip Connections

 

AsMcu - AsMcu Conferences: Active Conferences

LS:AsMcu - AsMcu Conferences

ASMCU - Active Conferences

 

AsMcu - CCCP Processing : CCCP Messages Retried/sec

LS:AsMcu - CCCP Processing

ASMCU - CCCP Messages Retried/sec

 

DATAMCU - DataMCU Conferences : Active conferences

LS:DATAMCU - DataMCU Conferences

DATAMCU - Active Conferences

 

DATAMCU - MCU Health And Performance : MCU Health State

LS:DATAMCU - MCU Health And Performance

DATAMCU - MCU Health State

 

MediationServer - Outbound Calls : Current

LS:MediationServer - Outbound Calls

- Current

_Total

MediationServer - Inbound Calls : Current

LS:MediationServer - Inbound Calls

- Current

 

MediationServer - Health Indices : Load Call Failure Index

LS:MediationServer - Health Indices

- Load Call Failure Index

 

MediationServer - Global Counters : Current audio channels with PSM quality recording

LS:MediationServer - Global Counters

- Current audio channels with PSM quality reporting

 

MediationServer - Global Per Gateway Counters : Total failed calls caused by unexpected interaction from a gateway

LS:MediationServer - Global Per Gateway Counters

- Total failed calls caused by unexpected interaction from a gateway

_Total

RGS - Response Group Service Call Control : Current Active Calls

LS:RGS - Response Group Service Call Control

RGS - Current active calls

 

Processor: % Processor Time

Processor

% Processor Time

_Total

MSSQL$RTC:Buffer Manager : Page life expectancy

MSSQL$RTC:Buffer Manager

Page life expectancy

 

Memory: % Committed Bytes In Use

Memory

% Committed Bytes In Use

 

Network Interface : Bytes Total/sec

Network Interface

Bytes Total/sec

Intel[R] PRO_1000 MT Network Connection

Process: % previledge time

Process

% Privileged Time

_Total

Processor Information : % Processor Time

Processor Information

% Processor Time

_Total

Process: % processor time

Process

% Processor Time

_Total

Process: % Private Bytes

Process

Private Bytes

_Total

Process: (ASMCUSvc) % Processor time

Process

% Processor Time

ASMCUSvc

Process: (IMMCUSvc) % Processor time

Process

% Processor Time

IMMCUSvc

Process: (MediationServerSvc) % Processor time

Process

% Processor Time

MediationServerSvc

Process: (OcsAppServerHost#1) % Processor time

Process

% Processor Time

OcsAppServerHost#1

Process: (OcsAppServerHost#2) % Processor time

Process

% Processor Time

OcsAppServerHost#2

Process: (OcsAppServerHost#3) % Processor time

Process

% Processor Time

OcsAppServerHost#3

Process: (OcsAppServerHost#4) % Processor time

Process

% Processor Time

OcsAppServerHost#4

Process: (RTCSrv) % Processor time

Process

% Processor Time

RTCSrv

Process: (RtcHost) % Processor time

Process

% Processor Time

RtcHost

Memory: Available Mbytes

Memory

Available Mbytes

 

Memory: Cache Bytes Peak

Memory

Cache Bytes Peak

 

Processor Information : % Interrupt Time

Processor Information

% Interrupt Time

_Total

MSSQL$RTC:Databases(rtc) : Active Transactions

MSSQL$RTC:Databases

Active Transactions

rtc

MSSQL$RTC:Databases(rtcdyn) : Active Transactions

MSSQL$RTC:Databases

Active Transactions

rtcdyn

MSSQL$RTC:Databases(tempdb) : Active Transactions

MSSQL$RTC:Databases

Active Transactions

tempdb

Memory : Pages/Sec

Memory

Pages/sec

 

SIP - Access Edge Server : External Messages/sec With Internally Supported Domain

LS:SIP - Access Edge Server Messages

IP - External Messages/sec With Internally Supported Domain

 

SIP - Access Edge Server : External Messages/sec Received With a Configured Allowed Domain

LS:SIP - Access Edge Server Messages

SIP - External Messages/sec Received With a Configured Allowed Domain

 

Physical Disk : Avg. Disk Queue Length

PhysicalDisk

Avg. Disk Queue Length

_Total

Physical Disk : Avg. Disk Sec/Read

PhysicalDisk

Avg. Disk sec/Read

_Total

Physical Disk : Avg. Disk Sec/Write

PhysicalDisk

Avg. Disk sec/Write

_Total

Process: Virtual Bytes

Process

Virtual Bytes

_Total

USrv - Conference Mcu Allocator : Factory Calls Timed-Out

LS:USrv - Conference Mcu Allocator

USrv - Factory Calls Timed-Out

 

USrv - Conference Mcu Allocator : Create Conference Mcu Unreachable Failures

LS:USrv - Conference Mcu Allocator

USrv - Create Conference Mcu Unreachable Failures

 

USrv - Conference Mcu Allocator : Create Conference Requests Timed-Out

LS:USrv - Conference Mcu Allocator

USrv - Create Conference Requests Timed-Out

 

AsMcu - CCCP Processing : Current CCCP Message Queue Size

LS:AsMcu - CCCP Processing

ASMCU - Current CCCP Message Queue Size

 

AsMcu - CCCP Processing :Number of add user requests failed

LS:AVMCU - CCCP Processing

AVMCU - Number of add user requests failed

 

DATAMCU - MCU Health And Performance : MCU Draining State

LS:DATAMCU - MCU Health And Performance

DATAMCU - MCU Draining State

 

DATAMCU - DataMCU Conferences : Number of Data MCU users in any role

LS:DATAMCU - DataMCU Conferences

DATAMCU - Number of Data MCU users in any role

 

SIP - Peers : Average Outgoing Queue Delay

LS:SIP - Peers

SIP - Average Outgoing Queue Delay

_Total

AsMcu - AsMcu Conferences : Connected Users

LS:AsMcu - AsMcu Conferences

ASMCU - Connected Users

 

ImMcu - ImMcu Conferences : Connected Users

LS:ImMcu - IMMcu Conferences

IMMCU - Connected Users

 

USrv - DB Store : Throttled requests/sec

LS:USrv - DBStore

USrv - Throttled requests/sec

 

SIP - Load Management : Incoming Messages Held Above High Watermark

LS:SIP - Load Management

SIP - Incoming Messages Held Above High Watermark

 

SIP - Load Management : Incoming Messages Held Above High Overload Watermark

LS:SIP - Load Management

SIP - Incoming Messages Held Above Overload Watermark

 

SIP - Load Management : Incoming Messages Timed out

LS:SIP - Load Management

SIP - Incoming Messages Timed out

 

USrv - DB Store : Queue Latency (msec)

LS:USrv - DBStore

USrv - Queue Latency (msec)

 

SIP - Responses : Local 500 Responses/sec

LS:SIP - Responses

SIP - Local 500 Responses/sec

 

SIP - Responses : Local 504 Responses/sec

LS:SIP - Responses

SIP - Local 504 Responses/sec

 

SIP - Peers : Sends Outstanding

LS:SIP - Peers

SIP - Sends Outstanding

_Total

MediationServer - Outbound Calls : Active media bypass calls

LS:MediationServer - Outbound Calls

- Active media bypass calls

_Total

MediationServer - Inbound Calls : Active media bypass calls

LS:MediationServer - Inbound Calls

- Active media bypass calls

_Total

MediationServer - Media Relay : Media Connectivity Check Failure

LS:MediationServer - Media Relay

- Media Connectivity Check Failure

 

MEDIA - Planning : Number of occasions conference processing is delayed

LS:MEDIA - Planning

MEDIA - Number of occasions conference processing is delayed significantly

AVMCUSvc.exe

SipEps - SipEps Connections : NumberOfDNSResolutionFailures

LS:SipEps - SipEps Connections

SipEps - NumberOfDNSResolutionFailures

_Total

ImMcu - IMMcuSvc Conferences : Active Conferences

LS:ImMcu - IMMcu Conferences

IMMCU - Active Conferences

 

ImMcu - IMMcuSvc Conferences : Connected Users

LS:ImMcu - IMMcu Conferences

IMMCU - Connected Users

 

Process : (AVMCUSvc)% Processor Time

Process

% Processor Time

AVMCUSvc

Process: (DataMCUSvc) % Processor Time

Process

% Processor Time

DataMCUSvc

Process: (MeetingMCUSvc) % Processor Time

Process

% Processor Time

MeetingMCUSvc

Process: (ASMCUSvc) Private Bytes

Process

Private Bytes

ASMCUSvc

Process : (AVMCUSvc) Private Bytes

Process

Private Bytes

AVMCUSvc

Process: (DataMCUSvc) Private Bytes

Process

Private Bytes

DataMCUSvc

Process: (MeetingMCUSvc) Private Bytes

Process

Private ByteProcesss

MeetingMCUSvc

Common Performance Counters

 

 

 

Profile Name

Object

Performance Counter

Instance

Processor: % Processor Time

Processor

% Processor Time

_Total

Process: (IMMCUSvc) % Processor time

Process

% Processor Time

IMMCUSvc

Network Interface : Bytes Total/sec

Network Interface

Bytes Total/sec

Select the NIC card installed on the lync server

SIP : Peers : Incoming Requests/sec

LS:SIP - 01 - Peers

SIP - 028 - Incoming Requests/sec

_Total

SIP : Peers : TLS Connections Active

LS:SIP - 01 - Peers

SIP - 001 - TLS Connections Active

_Total

SIP : Peers : Connections Active

LS:SIP - 01 - Peers

SIP - 000 - Connections Active

_Total

SIP - Protocol : Incoming Messages/sec

LS:SIP - 02 - Protocol

SIP - 001 - Incoming Messages/sec

 

ImMcu - IMMcuSvc Conferences : Active Conferences

LS:ImMcu - 00 - IMMcu Conferences

IMMCU - 000 - Active Conferences

 

ImMcu - IMMcuSvc Conferences : Connected Users

LS:ImMcu - 00 - IMMcu Conferences

IMMCU - 001 - Connected Users

 

Memory : Pages/Sec

Memory

Pages/sec

 

Process: (ASMCUSvc) % Processor time

Process

% Processor Time

ASMCUSvc

Process: (AVMCUSvc) % Processor Time

Process

% Processor Time

AVMCUSvc

Process : (DATAMCUSvc) % Processor Time

Process

% Processor Time

DataMCUSvc

Process : (MeetingMCUSvc) % Processor Time

Process

% Processor Time

MeetingMCUSvc

Process: (ASMCUSvc) Private Bytes

Process

Private Bytes

ASMCUSvc

Process: (AVMCUSvc) Private Bytes

Process

Private Bytes

AVMCUSvc

Process: (DataMCUSvc) Private Bytes

Process

Private Bytes

DataMCUSvc

Process: (Meeting MCUSvc) Private Bytes

Process

Private Bytes

MeetingMCUSvc

Performance Counters for User-defined Profiles

The default configuration of the probe contains some selected profiles for monitoring and also lets you define your own profiles. The performance counters for those profiles are mentioned in the following table:

 

 

 

Group Name

Counter Name

 

\LS:SIP - 09 - Access Edge\SIP - 001 - External Messages/sec Received With IM Service Provider Domain

EDGE SERVER (the A/V Conferencing Edge component

 

(audio/video and application sharing)

LS:A/V Edge - 001 - Active Relay Sessions - Authenticated

 

LS:A/V Edge - 002 - Active Relay Sessions - Allocated Port

 

LS:A/V Edge - 003 - Active Relay Sessions - Data

 

LS:A/V Edge - 004 - Allocated Port Pool Count

 

LS:A/V Edge - 005 - Allocated Port Pool Miss Count

 

LS:A/V Edge - 006 - Allocate Requests/sec

 

LS:A/V Edge - 009 - Allocate Requests Exceeding Port Limit

 

LS:A/V Edge - 012 - Alternate Server Redirects

 

LS:A/V Edge - 019 - Session Idle Timeouts/sec

 

LS:A/V Edge - 021 - Packets Received/sec

 

LS:A/V Edge - 022 - Packets Sent/sec

 

LS:A/V Edge - 025 - Average Data Packet Latency (milliseconds)

 

LS:A/V Edge - 030 - Packets Dropped/sec

EDGE SERVER (A/V Edge - TCP Counters)

LS:A/V Edge - 001 - Active Relay Sessions - Authenticated

 

LS:A/V Edge - 002 - Active Relay Sessions - Allocated Port

 

LS:A/V Edge - 003 - Active Relay Sessions - Data

 

LS:A/V Edge - 004 - Allocated Port Pool Count

 

LS:A/V Edge - 005 - Allocated Port Pool Miss Count

 

LS:A/V Edge - 006 - Allocate Requests/sec

 

LS:A/V Edge - 009 - Allocate Requests Exceeding Port Limit

 

LS:A/V Edge - 012 - Alternate Server Redirects

 

LS:A/V Edge - 019 - Session Idle Timeouts/sec

 

LS:A/V Edge - 021 - Packets Received/sec

 

LS:A/V Edge - 022 - Packets Sent/sec

 

LS:A/V Edge - 025 - Average Data Packet Latency (milliseconds)

 

LS:A/V Edge - 030 - Packets Dropped/sec

 

SQLServer:User Settable\User Counter 1

Supported KHI Counters

The supported KHI counters are grouped under following Microsoft Lync Server functions:

  • All Servers

  • Front End Servers

  • Edge Server

  • Back End Server

  • Mediation Server

  • A/V Conferencing Server

 

These counters are supported on the Lync Server versions 2013, and 2015.

All Servers

 

 

 

Profile Name

Object

Performance Counter

Instance

Processor Information(*)\% Processor Time

Processor Information

% Processor Time

_Total

Memory\Available Mbytes

Memory

Available Mbytes

-

Network Interface(*)\Output Queue Length

Network Interface

Output Queue Length

-

Network Interface(*)\Packets Outbound Discarded

Network Interface

Packets Outbound Discarded

-

Network Interface(*)\Packets Received Discarded

Network Interface

Packets Received Discarded

-

PhysicalDisk(*)\Avg. Disk sec/Read

PhysicalDisk

Avg. Disk sec/Read

_Total

PhysicalDisk(*)\Avg. Disk sec/Write

PhysicalDisk

Avg. Disk sec/Write

_Total

SQL Server

 

 

 

Profile Name

Object

Performance Counter

MSSQL$INSTANCE:Buffer Manager\Page life expectancy

MSSQL$INSTANCE:Buffer Manager

Page life expectancy

Front End Servers

 

 

 

Profile Name

Object

Performance Counter

Instance

Usrv - DBStore\Usrv - Queue Latency (msec)

LS:Usrv - DBStore

Usrv - Queue Latency (msec)

-

Usrv - DBStore\Usrv - Sproc Latency (msec)

LS:Usrv - DBStore

Usrv - Sproc Latency (msec)

-

Usrv - DBStore\Usrv - Throttled requests/sec

LS:Usrv - DBStore

Usrv - Throttled requests/sec

-

Usrv - REGDBStore\Usrv - Queue Latency (msec)

LS:Usrv - REGDBStore

Usrv - Queue Latency (msec)

-

Usrv - REGDBStore\Usrv - Sproc Latency (msec)

LS:Usrv - REGDBStore

Usrv - Sproc Latency (msec)

-

Usrv - REGDBStore\Usrv - Throttled requests/sec

LS:Usrv - REGDBStore

Usrv - Throttled requests/sec

-

Usrv - SharedDBStore\Usrv - Queue Latency (msec)

LS:Usrv - SharedDBStore

Usrv - Queue Latency (msec)

-

Usrv - SharedDBStore\Usrv - Sproc Latency (msec)

LS:Usrv - SharedDBStore

Usrv - Sproc Latency (msec)

-

Usrv - SharedDBStore\Usrv - Throttled requests/sec

LS:Usrv - SharedDBStore

Usrv - Throttled requests/sec

-

SIP - Authentication\SIP - Authentication System Errors/sec

LS:SIP - Authentication

SIP - Authentication System Errors/sec

-

SIP - Load Management\SIP - Average Holding Time For Incoming Messages

LS:SIP - Load Management

SIP - Average Holding Time For Incoming Messages

-

SIP - Load Management\SIP - Incoming Messages Timed out

LS:SIP - Load Management

SIP - Incoming Messages Timed out

-

SIP - Peers(*)\SIP - Average outgoing Queue Delay

LS:SIP - Peers

SIP - Average outgoing Queue Delay

_Total

SIP - Peers(*)\SIP - Flow-controlled Connections

LS:SIP - Peers

SIP - Flow-controlled Connections

_Total

SIP - Peers(*)\SIP - Sends Timed-Out/sec

LS:SIP - Peers

SIP - Sends Timed-Out/sec

_Total

SIP - Protocol\SIP - Average Incoming Message Processing Time

LS:SIP - Protocol

SIP - Average Incoming Message Processing Time

-

SIP - Protocol\SIP - Incoming Requests Dropped/sec

LS:SIP - Protocol

SIP - Incoming Requests Dropped/sec

-

SIP - Protocol\SIP - Incoming Responses Dropped/sec

LS:SIP - Protocol

SIP - Incoming Responses Dropped/sec

-

SIP - Responses\SIP - Local 503 Responses/sec

LS:SIP - Responses

SIP - Local 503 Responses/sec

-

Usrv - Cluster Manager\Usrv - Number of failures of replication operations sent to other Replicas per second

LS:Usrv - Cluster Manager

Usrv - Number of failures of replication operations sent to other Replicas per second

-

XMPPFederation - SIP Instant Messaging\XMPPFederation - Failure IMDNs sent/sec

LS:XMPPFederation - SIP Instant Messaging

XMPPFederation - Failure IMDNs sent/sec

-

RoutingApps - Emergency Call Routing\RoutingApps - Number of incoming failure responses

LS:RoutingApps - Emergency Call Routing

RoutingApps - Number of incoming failure responses

-

CAA - Operations\CAA - Incomplete calls per sec

LS:CAA - Operations

CAA - Incomplete calls per sec

-

USrv - Conference Mcu Allocator\USrv - Create Conference Latency (msec)

LS:USrv - Conference Mcu Allocator

USrv - Create Conference Latency (msec)

-

ASP.NET Apps v4.0.30319(*)\Requests Rejected

ASP.NET Apps v4.0.30319

Requests Rejected

_Total

JoinLauncher - Join Launcher Service Failures\JOINLAUNCHER - Join Failures

LS:JoinLauncher - Join Launcher Service Failures

JOINLAUNCHER - Join Failures

-

WEB - Address Book File Download\WEB - Failed File Requests/Second

LS:WEB - Address Book File Download

WEB - Failed File Requests/Second

-

WEB - Address Book Web Query\WEB - Failed search requests/sec

LS:WEB - Address Book Web Query

WEB - Failed search requests/sec

-

WEB - Auth Provider related calls\WEB - Failed validate cert calls to the cert auth provider

LS:WEB - Auth Provider related calls

WEB - Failed validate cert calls to the cert auth provider

-

WEB - Distribution List Expansion\WEB - Timed out Active Directory Requests/sec

LS:WEB - Distribution List Expansion

WEB - Timed out Active Directory Requests/sec

-

WEB - UCWA\UCWA - HTTP 5xx Responses/Second

LS:WEB - UCWA

UCWA - HTTP 5xx Responses/Second

_Total

ASMCU - MCU Health And Performance\ASMCU - MCU Health State

LS:ASMCU - MCU Health And Performance

ASMCU - MCU Health State

-

AVMCU - MCU Health And Performance\AVMCU - MCU Health State

LS:AVMCU - MCU Health And Performance

AVMCU - MCU Health State

-

DATAMCU - MCU Health And Performance\DATAMCU - MCU Health State

LS:DATAMCU - MCU Health And Performance

DATAMCU - MCU Health State

-

IMMCU - MCU Health And Performance\IMMCU - MCU Health State

LS:IMMCU - MCU Health And Performance

IMMCU - MCU Health State

-

IMMCU - IMMcu Conferences\IMMCU - Throttled Sip Connections

LS:IMMCU - IMMcu Conferences

IMMCU - Throttled Sip Connections

-

Mediation Servers

 

 

 

Profile Name

Object

Performance Counter

MediationServer - Global Counters\- Total failed calls caused by unexpected interaction from the Proxy

LS:MediationServer - Global Counters

- Total failed calls caused by unexpected interaction from the Proxy

MediationServer - Global Per Gateway Counters(*)\- Total failed calls caused by unexpected interaction from a gateway

LS:MediationServer - Global Per Gateway Counters

- Total failed calls caused by unexpected interaction from a gateway

MediationServer - Health Indices\- Load Call Failure Index

LS:MediationServer - Health Indices

- Load Call Failure Index

MediationServer - Media Relay\- Candidates Missing

LS:MediationServer - Media Relay

- Candidates Missing

MediationServer - Media Relay\- Media Connectivity Check Failure

LS:MediationServer - Media Relay

- Media Connectivity Check Failure

Video Integration Server

These counters are supported only on the Lync Server version 2015.

 

 

 

Profile Name

Object

Performance Counter

VISSvc - VISSvc\VIS - Total Calls declined due to load

LS:VISSvc - VISSvc

- Total Calls declined due to load

VISSvc - VISSvc\VIS - Total Proxy Leg Call Failures

LS:VISSvc - VISSvc

- Total Proxy Leg Call Failures

VISSvc - VISSvc\VIS - Total Interop Leg Call Failures

LS:VISSvc - VISSvc

- Total Interop Leg Call Failures

Edge Server

 

 

 

Profile Name

Object

Performance Counter

Instance

A/V Edge - UDP Counters(*)\A/V Edge - Authentication Failures/sec

LS:A/V Edge - UDP Counters

A/V Edge - Authentication Failures/sec

-

A/V Edge - UDP Counters(*)\A/V Edge - Allocate Requests Exceeding Port Limit

LS:A/V Edge - UDP Counters

A/V Edge - Allocate Requests Exceeding Port Limit

-

A/V Edge - UDP Counters(*)\A/V Edge - Packets Dropped/sec

LS:A/V Edge - UDP Counters

A/V Edge - Packets Dropped/sec

-

A/V Edge - TCP Counters(*)\A/V Edge - Authentication Failures/sec

LS:A/V Edge - TCP Counters

A/V Edge - Authentication Failures/sec

-

A/V Edge - TCP Counters(*)\A/V Edge - Allocate Requests Exceeding Port Limit

LS:A/V Edge - TCP Counters

A/V Edge - Allocate Requests Exceeding Port Limit

-

A/V Edge - TCP Counters(*)\A/V Edge - Packets Dropped/sec

LS:A/V Edge - TCP Counters

A/V Edge - Packets Dropped/sec

-

DATAPROXY - Server Connections(*)\DATAPROXY - System is throttling

LS:DATAPROXY - Server Connections

DATAPROXY - System is throttling

-

SIP - Peers(*)\SIP - Above Limit Connections Dropped (Access Proxies only)

LS:SIP - Peers

SIP - Above Limit Connections Dropped (Access Proxies only)

_Total

SIP - Peers(*)\SIP - Sends Timed-Out/sec

LS:SIP - Peers

SIP - Sends Timed-Out/sec

_Total

SIP - Peers(*)\SIP - Flow-controlled Connections

LS:SIP - Peers

SIP - Flow-controlled Connections

_Total

SIP - Protocol\SIP - Incoming Requests Dropped/sec

LS:SIP - Protocol

SIP - Incoming Requests Dropped/sec

-

SIP - Protocol\SIP - Average Incoming Message Processing Time

LS:SIP - Protocol

SIP - Average Incoming Message Processing Time

-

XmppFederationProxy - Streams\XmppFederationProxy - Failed inbound stream establishes/sec

LS:XmppFederationProxy - Streams

XmppFederationProxy - Failed inbound stream establishes/sec

-

XmppFederationProxy - Streams\XmppFederationProxy - Failed outbound stream establishes/sec

LS:XmppFederationProxy - Streams

XmppFederationProxy - Failed outbound stream establishes/sec

728x90
728x90

윈도우7 지원 종료가 2020년 1월14일 끝났지만, 피치 못할 환경으로 윈도우7/윈도우2008 업데이트 지원을 받을 수 있습니다.

물론 계약을 해야 가능 하므로 비용 발생이 됩니다.

MS ESU(Extended Security Updates) 계약이 있는 것을 알았습니다.

최대 3년간 받을 수 있다고 하네요.

 

연장된 보안 업데이트(ESU) 프로그램이란 무엇인가요?

연장된 보안 업데이트(ESU) 프로그램은 지원이 종료된 후에 특정 레거시 Microsoft 제품을 실행해야 하는 고객을 위해 마지막 수단으로 제공되는 옵션입니다. 제품의 추가 지원 날짜가 종료된 후 최대 3년 동안 필수* 및/또는 중요* 보안 업데이트를 포함합니다.

사용 가능한 경우 연장된 보안 업데이트가 배포됩니다. ESU에는 새로운 기능, 고객 요청 비보안 업데이트 또는 디자인 변경 요청은 포함되지 않습니다.

운영 체제가 그때까지 지원되므로 모든 Windows 7 및 Windows Server 2008/R2 고객은 2020 년 1월 14일에 업데이트를 받게 됩니다. 2020년 1월 14일 이후에 이 운영 체제에 대한 업데이트는 ESU 고객에게만 해당합니다.

 

Windows 7 ESU(확장 보안 업데이트)에는 무엇이 포함되어 있습니까?

Windows 7 ESU에는 MSRC(Microsoft 보안 대응 센터)에서 정의한 중요한 문제에 대한 2020년 1월 14일 이후 최장 3년 간의 보안 업데이트가 포함되어 있습니다. 2020년 1월 14일 이후에 PC에서 Windows 7을 실행하고 있으나 확장 보안 업데이트는 구입되어 있지 않은 경우 컴퓨터는 더 이상 보안 업데이트를 받지 않습니다.

보안 업데이트이 필요한 경우 고객은 무료로 다음 제품에 대한 연장된 보안 업데이트를 받을 수 있습니다.

  • SQL 및 Windows Server 2008/R2: 워크로드를 “있는 그대로” Azure 가상 머신(IaaS)으로 이동하려는 고객은 지원이 종료된 후 3년 동안 SQL Server와 Windows Server 2008 및 2008 R2 모두에 대해 연장된 보안 업데이트에 무료로 액세스할 수 있습니다.
  • Windows 7: Microsoft Windows Virtual Desktop은 2023년 1월까지 무료로 연장된 보안 업데이트를 통해 Windows 7 장치를 제공합니다.
  • .NET 3.5 SP1, .NET 4.5.2 및 .NET 4.6은 Windows Server 2008 ESU 동안 지원됩니다.

  • .NET 3.5 SP1 및 .NET 4.5.2부터 .NET 4.8까지는 Windows Server 2008 R2 및 Windows 7 ESU 단계 동안 지원됩니다.

Windows Server와 SQL Server 2008, 2008 R2에 대한 보안 연장 업데이트 비용은 어떻게 되나요?

Azure:

    Azure에서 Windows Server 또는 SQL Server 2008, 2008 R2를 실행하는 고객은 가상 머신을 실행하는 요금 외에 추가 비용 없이 보안 연장 업데이트를 받을 수 있습니다. Azure SQL Database Managed Instance (PaaS)로 이동하는 고객은 보안 연장 업데이트가 필요치 않습니다. 완벽한 관리형 솔루션이기 때문에 Microsoft가 항상 업데이트하고 패치합니다.

사내 데이터센터(on-Premises):

    활성 Software Assurance 또는 구독 라이선스를 보유한 고객은 온-프레미스 라이선스 연간 비용의 약 75%에 해당하는 가격으로 보안 연장 업데이트를 구입할 수 있습니다. 가격은 게시된 가격표에서 확인할 수 있습니다. 자세한 내용은 해당 지역의 Microsoft 파트너 또는 영업 팀에 문의하세요.

호스팅 환경:

    SPLA 공인 호스팅 업체에서 Windows Server 또는 SQL Server 2008/2008 R2를 구입한 고객은 Enterprise 또는 Server 및 Cloud Enrollment에서 보안 연장 업데이트를 별도로 구입해야 합니다. 온-프레미스 라이선스 연간 비용의 약 75% 가격으로 Microsoft에서 직접 구입하거나 Microsoft 리셀러를 통해 구입합니다. Microsoft 리셀러를 통해 판매되는 보안 연장 업데이트의 가격은 리셀러가 책정합니다. Windows Server 보안 연장 업데이트의 가격은 Windows Server Standard의 코어당 가격을 기준으로 책정됩니다. 호스팅된 가상 머신의 가상 코어 수를 기반으로 하며 인스턴스당 최소 16개의 라이선스가 적용됩니다. SQL Server 보안 연장 업데이트의 가격은 SQL Server의 코어당 가격을 기준으로 책정됩니다. 호스팅된 가상 머신의 가상 코어 수를 기반으로 하며 인스턴스당 최소 4개의 라이선스가 적용됩니다. Software Assurance는 필요하지 않습니다. 자세한 내용은 해당 지역의 Microsoft 리셀러 또는 영업 팀에 문의하세요.

 

자세한 것은 아래 사이트 참고 하시기 하시기 바랍니다.

https://support.microsoft.com/ko-kr/help/4527878/faq-about-extended-security-updates-for-windows-7

https://support.microsoft.com/ko-kr/help/4497181/lifecycle-faq-extended-security-updates

728x90
728x90

윈도우7이 종료 되었지만, 무료 업그레이드는 지속적으로 유지 할 듯 하다는 내용입니다.

 

업그레이드 방법 :https://mani4u.tistory.com/289?category=588428

 

업그레이드 방법 : https://mani4u.tistory.com/289?category=588428

 

728x90
728x90

By Mark Russinovich and Andrew Richards

Published: May 16, 2017

Download ProcDump (439 KB)

Download ProcDump for Linux (GitHub)

Introduction

ProcDump is a command-line utility whose primary purpose is monitoring an application for CPU spikes and generating crash dumps during a spike that an administrator or developer can use to determine the cause of the spike. ProcDump also includes hung window monitoring (using the same definition of a window hang that Windows and Task Manager use), unhandled exception monitoring and can generate dumps based on the values of system performance counters. It also can serve as a general process dump utility that you can embed in other scripts.

Using ProcDump

usage: procdump [-a] [[-c|-cl CPU usage] [-u] [-s seconds]] [-n exceeds] [-e [1 [-b]] [-f ] [-g] [-h] [-l] [-m|-ml commit usage] [-ma | -mp] [-o] [-p|-pl counter threshold] [-r] [-t] [-d ] [-64] <[-w]< process name or service name or PID> [dump file] | -i | -u | -x

[arguments]> ] [-? [ -e]

ParameterDescription

-a Avoid outage. Requires -r. If the trigger will cause the target to suspend for a prolonged time due to an exceeded concurrent dump limit, the trigger will be skipped.
-at Avoid outage at Timeout. Cancel the trigger's collection at N seconds.
-b Treat debug breakpoints as exceptions (otherwise ignore them).
-c CPU threshold at which to create a dump of the process.
-cl CPU threshold below which to create a dump of the process.
-d Invoke the minidump callback routine named MiniDumpCallbackRoutine of the specified DLL.
-e Write a dump when the process encounters an unhandled exception. Include the 1 to create dump on first chance exceptions.
-f Filter the first chance exceptions. Wildcards (*) are supported. To just display the names without dumping, use a blank ("") filter.
-fx Filter (exclude) on the content of exceptions and debug logging. Wildcards are supported.
-g Run as a native debugger in a managed process (no interop).
-h Write dump if process has a hung window (does not respond to window messages for at least 5 seconds).
-i Install ProcDump as the AeDebug postmortem debugger. Only -ma, -mp, -d and -r are supported as additional options.
-k Kill the process after cloning (-r), or at the end of dump collection
-l Display the debug logging of the process.
-m Memory commit threshold in MB at which to create a dump.
-ma Write a dump file with all process memory. The default dump format only includes thread and handle information.
-mc Write a custom dump file. Include memory defined by the specified MINIDUMP_TYPE mask (Hex).
-md Write a Callback dump file. Include memory defined by the MiniDumpWriteDump callback routine named MiniDumpCallbackRoutine of the specified DLL.
-mk Also write a Kernel dump file. Includes the kernel stacks of the threads in the process. OS doesn't support a kernel dump (-mk) when using a clone (-r). When using multiple dump sizes, a kernel dump is taken for each dump size.
-ml Trigger when memory commit drops below specified MB value.
-mm Write a mini dump file (default).
-mp Write a dump file with thread and handle information, and all read/write process memory. To minimize dump size, memory areas larger than 512MB are searched for, and if found, the largest area is excluded. A memory area is the collection of same sized memory allocation areas. The removal of this (cache) memory reduces Exchange and SQL Server dumps by over 90%.
-n Number of dumps to write before exiting.
-o Overwrite an existing dump file.
-p Trigger on the specified performance counter when the threshold is exceeded. Note: to specify a process counter when there are multiple instances of the process running, use the process ID with the following syntax: "\Process(_)\counter"
-pl Trigger when performance counter falls below the specified value.
-r Dump using a clone. Concurrent limit is optional (default 1, max 5).
CAUTION: a high concurrency value may impact system performance.
- Windows 7 : Uses Reflection. OS doesn't support -e.
- Windows 8.0 : Uses Reflection. OS doesn't support -e.
- Windows 8.1+: Uses PSS. All trigger types are supported.
-s Consecutive seconds before dump is written (default is 10).
-t Write a dump when the process terminates.
-u Treat CPU usage relative to a single core (used with -c).
As the only option, Uninstalls ProcDump as the postmortem debugger.
-w Wait for the specified process to launch if it's not running.
-wer Queue the (largest) dump to Windows Error Reporting.
-x Launch the specified image with optional arguments. If it is a Store Application or Package, ProcDump will start on the next activation (only).
-64 By default ProcDump will capture a 32-bit dump of a 32-bit process when running on 64-bit Windows. This option overrides to create a 64-bit dump. Only use for WOW64 subsystem debugging.
-? Use -? -e to see example command lines.

If you omit the dump file name, it defaults to< processname>_.dmp.

Use the -accepteula command line option to automatically accept the Sysinternals license agreement.

Automated Termination:
Setting an event with name "procdump-" is the same as typing Ctrl+C to gracefully terminate ProcDump

Filename:
Default dump filename: PROCESSNAME_YYMMDD_HHMMSS.dmp
The following substitutions are supported:
PROCESSNAME Process Name
Process ID PID
EXCEPTIONCODE Exception Code
YYMMDD Year/Month/Day
HHMMSS Hour/Minute/Second

Examples

Write a mini dump of a process named 'notepad' (only one match can exist):

C:\>procdump notepad

Write a full dump of a process with PID '4572':

C:\>procdump -ma 4572

Write 3 mini dumps 5 seconds apart of a process named 'notepad':

C:\>procdump -s 5 -n 3 notepad

Write up to 3 mini dumps of a process named 'consume' when it exceeds 20% CPU usage for five seconds:

C:\>procdump -c 20 -s 5 -n 3 consume

Write a mini dump for a process named 'hang.exe' when one of it's Windows is unresponsive for more than 5 seconds:

C:\>procdump -h hang.exe hungwindow.dmp

Write a mini dump of a process named 'outlook' when total system CPU usage exceeds 20% for 10 seconds:

C:\>procdump outlook -p "\Processor(_Total)\% Processor Time" 20

Write a full dump of a process named 'outlook' when Outlook's handle count exceeds 10,000:

C:\>procdump -ma outlook -p "\Process(Outlook)\Handle Count" 10000

Write a MiniPlus dump of the Microsoft Exchange Information Store when it has an unhandled exception:

C:\>procdump -mp -e store.exe

Display without writing a dump, the exception codes/names of w3wp.exe:

C:\>procdump -e 1 -f "" w3wp.exe

Write a mini dump of w3wp.exe if an exception's code/name contains 'NotFound':

C:\>procdump -e 1 -f NotFound w3wp.exe

Launch a process and then monitor it for exceptions:

C:\>procdump -e 1 -f "" -x c:\dumps consume.exe

Register for launch, and attempt to activate, a modern 'application'. A new ProcDump instance will start when it activated to monitor for exceptions:

C:\>procdump -e 1 -f "" -x c:\dumpsMicrosoft.BingMaps_8wekyb3d8bbwe!AppexMaps

Register for launch of a modern 'package'. A new ProcDump instance will start when it is (manually) activated to monitor for exceptions:

C:\>procdump -e 1 -f "" -x c:\dumps Microsoft.BingMaps_1.2.0.136_x64__8wekyb3d8bbwe

Register as the Just-in-Time (AeDebug) debugger. Makes full dumps in c:\dumps.

C:\>procdump -ma -i c:\dumps

See a list of example command lines (the examples are listed above):

C:\>procdump -? -e

  • Windows Internals Book
    The official updates and errata page for the definitive book on Windows internals, by Mark Russinovich and David Solomon.
  • Windows Sysinternals Administrator's Reference
    The official guide to the Sysinternals utilities by Mark Russinovich and Aaron Margosis, including descriptions of all the tools, their features, how to use them for troubleshooting, and example real-world cases of their use.

Download ProcDump (439 KB)

Download ProcDump for Linux (GitHub)

Runs on:

  • Client: Windows Vista and higher.
  • Server: Windows Server 2008 and higher.

Learn More

 

 

참고

[개요]

  • 이 문서는 어플리케이션 프로세스의 메모리덤프를 생성하는 방법을 기술합니다. 블루스크린(BSoD) 등과 관련된 커널메모리 덤프는 다루지 않습니다.
  • 기술지원 담당자 등 자신이 개발하지 않은 프로세스의 메모리덤프를 작성해야 하는 분들을 위해 작성되었습니다.

 

 

[프로세스 Crash 발생시 메모리덤프 생성하기]

  • 프로세스에 오류가 발생하여 Crash될 때 자동으로 덤프를 생성하는 방법입니다.
  • Crash가 발생하기 전에 미리 설정해놓아야 합니다.

 

[방법1] procdump를 이용하는 방법

    • 다음의 위치에서 procdump.exe를 다운로드받아 임의의 위치에 압축해제합니다. (예 : C:\temp )

https://docs.microsoft.com/en-us/sysinternals/downloads/procdump

    • 관리자 권한으로 커맨드 쉘(cmd.exe)을 실행하여 다음의 명령을 실행합니다. (폴더 경로를 생략하는 경우 procdump.exe가 존재하는 위치에 생성됩니다.

procdump.exe -ma -i [덤프파일 생성할 폴더경로]

 

 

    • 이제 시스템에서 어떤 프로세스든 비정상 종료하게 되면 메모리덤프 파일이 생성됩니다.

 

    • 메모리덤프 설정을 해제하려면 다음과 같이 명령을 입력하면 됩니다.

procdump.exe -u

 

 

[방법2] WER (Windows Error Reporting)을 이용하는 방법

    • Vista 이후부터 윈도우즈에서 실행중인 프로세스가 오류를 일으켜 Crash가 발생하면 메모리덤프를 생성하고 Microsoft로 전송하는 기능이 생겼습니다.
    • 기본설정의 경우 Microsoft로 전송된 메모리덤프는 삭제되는데, 다음의 레지스트리 위치에 키를 생성하고 값을 설정하면 메모리덤프를 로컬에 남길 수 있습니다.

키 : HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\Windows Error Reporting\LocalDumps

 

값이름 : DumpFolder

Type : REG_EXPANDSZ

값 : C:\temp\dump

 

값이름 : DumpType

Type : REG_DWORD

값 : 2

 

 

 

 

    • 자세한 내용은 다음의 링크를 참조하시기 바랍니다.

https://docs.microsoft.com/ko-kr/windows/desktop/wer/collecting-user-mode-dumps

 

 

[방법3] Dr.Watson을 사용하는 방법

    • WindowsXP에서 사용하는 방법입니다.
    • 다음의 링크를 참조하시기 바랍니다.

http://kuaaan.tistory.com/213

 

 

 

[실행중인 프로세스의 메모리덤프 생성]

  • 오류 없이 실행중인 프로세스의 메모리덤프를 생성하는 방법입니다.
  • 주로 Hang, DeadLock, CPU과점유 등의 이슈가 발생한 프로세스의 원인을 분석할 때 필요합니다.

 

[방법1] 작업관리자를 이용하는 방법

 

1. 다음 스크린샷을 참고하시기 바랍니다.

 

2. 메모리덤프는 %temp% 폴더에 생깁니다. (시작 > 실행 > 명령창에 %temp% 를 명령하고 엔터치면 바로 이동이 가능합니다.)

 

 

[방법2] procdump 를 이용하는 방법

1. 별도의 실행파일을 다운로드받아야 한다는 번거로움이 있지만, 스크립트 등을 이용해 자동화할 수 있고 'CPU 80% 이상 점유하는 경우에 덤프 생성' 등 다양한 기능을 사용할 수 있습니다. (procdump /? 참조)

 

2. 관리자 권한 커맨드 쉘에서 다음과 같이 입력하면 됩니다.

procdump.exe notepad.exe (프로세스 이름으로 덤프 : 매치되는 프로세스가 1개인 경우에 한함)

procdump.exe 12776 (프로세스ID)

 

728x90

+ Recent posts