Archive for December, 2009
Thursday, December 10th, 2009
SQL Server 2008 TuningFor an OLTP workload, start with the following advanced SQL Server 2008tuning recommendations. Some are from Microsoft, others are just good practices. Run these as queries in the Microsoft SQL Server Management Studio UI:USE masterEXEC sp_configure 'show advanced options', 1RECONFIGURE WITH OVERRIDE(the above must be run first ...
Posted in Uncategorized | No Comments »
Wednesday, December 9th, 2009
bash-3.00# db2start05/15/2007 15:01:59 0 0 SQL5043N Support for one or more communications protocols failed to start successfully. However, core database manager functionality started successfully.SQL1063N DB2START processing was successful.look into db2diag.log:2007-05-15-15.01.58.846394-420 E92034A447 LEVEL: ErrorPID : 405708 TID : 1 PROC : db2sysc 0INSTANCE: db2inst1 NODE :
000FUNCTION: DB2 UDB, common communication, ...
Posted in Uncategorized | No Comments »
Monday, December 7th, 2009
An excellent tuning paper on IBM's developerWo=
rks on the topic of Servlet Caching:Servlet caching=0A=0A WebSphere Application Server=E2=80=99s DynaCache pro=
vides a general in-memory=0A caching service ...
Posted in Uncategorized | No Comments »
Wednesday, December 2nd, 2009
An article on IBM's developerWorks web sites shows some tips on tuningmessage-driven beans. In particular, a simple math model was given as follows:"We can build a simple mathematical model of the behaviour of concurrent MDB usage:
If we expect a transaction under normal circumstances to take t seconds to complete, and ...
Posted in Uncategorized | No Comments »