Perfmon Counter Templates – SharePoint Server, Project Server and SQL Server

By




               When we run into issues and need further investigation to troubleshoot the root cause we look up to getting Servers and Database statistics. Always I look forward to gather as much data from Performance Counters. These counters are specific to application and Operating system and as a SharePoint Admins we need to gather data which makes sense and the following counters had been very helpful for up in such instances.
Every Situation is different and we need to add counters which are necessary and apt for that situation and below are one which I use most of the time for SharePoint and Project Server and while working with Microsoft we got these templates to collect the counters. I also uploaded these templates which you can download at:
SharePoint Server and Project Server Counters:


\Processor(*)\% Processor Time
  \Network Interface(*)\Bytes Total/sec
  \Network Interface(*)\Current Bandwidth
  \System\Processor Queue Length
  \Processor(*)\% Privileged Time
  \PhysicalDisk(*)\Avg. Disk sec/Read
  \PhysicalDisk(*)\Avg. Disk sec/Write
  \LogicalDisk(*)\Avg. Disk sec/Read
  \LogicalDisk(*)\Avg. Disk sec/Write
  \Memory\Free System Page Table Entries
  \Memory\Pool Nonpaged Bytes
  \Memory\Pool Paged Bytes
  \Memory\Available MBytes
  \Memory\Pages/sec
  \Network Interface(*)\Output Queue Length
  \Processor(_Total)\% Processor Time
  \Processor(_Total)\% Privileged Time
  \System\Context Switches/sec
  \Process(*)\Private Bytes
  \Process(*)\Handle Count
  \Process(*)\Thread Count
  \Process(*)\% Processor Time
  \Process(*)\Virtual Bytes
  \LogicalDisk(C:)\Free Megabytes
  \Processor(*)\% Interrupt Time
  \Process(*)\Working Set
  \Memory\System Cache Resident Bytes
  \Process(*)\IO Data Operations/sec
  \Process(*)\IO Other Operations/sec
  \LogicalDisk(*)\Disk Transfers/sec
  \Memory\Pages Input/sec
  \Paging File(*)\% Usage
  \Paging File(*)\% Usage Peak
  \ASP.NET Apps v2.0.50727(*)\Request Execution Time
  \ASP.NET Apps v2.0.50727(*)\Requests/Sec
  \ASP.NET Apps v2.0.50727(*)\Requests In Application Queue
  \ASP.NET(*)\Worker Process Restarts
  \SQLServer:Locks(*)\Average Wait Time (ms)
  \SQLServer:Locks(*)\Number of Deadlocks/sec
  \SQLServer:Access Methods(*)\Full Scans/sec
  \SQLServer:General Statistics(*)\User Connections
  \SQLServer:Cache Manager(*)\Cache Hit Ratio
  \SharePoint Publishing Cache(*)\Publishing cache flushes / second
  \SharePoint Publishing Cache(*)\Publishing cache hit ratio
  \SharePoint Publishing Cache(*)\Publishing cache misses / sec
\SharePoint Foundation(*)\Sql Query Executing  time 
\SharePoint Foundation(*)\Executing Sql Queries 
\SharePoint Foundation(*)\Responded Page Requests Rate 
\SharePoint Foundation(*)\Executing Time/Page Request 
\SharePoint Foundation(*)\Current Page Requests 
\SharePoint Foundation(*)\Reject Page Requests Rate 
\SharePoint Foundation(*)\Incoming Page Requests Rate 
\SharePoint Foundation(*)\Active Threads
  \.NET CLR Exceptions(*)\# of Exceps Thrown / sec
  \Web Service(_Total)\Connection Attempts/sec
  \.NET CLR Loading(*)\Current appdomains
  \ASP.NET Applications(*)\Request Execution Time
  \ASP.NET Applications(*)\Requests Queued
  \.NET CLR Memory(*)\# Bytes in all Heaps
  \ASP.NET Applications(*)\Application Restarts
  \ProjectServer:QueueGeneral(*)\% Sql Retries / Day
  \ProjectServer:QueueGeneral(*)\% Sql Retries / Hour
  \ProjectServer:QueueGeneral(*)\Active Job Processing Threads
  \ProjectServer:QueueGeneral(*)\Average Unprocessed Jobs / Day
  \ProjectServer:QueueGeneral(*)\Current Unprocessed Jobs
  \ProjectServer:QueueGeneral(*)\New Jobs / Minute
  \ProjectServer:QueueGeneral(*)\Sql Calls / Hour/Day
  \ProjectServer:QueueGeneral(*)\Sql Calls / Minute
  \ProjectServer:QueueGeneral(*)\Sql Retries / Minute
  \ProjectServer:QueueJobs(*)\% Jobs Failed / Day
  \ProjectServer:QueueJobs(*)\% Jobs Failed / Hour
  \ProjectServer:QueueJobs(*)\% Jobs Retried / Day
  \ProjectServer:QueueJobs(*)\% Jobs Retried / Hour
  \ProjectServer:QueueJobs(*)\Average Processing Time / Day
  \ProjectServer:QueueJobs(*)\Average Processing Time / Minute
  \ProjectServer:QueueJobs(*)\Average Wait Time / Day
  \ProjectServer:QueueJobs(*)\Average Wait Time / Minute
  \ProjectServer:QueueJobs(*)\Jobs Failed / Minute
  \ProjectServer:QueueJobs(*)\Jobs Processed / Hour/Day
  \ProjectServer:QueueJobs(*)\Jobs Processed / Minute
  \ProjectServer:QueueJobs(*)\Jobs Retried / Minute
  \ProjectServer:User Activity\PSI Calls per Second
  \ProjectServer:Winproj\Average time taken for Project Open
  \ProjectServer:Winproj\Percentage of incremental save to full save
  \ProjectServer:Winproj\Winproj full open count in the last hour
  \ProjectServer:Winproj\Winproj full save count in the last hour
  \ProjectServer:Winproj\Winproj incremental open count in the last hour
  \ProjectServer:Winproj\Winproj incremental save count in the last hour
