perfmon-sql-domain.xml - Поддержка Digispot II

Пример использования PerfMon » perfmon-sql-domain.xml

Sergey Kolyshkin, 07/02/2022 13:56

    
    яю<?xml version="1.0" encoding="UTF-16"?>

    <DataCollectorSet>

    	<Status>0</Status>

    	<Duration>0</Duration>

    	<Description>

    	</Description>

    	<DescriptionUnresolved>

    	</DescriptionUnresolved>

    	<DisplayName>

    	</DisplayName>

    	<DisplayNameUnresolved>

    	</DisplayNameUnresolved>

    	<SchedulesEnabled>-1</SchedulesEnabled>

    	<LatestOutputLocation>C:\Users\skolishkin\Desktop\;>:0;L=K9 N=8AB0@\sql\SUPPORT4_20190809-000004</LatestOutputLocation>

    	<Name>sql</Name>

    	<OutputLocation>C:\Users\skolishkin\Desktop\sql\SUPPORT4_20191120-000005</OutputLocation>

    	<RootPath>C:\Users\skolishkin\Desktop\sql</RootPath>

    	<Segment>-1</Segment>

    	<SegmentMaxDuration>86400</SegmentMaxDuration>

    	<SegmentMaxSize>0</SegmentMaxSize>

    	<SerialNumber>5</SerialNumber>

    	<Server>

    	</Server>

    	<Subdirectory>

    	</Subdirectory>

    	<SubdirectoryFormat>3</SubdirectoryFormat>

    	<SubdirectoryFormatPattern>yyyyMMdd\-NNNNNN</SubdirectoryFormatPattern>

    	<Task>

    	</Task>

    	<TaskRunAsSelf>0</TaskRunAsSelf>

    	<TaskArguments>

    	</TaskArguments>

    	<TaskUserTextArguments>

    	</TaskUserTextArguments>

    	<UserAccount>MAINDOMAIN\skolishkin</UserAccount>

    	<Security>O:BAG:DUD:AI(A;;FA;;;SY)(A;;FA;;;BA)(A;;0x1200a9;;;LU)(A;;0x1301ff;;;S-1-5-80-2661322625-712705077-2999183737-3043590567-590698655)(A;ID;0x1f019f;;;BA)(A;ID;0x1f019f;;;SY)(A;ID;FR;;;AU)(A;ID;FR;;;LS)(A;ID;FR;;;NS)(A;ID;FA;;;BA)</Security>

    	<StopOnCompletion>0</StopOnCompletion>

    	<PerformanceCounterDataCollector>

    		<DataCollectorType>0</DataCollectorType>

    		<Name>DataCollector01</Name>

    		<FileName>DataCollector01</FileName>

    		<FileNameFormat>0</FileNameFormat>

    		<FileNameFormatPattern>

    		</FileNameFormatPattern>

    		<LogAppend>0</LogAppend>

    		<LogCircular>0</LogCircular>

    		<LogOverwrite>0</LogOverwrite>

    		<LatestOutputLocation>C:\Users\skolishkin\Desktop\;>:0;L=K9 N=8AB0@\sql\SUPPORT4_20190809-000004\DataCollector01.blg</LatestOutputLocation>

    		<DataSourceName>

    		</DataSourceName>

    		<SampleInterval>5</SampleInterval>

    		<SegmentMaxRecords>0</SegmentMaxRecords>

    		<LogFileFormat>3</LogFileFormat>

    		<Counter>\MSSQL$SQLEXPRESS:Buffer Manager\Buffer cache hit ratio</Counter>

    		<Counter>\MSSQL$SQLEXPRESS:Buffer Manager\Database pages</Counter>

    		<Counter>\MSSQL$SQLEXPRESS:Buffer Manager\Page reads/sec</Counter>

    		<Counter>\MSSQL$SQLEXPRESS:Buffer Manager\Page writes/sec</Counter>

    		<Counter>\MSSQL$SQLEXPRESS:Buffer Manager\Checkpoint pages/sec</Counter>

    		<Counter>\MSSQL$SQLEXPRESS:Buffer Manager\Lazy writes/sec</Counter>

    		<Counter>\MSSQL$SQLEXPRESS:Memory Manager\Total Server Memory (KB)</Counter>

    		<Counter>\Process(sqlservr)\Working Set</Counter>

    		<Counter>\Processor(_Total)\% Privileged Time</Counter>

    		<Counter>\Processor(_Total)\% User Time</Counter>

    		<Counter>\System\Processor Queue Length</Counter>

    		<CounterDisplayName>\MSSQL$SQLEXPRESS:Buffer Manager\Buffer cache hit ratio</CounterDisplayName>

    		<CounterDisplayName>\MSSQL$SQLEXPRESS:Buffer Manager\Database pages</CounterDisplayName>

    		<CounterDisplayName>\MSSQL$SQLEXPRESS:Buffer Manager\Page reads/sec</CounterDisplayName>

    		<CounterDisplayName>\MSSQL$SQLEXPRESS:Buffer Manager\Page writes/sec</CounterDisplayName>

    		<CounterDisplayName>\MSSQL$SQLEXPRESS:Buffer Manager\Checkpoint pages/sec</CounterDisplayName>

    		<CounterDisplayName>\MSSQL$SQLEXPRESS:Buffer Manager\Lazy writes/sec</CounterDisplayName>

    		<CounterDisplayName>\MSSQL$SQLEXPRESS:Memory Manager\Total Server Memory (KB)</CounterDisplayName>

    		<CounterDisplayName>\@>F5AA(sqlservr)\ 01>G89 =01>@</CounterDisplayName>

    		<CounterDisplayName>\@>F5AA>@(_Total)\% @01>BK 2 ?@828;538@>20==>< @568<5</CounterDisplayName>

    		<CounterDisplayName>\@>F5AA>@(_Total)\% @01>BK 2 ?>;L7>20B5;LA:>< @568<5</CounterDisplayName>

    		<CounterDisplayName>\!8AB5<0\;8=0 >G5@548 ?@>F5AA>@0</CounterDisplayName>

    	</PerformanceCounterDataCollector>

    	<DataManager>

    		<Enabled>0</Enabled>

    		<CheckBeforeRunning>0</CheckBeforeRunning>

    		<MinFreeDisk>0</MinFreeDisk>

    		<MaxSize>0</MaxSize>

    		<MaxFolderCount>0</MaxFolderCount>

    		<ResourcePolicy>0</ResourcePolicy>

    		<ReportFileName>report.html</ReportFileName>

    		<RuleTargetFileName>report.xml</RuleTargetFileName>

    		<EventsFileName>

    		</EventsFileName>

    	</DataManager>

    </DataCollectorSet>

(11-11/13)

Project

General

Profile

Support » Поддержка Digispot II

Пример использования PerfMon » perfmon-sql-domain.xml