Tuesday, November 30, 2010

Informix Replication

It appears that this process has completed as of 11:10 pm MST (2:10 am AST.)

Here are my observations and recommendations.

1.) The session thread was doing quite a bit of sleeping. This normally
occurs when control is handed off to another thread. The session information did not show any other sub-threads for this session. It appears that the thread was waiting for the commit response from the secondary.

Currently, the two servers are configured for synchronous mode. That means that the transaction will not commit on the primary until it gets the commit response back from the secondary. With any network latency, this can be quite slow during bulk processes. It is more apt to be up to date though.

2.) I saw the session wait for a logical log buffer quite often. Not
near as it was sleeping (which was 90% of the time), but it happened often enough to be looked at.

My recommendations:

Change DRINTERVAL from -1 to 0. This will disable synchronous mode with HDR and will go to asynchronous. This is much better for performance as the primary will no longer have to wait for the secondary server to acknowledge to transaction before moving on. Checkpoints are still done synchronously.

Increase LOGBUFF setting from 32 to 64. This will increase the logical log buffers and prevent processes from waiting for them as often as they did.

New SQL Server Customer

We are excited to report that we have added another new customer to our SQL Server support services. This new customer is based out of New York, NY and also with operations in Europe. Customer provides full service online market research solutions. They develop and implement new tools and technologies to provide fast, meaningful and actionable insights via more efficient and engaging consumer experiences.

This customer chose Xtivia as the best of breed support organization to assist them as they require 24x7 availability as well as needing assistance with implementing and managing replication.

Monday, November 29, 2010

Xtivia is getting ready for the Holidays

I returned to our Colorado office this week after being out visiting customers and working trade shows the last month. It was nice to see the office decorated for the Christmas Holiday.

This Friday we have the Xtivia Colorado Potluck Dinner and as I understand it, Santa himself is coming from the North Pole.

Practice Manager Tony Salerno visits Colorado Springs

This week we will have Tony Salerno our Database Practice Manager working in the Colorado Springs Office. As Tony works out of NJ we don’t get to see him to often so will be nice to have him here with his team.

I think he is staying through Friday night so he will be able to join us for the potluck dinner on Friday.

US-CERT Technical Cyber Security Alerts