\InfoPath Forms Services 14(_Total)\# Business Logic Assemblies in Memory 
\InfoPath Forms Services 14(_Total)\# of Forms in Memory 
\InfoPath Forms Services 14(_Total)\# of Form Templates in Memory 
\InfoPath Forms Services 14(_Total)\# of Cached Form Templates 
\InfoPath Forms Services 14(_Total)\Data Connection Query Failure Rate 
\InfoPath Forms Services 14(_Total)\Data Connection Query Completed Rate 
\InfoPath Forms Services 14(_Total)\Avg. Data Adapter Query Duration 
\InfoPath Forms Services 14(_Total)\Data Connection Submit Failure Rate 
\InfoPath Forms Services 14(_Total)\Data Connection Submit Completed Rate 
\InfoPath Forms Services 14(_Total)\Data Connection Submit Started Rate 
\InfoPath Forms Services 14(_Total)\Avg. Data Connection Submit Duration 
\InfoPath Forms Services 14(_Total)\Session Completed Rate 
\InfoPath Forms Services 14(_Total)\Session Started Rate 
\InfoPath Forms Services 14(_Total)\Avg. Session Duration 
\InfoPath Forms Services 14(_Total)\Transactions Completed Rate 
\InfoPath Forms Services 14(_Total)\Transactions Started Rate 
\InfoPath Forms Services 14(_Total)\Avg. Transaction Duration 
 \Memory\Committed Bytes
 \Memory\Commit Limit
 \Memory\% Committed Bytes In Use
SQL Server Perfmon Counters Template:
\LogicalDisk(*)\*
\Memory\*
\Network Interface(*)\*
\Paging File(*)\*
\PhysicalDisk(*)\*
\Process(*)\*
\Processor(*)\*
\SQLServer:Access Methods\*
\SQLServer:Backup Device(*)\*
\SQLServer:Broker Activation(*)\*
\SQLServer:Broker Statistics\*
\SQLServer:Broker/DBM Transport\*
\SQLServer:Buffer Manager\*
\SQLServer:Buffer Node(*)\*
\SQLServer:Buffer Partition(*)\*
\SQLServer:Catalog Metadata(*)\*
\SQLServer:CLR\*
\SQLServer:Cursor Manager by Type(*)\*
\SQLServer:Cursor Manager Total\*
\SQLServer:Databases(*)\*
\SQLServer:Database Mirroring(*)\*
\SQLServer:Exec Statistics(*)\*
\SQLServer:General Statistics\*
\SQLServer:Latches\*
\SQLServer:Locks(*)\*
\SQLServer:Memory Manager\*
\SQLServer:Plan Cache(*)\*
\SQLServer:Replication Agents(*)\*
\SQLServer:Replication Dist(*)\*
\SQLServer:Replication Logreader(*)\*
\SQLServer:Replication Snapshot(*)\*
\SQLServer:Replication Merge(*)\*
\SQLServer:SQL Errors(*)\*
\SQLServer:SQL Statistics\*
\SQLServer:Transactions\*
\SQLServer:User Settable(*)\*
\SQLServer:Wait Statistics(*)\*
\System\*
\Thread(*)\*


Comments

Post a Comment