Siebel/Boldfish ES Performance Degradation

[KarynAngel]

Siebel acquired Boldfish ES (email broadcast utility) earlier this year. My company invested in the service & purchased 3 new robust servers to work with the application (one to run the Boldfish ES, one to run SQL Server, and an IronPort email server). After 2 months of use we are experiencing a sever performance degradation seen prominently with the Web GUI interface.

In my limited SQL knowledge, without a seasoned DBA in our company, monitoring concludes that JAVA pushes trigger updates to the internal database (installed & configured to Boldfish tech support's recommendations), and those background updates are blocking front-end user activity on the Web interface. CPU usage on the SQL Server machine is often way over 40%, with 4 processors, 2 hard drives and over 2GB of RAM!

Siebel/Boldfish tech support seems to be stumped & ill-prepared to analyze SQL Server performance, as they claim most of their clients use Oracle (even though we were assured at purchase that SQL was an equally acceptable choice). They recommend changing the database configurations for their internal database, but can't provide me with any recommendations. I ran a trace and used it with the Index Tuning Wizard, without any noticable improvement.

Does anyone else use Siebel's Boldfish ES? Has anyone else experiences problems similar to this? I appreciate any help offered!

KarynAngel

 

[walkerci]

KarynAngel,

Sounds like the problem is around SQL Server tuning.
I don't have any information that would indicate that Oracle would provide any improvement.

Suggest you take a look at Spotlight On SQLServer from Quest Software. quest.com.

This is a good tool to understand what is going on inside SQL Server and provides tuning recommendations.

No, I don't work for Quest.

Good luck!

Charles