How to resolve performance problem

If you notice that TargetProcess is rather slow on your server and you are not satisfied with the performance then you might want us to investigate the problem. We'd need the following information to speed up the investigation:

Performance Sheet
You may download this PDF file, fill it out with all required information and send to us.

Hardware and software specifications

- RAM
- CPU
- Windows
- IIS

Applications

Please, indicate which applications are running on your server along with TargetProcess. E.g. performance issues may be caused by some conflicts with SharePoints.

RAM and CPU Utilization

It is important to know RAM and CPU utilization on the server where TargetProcess is installed. You may check this with Performance Counter built in Windows by default. See “How to add custom counters to Performance Counter” section at the end of the document

Indicate where you notice TargetProcess to be slow

There may be problems on some certain pages or general slowness. To check this, navigate through TargetProcess application and check Page Generation Time. It looks like:

Page Generation Time -> Server: 0.27 | Client: 1.898

Plugins

Let us know which TargetProcess plugins are active and what's the sync time for plugin profiles.

Database backup

It might be required to check TargetProcess Database back-up for data-specific problems. Please apply the following script to remove security-sensitive data from the copy of the Database back-up you'd send to us:

update General set [Name] = 'Name' + CAST(GeneralID as varchar(10));
update General set Description = 'Description' + CAST(GeneralID as varchar(10));
update Comment set Description = 'Description' + CAST(CommentID as varchar(10));
UPDATE [TpUser]
SET [FirstName] = 'FirstName' + CAST(UserID as varchar(10))
,[LastName] = 'LastName' + CAST(UserID as varchar(10))
,[Email] = 'Email' + CAST(UserID as varchar(10))
,[Login] = 'Login' + CAST(UserID as varchar(10))
,[SecretWord] = 'SecretWord' + CAST(UserID as varchar(10))
,[ActiveDirectoryName] = 'ActiveDirectoryName' + CAST(UserID as varchar(10))
,[Phone] = 'Phone' + CAST(UserID as varchar(10))
,[Notes] = 'Notes' + CAST(UserID as varchar(10));
update Project set SCPassword = '', InboundMailPassword= '';
delete from TpProfile where PropertyName like '%InboundMailSettings';
delete from PluginProfile;

How to add custom counters to Performance Counter

Setup Performance Counters In Windows 2003

1. Open performance counter: Control panel – Administrative tools – Performance.

2. Add counter: Right Click on the list of counters under the graph.

3. Select performance objects and the counters for them as the following screen-shots show: Memory – pages per second.

Add counter for Processor - Processor Time as well.

Setup Performance Counters In Windows 7

1. Open performance counter: Start - Control Panel - System and Security – Administrative Tools.

2. Add counter. Right mouse-click on the list of counters under the graph.

3. Select performance objects and the counters for the Memory – pages per second. Select Memory object in the list of available counters. Double click the name of the performance object (Memory) or click once the arrow to the right of the name. You will see the list of counters for this object. Select Pages/sec counter and click Add button.

Add counter for Processor - Processor Time as well.