Databases Reference
In-Depth Information
tion allows customer service representatives to update the personal information
of clients, including bank account information if the client pays his monthly bill
with automatic draft. All the applications within the company must adhere to
strict privacy and security requirements.
Environment Details
The environment details are as follows:
•
The application is ODBC.
•
The database server is Sybase Adaptive Server Enterprise 11.5 running on
Windows.
•
The client machines are running on HP-UX PA-RISC.
•
The application is deployed in a WAN environment.
•
The application is using distributed transactions to make sure that different
databases stay consistent with one another.
•
CPU and memory are plentiful on the database server.
Following is the connection string for the DataDirect Technologies ODBC
driver in the production environment:
DataSourceName=MySybaseTables;NetworkAddress=123.456.78.90,
5000;DataBase=SYBACCT;LogonID=JOHN;Password=XYZ3Y;
ApplicationUsingThreads=1;EncryptionMethod=1;
HostNameInCertificate=#SERVERNAME#;TrustStorePassword=xxx2Z;
TrustStore=C:\trustfile.pfx;ValidateServerCertificate=1;
SelectMethod=0
Before deploying the application, the IT department ran performance
benchmarks on the application. The performance met the requirements, and the
application was deployed.
The Issue
After deploying the application, performance degraded by twofold. Why?
Here are some questions to ask:
•
Are there any differences between the test environment and the production
environment? For example, was the data in the test environment modeled
