ZB 04 sysmon报告解读V01.docx
《ZB 04 sysmon报告解读V01.docx》由会员分享,可在线阅读,更多相关《ZB 04 sysmon报告解读V01.docx(39页珍藏版)》请在冰豆网上搜索。
ZB04sysmon报告解读V01
===============================================================================
SybaseAdaptiveServerEnterpriseSystemPerformanceReport
===============================================================================
ServerVersion:
AdaptiveServerEnterprise/12.5.4/EBF14921ESD#7/P/RS60
ServerName:
tst_par2
RunDate:
Oct23,2014
SamplingStartedat:
Oct23,201411:
41:
16
SamplingEndedat:
Oct23,201412:
31:
16
SampleInterval:
00:
50:
00
SampleMode:
ResetCounters
===============================================================================
1.内核使用率:
KernelUtilization
------------------
YourRunnableProcessSearchCountissetto200
andI/OPollingProcessCountissetto10
1.1.EngineBusyUtilization
EngineBusyUtilizationCPUBusyI/OBusyIdle
------------------------------------------------
Engine059.6%0.3%40.1%
“EngineBusyUtilization”报告AdaptiveServer内核在每个AdaptiveServer引擎上忙于执行任务的时间(而非空闲时间)的百分比。
摘要行给出所有组合引擎的总活动时间和平均活动时间.
1.2.CPUYieldsbyEngine
CPUYieldsbyEnginepersecperxactcount%oftotal
--------------------------------------------------------------------
Engine024.71.573998100.0%
“CPUYieldsbyEngine”报告每个AdaptiveServer引擎让位于操作系统的次数。
“%oftotal”数据是一个引擎的放弃次数占所有引擎的组合放弃次数的百分比。
1.3.NetworkChecks
Non-Blocking336.219.9100863393.3%
Blocking24.11.4722486.7%
-----------------------------------------------------------
TotalNetworkI/OChecks360.321.31080881
AvgNetI/OsperCheckn/an/a0.20608n/a
“NetworkChecks”包括以下相关信息:
阻塞和非阻塞网络I/O检查、间隔期间进行的I/O检查的总数以及每次网络检查的网络I/O的平均数。
AdaptiveServer具有两种检查网络I/O的方法:
阻塞模式和非阻塞模式。
1.4.DiskI/OChecks
TotalDiskI/OChecks370.321.91110778n/a
ChecksReturningI/O186.211.055847450.3%
AvgDiskI/OsReturnedn/an/a0.12350n/a
此部分报告磁盘I/O检查的总数,以及返回I/O的检查数量。
===============================================================================
2.工作进程管理:
WorkerProcessManagement
-------------------------
persecperxactcount%oftotal
--------------------------------------------
WorkerProcessRequests
TotalRequests0.00.00n/a
WorkerProcessUsage
TotalUsed0.00.00n/a
MaxEverUsedDuringSample0.00.00n/a
MemoryRequestsforWorkerProcesses
TotalRequests0.00.00n/a
===============================================================================
3.并行查询管理:
ParallelQueryManagement
-------------------------
ParallelQueryUsagepersecperxactcount%oftotal
---------------------------------------------------------------------
TotalParallelQueries0.00.00n/a
MergeLockRequestspersecperxactcount%oftotal
---------------------------------------------------------------------
Total#ofRequests0.00.00n/a
SortBufferWaitspersecperxactcount%oftotal
---------------------------------------------------------------------
Total#ofWaits0.00.00n/a
===============================================================================
4.任务管理:
TaskManagement
TaskManagementpersecperxactcount%oftotal
-----------------------------------------------------------------------
ConnectionsOpened0.00.07n/a
TaskContextSwitchesbyEngine
Engine045.12.7135404100.0%
TaskContextSwitchesDueTo:
VoluntaryYields9.40.62809720.8%
CacheSearchMisses1.00.128862.1%
SystemDiskWrites0.10.02940.2%
I/OPacing7.60.52284316.9%
LogicalLockContention1.10.134322.5%
AddressLockContention0.70.020891.5%
LatchContention0.50.014481.1%
LogSemaphoreContention1.20.137452.8%
PLCLockContention0.30.07650.6%
GroupCommitSleeps11.20.73357224.8%
LastLogPageWrites3.80.2114978.5%
ModifyConflicts0.60.018291.4%
I/ODeviceContention0.00.000.0%
NetworkPacketReceived3.40.2101717.5%
NetworkPacketSent0.80.023221.7%
OtherCauses3.50.2104147.7%
===============================================================================
5.应用程序管理:
ApplicationManagement
----------------------
ApplicationStatisticsSummary(AllApplications)
-------------------------------------------------
PriorityChangespersecperxactcount%oftotal
---------------------------------------------------------------------
ToHighPriority3.80.21133138.4%
ToMediumPriority4.90.31477450.0%
ToLowPriority1.10.1343611.6%
-----------------------------------------------------------
TotalPriorityChanges9.80.629541
AllottedSlicesExhaustedpersecperxactcount%oftotal
---------------------------------------------------------------------
HighPriority0.00.000.0%
MediumPriority2.40.17307100.0%
LowPriority0.00.000.0%
-----------------------------------------------------------
TotalSlicesExhausted2.40.17307
SkippedTasksByEnginepersecperxactcount%oftotal
---------------------------------------------------------------------
TotalEngineSkips0.00.00n/a
EngineScopeChanges0.00.07n/a
===============================================================================
6.ESP管理:
ESPManagement
ESPManagementpersecperxactcount%oftotal
-----------------------------------------------------------------------
ESPRequests0.00.00n/a
===============================================================================
7.管家任务管理:
HousekeeperTaskActivity
-------------------------
persecperxactcount%oftotal
----------------------------------
BufferCacheWashes
Clean20.01.26009898.4%
Dirty0.30.010061.6%
----------------------------------
TotalWashes20.41.261104
GarbageCollections0.50.01366n/a
PagesProcessedinGC0.20.0560n/a
StatisticsUpdates0.50.01362n/a
===============================================================================
8.对执行SQL的监控访问:
MonitorAccesstoExecutingSQL
-------------------------------
persecperxactcount%oftotal
--------------------------------------------
WaitsonExecutionPlans0.00.00n/a
NumberofSQLTextOverflows0.00.00n/a
MaximumSQLTextRequestedn/an/a0n/a
(sincebeginningofsample)
===============================================================================
9.事务配置文件:
TransactionProfile
-------------------
TransactionSummarypersecperxactcount%oftotal
---------------------------------------------------------------------
CommittedXacts16.9n/a50646n/a
TransactionDetailpersecperxactcount%oftotal
---------------------------------------------------------------------
Inserts
APLHeapTable5.50.31642813.0%
APLClusteredTable21.61.36471251.2%
DataOnlyLockTable15.10.94526135.8%
---------------------------------------------------------------------
TotalRowsInserted42.12.512640157.1%
Updates
APLDeferred0.00.000.0%
APLDirectIn-place0.00.000.0%
APLDirectCheap0.00.000.0%
APLDirectExpensive0.00.000.0%
DOLDeferred0.00.000.0%
DOLDirect11.40.734216100.0%
---------------------------------------------------------------------
TotalRowsUpdated11.40.73421615.5%
DataOnlyLockedUpdates
DOLReplace5.40.31627847.6%
DOLShrink0.10.02520.7%
DOLCheapExpand1.10.131539.2%
DOLExpensiveExpand4.60.31374940.2%
DOLExpand&Forward0.30.07842.3%
DOLFwdRowReturned0.00.000.0%
---------------------------------------------------------------------
TotalDOLRowsUpdated11.40.73421615.5%
Deletes
APLDeferred18.51.15563891.7%
APLDirect0.80.025294.2%
DOL0.80.025294.2%
---------------------------------------------------------------------
TotalRowsDeleted20.21.26069627.4%
===========================================================
TotalRowsAffected73.84.4221313
===============================================================================
10.事务管理:
TransactionManagement
----------------------
ULCFlushestoXactLogpersecperxactcount%oftotal
---------------------------------------------------------------------
byFullULC2.70.281797.6%
byEndTransaction17.71.05298049.1%
byChangeofDatabase0.90.125582.4%
bySingleLogRecord9.10.52719525.2%
byUnpin4.30.31304312.1%
byOther1.30.138843.6%
-----------------------------------------------------------
TotalULCFlushes35.92.1107839
ULCLogRecords185.411.0556284n/a
MaxULCSizeDuringSamplen/an/a2048n/a
ULCSemaphoreRequests
Granted375.622.2112665699.9%
Waited0.30.07650.1%
-----------------------------------------------------------
TotalULCSemaphoreReq375.822.31127421
LogSemaphoreRequests
Granted32.01.99587896.2%
Waited1.20.137453.8%
-----------------------------------------------------------
TotalLogSemaphoreReq33.22.099623
TransactionLogWrites14.90.944766n/a
TransactionLogAlloc11.00.733112n/a
Avg#WritesperLogPagen/an/a1.35196n/a
TuningRecommendationsforTransactionManagement
-------------------------------------------------
-Considerdecreasingthe'userlogcachesize'
configurationparameterifitisgreaterthanthe
logicaldatabasepagesize.
===============================================================================
11.索引管理:
IndexManagement
----------------
NonclusteredMaintenancepersecperxactcount%oftotal
---------------------------------------------------------------------
Ins/UpdRequ