Perfwiz replacement for Exchange 2007

Here is a replacement for general Exchange 2007 Performance data gathering. Use this in place of Perfwiz.exe as this utility does not capture all of the counters needed to properly troubleshoot Exchange 2007 performance issues.

Follow the steps below to enable these performance counters on any given Exchange 2007 server

Windows 2003 version of Perfwiz

1. Extract the contents of Exchange_2007_Perfwiz.zip to your Exchange server.
2. Open Performance Monitor
3. Expand Performance Logs and Alerts and select Counter Logs.
4. Right click Counter logs and select "New Log Settings From". Select the htm file that was extracted in Step 1. Click OK
5. Select the Log Files tab and click the Configure button
6. For the Log location, change this to a location of your choice. Click Ok
7. Click OK to save the Performance Counter log.
8. To start the Perfmon log, right click "Exchange 2007 Perfwiz" and then select Start.
9. Let this run during the problem period where performance is affected
10. Stop the perfmon log by right-clicking "Exchange 2007 Perfwiz" and selecting Stop
11. Make arrangements with a CSS representative to get the files analyzed.

Windows 2008 version of Perfwiz

1. Download the appropriate version of Perfwiz for your server. Currently I have 2 versions.
   
   
   • Exchange 2007 Perfwiz (MBX-CAS-HUB specific) - This file has targeted counters instead of including all (*) counters for obvious performance reasons and easier parsing.
     
   • Exchange 2007 Perfwiz (All Counters). Use this at your own discretion as this will collect a *lot* of data which may decrease performance on an Exchange Server.
     
   • Other Role based XMLs are self-explanatory
     
     How to download 
     To download these XML files to your computer, right click the file of your choice, select Save Target As... , and then save it to a directory location of your choice on your Exchange Server
     
     Role Based
     Use these as a high level look in to how the server is performing and if  you need to branch out with more counters, use the Full Counter/Instance set below.
     
     Exchange_2007_Perfwiz-AIO.xml (HUB/CAS/MBX All-In-One)
     Exchange_2007_Perfwiz-CAS.xml
     Exchange_2007_Perfwiz-MBX.xml
     Exchange_2007_Perfwiz-HUB.xml
     Exchange_2007_Perfwiz-HUB-CAS.xml
     Exchange_2007_Perfwiz-UM.xml
     
     All Counters/All Instances
     Use this counter set at your own discretion as this could potentially cause performance degradation on your server trying to log this amount of counters.
     
     Exchange_2007_Perfwiz-Full.xml
     
     
2. Open Performance Monitor
3. Expand Reliability and Performance and then expand Data Collector Sets
4. Right click User Defined, Select New, and then Data Collector Set
5. Enter a unique name for this Data Collector set (ie. ExPerfwiz), select Create from a template (Recommended) and then click Next
6. Select the Browse button, navigate to the XML file that was saved in Step 1, select Open
7. Select Next on the next screen
8. Enter in a root Directory of where you would like to store the performance log files. Click Next
9. If you need to run this performance log under different credentials, enter it on this page. Click Finish

Recognition

I'd like to thank Ben Winzenz for creating the Windows 2008 *full* version of Perfwiz and John Rodriguez for getting me the counter sets for the All-In-One XML which I doctored up in a custom XML file. 

Updates
2/13/2009 - Updated all XML files to include counters from Monitoring Without System Center Operations Manager

9/28/2009 - Added TCPv4 and TCPv6 counters to all Perfwiz counter sets

10/15/2009 – Large update to the XML files. See below what has been added

Role: HUB, CAS, HUB-CAS, UM, MB, AIO

\Memory\*
\Netlogon(*)\*
\Process(*)\*
\Processor(*)\*
\Redirector\*
\Server\*
\System\*
\MSExchange ADAccess Domain Controllers(*)\LDAP Searches timed out per minute
\MSExchange ADAccess Domain Controllers(*)\Long running LDAP operations/Min
\MSExchange ADAccess Domain Controllers(*)\Number of outstanding requests
\MSExchange ADAccess Local Site Domain Controllers(*)\LDAP Read calls/Sec
\MSExchange ADAccess Local Site Domain Controllers(*)\LDAP Read Time
\MSExchange ADAccess Local Site Domain Controllers(*)\LDAP Search calls/Sec
\MSExchange ADAccess Local Site Domain Controllers(*)\LDAP Search Time
\MSExchange ADAccess Local Site Domain Controllers(*)\LDAP Searches timed out per minute
\MSExchange ADAccess Local Site Domain Controllers(*)\Long running LDAP operations/Min
\MSExchange ADAccess Local Site Domain Controllers(*)\Number of outstanding requests

Role: HUB, CAS, HUB-CAS, UM, AIO
\MSExchange Store Interface(*)\ConnectionCache num caches
\MSExchange Store Interface(*)\ConnectionCache out of limit creations
\MSExchange Store Interface(*)\ConnectionCache total capacity
\MSExchange Store Interface(*)\ExRPCConnection creation events
\MSExchange Store Interface(*)\ExRPCConnection disposal events
\MSExchange Store Interface(*)\ExRPCConnection outstanding

Role: CAS, HUB-CAS, AIO
\MSExchange OWA\AS Queries Failure %
\MSExchange OWA\Average Search Time
\MSExchange OWA\Failed Requests/sec
\MSExchange OWA\Logons/sec
\MSExchange OWA\Proxy Response Time Average
\MSExchange OWA\Proxy User Requests/sec
\MSExchange OWA\Store Logon Failure %

Full
Netlogon(*)\*
\MSExchange ADAccess Local Site Domain Controllers(*)\*

Windows 2003 version of Perfwiz for Exchange 2007
Netlogon(*)\*

10/21/2009 – Updated Database Instance Counters to include all instances. Affects AIO and MBX Role XML
11/4/2009 – Added the following Physical Disk Counters to all XML files.

\PhysicalDisk(*)\Avg. Disk Queue Length
\PhysicalDisk(*)\Avg. Disk sec/Read
\PhysicalDisk(*)\Avg. Disk sec/Write
\PhysicalDisk(*)\Disk Reads/sec
\PhysicalDisk(*)\Disk Transfers/sec
\PhysicalDisk(*)\Disk Writes/sec