VERIFIED SOLUTION i
X

Steps to setup perfmon for monitoring Sagent Data Flow 64-Bit on Windows 64-Bit Operating Systems

UPDATED: March 23, 2017


Steps to register Sagent performance counters for 64 bit Data Flow on 64 bit Windows Operating Systems:

1. Add the following registry keys:
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Sagent
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Sagent\Performance

2. In a command prompt, execute the following command: (to bring up a command prompt within Windows select the Start menu and choose Run. In the following window type "cmd" and hit Enter)
lodctr PERFMON.INI
This will create the required registry entries for Sagent Performance Counters.

3. Add the following DWORD entry to the registry on the server machine:
Name: Configuration Flags
Type: DWORD
Path: HLM\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Perflib
Value: 65536

4. In a command prompt, execute the following command to register the DLL and link it with the the registry entries created above:
regsvr32 SaPerfData.dll
Note - This regsvr32.exe should be from the location "C:\Windows\System32" as this is 64 bit DFS.

5. Delete the registry entry "Configuration Flags" created in Step 3.

6. Restart the Data Flow server

7. Use perfmon.exe from the location "C:\Windows\System32" for 64 bit DFS

Performance Counters will now run successfully

In order to remove the Sagent performance counters; in a command prompt, execute the following command:
unlodctr Sagent

NOTE: Create a plan which takes 40 seconds or longer to execute in order to observe the results of the performance counters.

Environment Details

Product Feature: DataFlow Server 64-Bit
Operating System: Windows 64bit
 

Downloads

  • No Downloads