Articles in this section

Q-Pulse Application Server Optimisation

Michael McAleer
  • Updated
Follow

There are 2 configurations that can be made to the application server configuration to ensure optimal performance:


Set/Increase the SQL Command Timeout

All of the Q-Pulse data is held in a SQL database.  When the information displayed in Q-Pulse is changed, the application will automatically perform SQL operations to update the data on the SQL server.  While this is being performed, the default SQL timeout options will determine how long these operations will run for.  

Increasing the timeout is recommended if:

  • There is a large geographical distance between the application server and database server which may result in a delay carrying out tasks
  • The SQL server hosts various other databases which may result in slower performance
  • The user will be carrying out actions that require complex calculations to be performed (e.g. restructuring large managed lists)

To set the SQL command timeout: For Version 6 and below

  1. On the application server, browse to the Q-Pulse web site folder.  By default, this will be C:\inetpub\wwwroot\QPulse5
  2. Locate and open web.config with Notepad
  3. Add a new entry to the <appSettings> section:
<add key="SqlCommandTimeout" value="120"/>

The value of the SqlCommandTimeout is in seconds and can be changed as needed.
  1. Save the web.config.
Benefits of Configuration Details
Control Over SQL Timeout The time allowed for SQL commands to be performed can be controlled by IT.
Additional Time to Perform Tasks The time can be increased to allow more complicated actions to be performed in SQL (e.g. moving managed list items will require a recalculation of the list path).

 

To set the SQL command timeout: For Versions 6-6.2

  1. On the application server, browse to the Q-Pulse web site folder.  By default, this will be C:\inetpub\wwwroot\QPulse
  2. Locate and open web.config with Notepad
  3. Add a new entry to the <appSettings> section:
<add key="SqlCommandTimeout" value="120"/>

The value of the SqlCommandTimeout is in seconds and can be changed as needed.
  1. Save the web.config.
Benefits of Configuration Details
Control Over SQL Timeout The time allowed for SQL commands to be performed can be controlled by IT.
Additional Time to Perform Tasks The time can be increased to allow more complicated actions to be performed in SQL (e.g. moving managed list items will require a recalculation of the list path).

 

To set the SQL command timeout: For Version 6.5 and above

  1. On the application server, browse to the Q-Pulse web site folder.  By default, this will be C:\inetpub\wwwroot\QPulseDataPortal
  2. Locate and open web.config with Notepad
  3. Add a new entry to the <appSettings> section:
<add key="SqlCommandTimeout" value="120"/>

The value of the SqlCommandTimeout is in seconds and can be changed as needed.
  1. Save the web.config.
Benefits of Configuration Details
Control Over SQL Timeout The time allowed for SQL commands to be performed can be controlled by IT.
Additional Time to Perform Tasks The time can be increased to allow more complicated actions to be performed in SQL (e.g. moving managed list items will require a recalculation of the list path).

 


Switch Off Authenticode Verification

In older versions of Q-Pulse (versions 5.51 to 5.90), the start-up process required authenticode verification.  In order to do this, the application server will connect to the internet so that various file assemblies can be verified.  This verification process can have a negative impact on the product in environments where network performance may be an issue and may prolong the log on process.

 
The verification process can be skipped in .NET 3.5 by updating your aspnet.config file. 

Important Note: This is a global setting and this change will affect all ASP.NET applications running on this server.  If you have other ASP.NET applications hosted on this server please ensure that this setting is appropriate and that it will not impact the other applications.  You can read more about the generatePublisherEvidence element on the MSDN webpage.
 
To switch off the authenticode verification:
  1. Browse to %systemroot%\Microsoft.NET\Framework\v2.0.50727 and open the aspnet.config file in notepad.
  2. Add the line below within the <runtime> element:
<generatePublisherEvidence enabled="false"/>
  1. The contents of the file should look similar to the following:
<?xml version="1.0" encoding="UTF-8" ?>
<configuration>
  <runtime>
    <legacyUnhandledExceptionPolicy enabled="false" />
    <legacyImpersonationPolicy enabled="true"/>
    <alwaysFlowImpersonationPolicy enabled="false"/>
    <SymbolReadingPolicy enabled="1" />
    <generatePublisherEvidence enabled="false"/>
  </runtime>
</configuration>
 
If any issues are identified by applying this configuration you can roll back the change by removing thegeneratePublisherEvidence line from the aspnet.config file.
 
Benefits of Configuration Details
Faster Product Login The speed of the username and password box being displayed is increased.
 

Set Chunk Size When Uploading and Downloading Attachments

Important Note: This section can only be implemented in Q-Pulse version 6.2 or later. 

Some customers may experience issues when downloading and uploading attachments from Q-Pulse. Especially over the internet or slow networks. Currently in Q-Pulse the default chunk size is 128KB, however this can be increased by adding the tags found below to the web.config file for the Q-Pulse Dataportal. 

Increasing the Chunk Size: For Version 6 and below

     1. Browse to the Q-Pulse Dataportal web.config file. By default, this config file is stored in C:\inetpub\wwwroot\QPulse5.

     2. Within the <appSettings></appSettings> tags, add following keys to increase the upload and download chunk size to 2MB. 
     
<add key="DownloadChunkSize" value="2097152"/>
<add key="UploadChunkSize" value="2097152"/>
 
Benefits of Configuration Details
Faster Download and Upload of Documents The speed in which Documents are download/uploaded to and from the client will be increased. 

 Increasing the Chunk Size: For Version 6-6.2

     1. Browse to the Q-Pulse Dataportal web.config file. By default, this config file is stored in C:\inetpub\wwwroot\QPulse.

     2. Within the <appSettings></appSettings> tags, add following keys to increase the upload and download chunk size to 2MB. 
     
<add key="DownloadChunkSize" value="2097152"/>
<add key="UploadChunkSize" value="2097152"/>
 
Benefits of Configuration Details
Faster Download and Upload of Documents The speed in which Documents are download/uploaded to and from the client will be increased. 
 
Increasing the Chunk Size: Version 6.5 and above

     1. Browse to the Q-Pulse Dataportal web.config file. By default, this config file is stored in C:\inetpub\wwwroot\QPulseDataportal

     2. Within the <appSettings></appSettings> tags, add following keys to increase the upload and download chunk size to 2MB. 
     
<add key="DownloadChunkSize" value="2097152"/>
<add key="UploadChunkSize" value="2097152"/>
 
Benefits of Configuration Details
Faster Download and Upload of Documents The speed in which Documents are download/uploaded to and from the client will be increased. 

Related articles

Comments

0 comments

Please sign in to leave a comment.