Starschema

It's not enough from a decision suppport system to just produce the information. The business procedures often demands the prompt access of data, for example detecting a bankcard fraud, or a routeplan distribution for the sales force, or tracking the stock information of a logisics system. The production of data is a race, where only the well designed and efficient IT systems can meet the business requirements.

The performance analysis and optimization is separated territory within the implementation of business intelligence projects and operating already handed over systems, which requires special skills and experiences. Storing a constantly growing datasets which often size up to several terrabytes, or a change in the user-control behaviour arisen through the widening business needs can easily effect the performance.

The solution of the problem could be the optimization of the extant codes, definition of new indexes, partitions or aggregations, modification of certain tasks execution plan, optimal multiprocessing of the procedures.

The engineers at Starschema following the best practises of the industry can provide you the following performance analysis and optimization services:

• Estimating and optimizing the database side performance of systems with transactional or data warehouse characteristics
• Complex performance analysis of the used hardware elements (SAN, servers, cluster nodes, thick and thin clients)
• Tracking and monitoring expexted service levels, generating alerts based on performance
• Operational trainings