Thursday, 14 August 2008

Oracle OpenWorld 2008


I will be presenting two sessions at this years Oracle OpenWorld 2008 event in San Francisco.

I will be giving a live demo of how to setup a Synchronous Message and Web Service in PeopleSoft 8.49 and also highlighting and discussing many of the PeopleSoft timeout and cache settings available.

More details can be found here at the Session Builder

Tuesday, 12 August 2008

Fix to serious SQL Server Performance Problems

You'll see from an earlier post I made back in  March 2008 (http://i-like-trains.blogspot.com/2008/03/upgrading-to-microsoft-sql-server-2005.html) that after an upgrade from SQL Server 2000 to 2005 many serious performance problems were encountered.

After a massive amount of testing and research I believe most of the issues are resolved by applying two Microsoft hotfixes.

http://support.microsoft.com/kb/951184/

and

http://support.microsoft.com/kb/946793/en-us

These cannot be applied individually and are only available as part of a Cumulative Update package. CU Package 7 contains both of these fixes.

However, just installing CU7 will not activate these hotfixes and a two trace flags need to be set in order for any benefit to be seen.

They are

DBCC TRACEON (212,-1) 
and
DBCC TRACEON (4115,-1)

We are in the process of regression testing to make sure that CU7 does not break anything and that these hotfixes resolve most of our most serious performance problems.  So far it's looking hopeful.