Cassandra 1.1.2 & above versions authorization and authentication

Note :  If you are setup on Cassandra Cluster 

BPM Capacity planning - general guidelines

Recommendations:

1. Investigate the root cause of poor performing transactions in current environment. Assess optimization capabilities to speed up processing.

Multi Node Cassandra setup on Ubuntu

Multi node Cassandra setup: On two ubuntu 12.04 vm's  

Performance problems in IBM Business Process Manager (BPM)

Getting an overall picture of the performance issue

Performance issues involve many aspects: IBM Business Process Manager server, application, database, outside connectors, network, and other variables. After the scope of the issue is narrowed, tuning can start and then performance is tested again to find the next bottleneck.

Reading and decoding instrumentation files

Instrumentation .dat files are compacted binary files that can be read only after they are decoded.

How do I start instrumentation logging?
Complete the following steps: 

1. Log into the Process Admin Console as a user in the tw_admins group, such as tw_admin or admin.
   
   For example:
   http://server_name:port_number/ProcessAdmin 

MS SQL Server Tuning and Tips

Server Configuration:

The performance gains that were seen after applying these techniques and configuration parameters were applied on a Database server with the following configuration

Windows Server 2008 64 bit

32 Gig of Ram

8 Processors

Microsoft SQL Server 2008 R2

Log Detail Levels​ to troubleshoot different issues

1.Set the trace string to the following value logs the SQL queries that are run in the background

How to enable jdbc debug version

Download the driver with "_g" prefix and follow the below steps.

http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-112010-090769.html