PerfMonWindows性能监视器的使用说明.docx

以跟踪IIS应用程序中的数据库连接数为例运行 perfmance打开性能计数器管理界面。创建收集器集给收集器集取名字，设置成手动。选择要跟踪 “性能计数器”添加计数器。在.NET Data Provider for Oracle或.NET Data Provider for SqlServer中选择计数器：NumberOfPooledConnections为了避免IIS发生reset后，需要重新增加计数器，这里选择所有实例。最后确定。同时，你可以根据自己的需要添加CPU 内存或者磁盘等的相关监控。设置跟踪的停止时间，我一般设置跟踪一周。也可以根据需要调整。对于重现周期比较长的问题，比如月度等，可以设置总持续周期为5，如下图右键开始跟踪即可。跟踪状态从指定的路径可以获取跟踪文件分析。应用服务器需要关注的计数器性能对象计数器Processor%Processor Time?%Privileged TimeSystemProcessor Queue LengthMemoryAvailable MbytesPages/sec?Page faults/secPage File%Usage?%Peak Usage.NET Data Provider for Oracle/SqlserverNumberOfPooledConnections.NET CLR ExceptionsOf Exceps ThrownOf Exceps Thrown / sec.NET CLR LoadingCurrent AssembliesCurrent Classes LoadedTotal AssembliesTotal Classes Loaded.NET CLR MemoryBytes in all HeapsGC HandlesGen 0 CollectionsGen 1 CollectionsGen 2 CollectionsInduced GCTotal committed BytesTotal reserved Bytes数据库服务器需要关注的计数器性能对象计数器Processor%Processor Time?%Privileged TimeSystemProcessor Queue LengthMemoryAvailable MbytesPages/sec?Page faults/secPage File%Usage?%Peak UsagePhysicalDisk?%Disk Time?%Idle TimeAvg. Disk Queue LengthDisk Bytes/sec?Avg. disk sec/transfer?Avg. disk sec/read?Avg. disk write/secSQL Server: Memory ManagerTotal Server Memory(KB)?Target Server Memory(KB)SQL Server: BufferManagerBuffer Cach Hit RatioSQL Server: General StatisticsUser ConnectionsSQL Server: SQL StatisticsBatch Requests/secSQL Server: DatabasesTransaction/secData File(s) Size(KB)?Log File(s) Size(KB)?Log Growths