Data Warehouse Performance is optimum today! ">Customers are using Data Warehousing systems from large providers like Teradata, IBM, Oracle and HP as well as from various other vendors like NewGen, Vertica etc. Having data warehouse problems and failures? 鈥?Your data warehouse or BI architecture or reporting has changed 鈥?Your systems is slow or crashes because your business intelligence tool doesn 鈥檛 scale as users expect 鈥?Your data volumes have increased significantly 鈥?Your ETL (Extract, Transform and Load) process fails to achieve a complete loading Do you want to scale and tune your system for 25 Million transactions or 2 Million transactions? One major force driving the requirement for high availability in the data warehouse system is the use of analytics and Business Intelligence oriented functionality in OLTP applications, creating a highly use of the data warehouse as a source of information for the OLTP applications requiring high-performance queries. Most data warehouses are mission-critical, serving in an increasingly mixed workload capacity, including as a data source for online applications. 鈥 淒 eep mining 鈥?analysts and business analysts are running complex queries and fast-running tactical queries, each with differing service-level expectations driven by business users, customers and executives of their Company. These differing workloads are all competing for CPU, memory and disk access. At the same time, data latency continues to progress from batch to continuous loading demands. The complex mixed workload consists of: 鈥?Continuous data loading, similar to an OLTP workload 鈥?Batch data loading 鈥?Summary and aggregate management to support dashboards and prebuilt reports 鈥?Large numbers of standard reports ranging in the thousands per day requiring SQL tuning, index creation, new types of storage partitioning and other types of optimization structures in the data warehouse 鈥?Business analytics in which business process professionals with limited query language experience use prebuilt analytic data objects with aggregated data (pre-joins) and designated dimensional drill downs (summary) 鈥?An increasing number of query users with a random, unpredictable use of the data Automation, Performance and Scalability 鈥?The Business Intelligence tool is a customer-facing interface so it 鈥檚 the initial focus 鈥?Automate Regression testing of the Business Intelligence tool 鈥?Automate Performance/Scalability testing of the Business Intelligence tool 鈥?Performance may be an issue at the Data Warehouse or any other data source component 鈥?Characterize each source and subsystem 鈥檚 response under load Ensure your Data Warehouse Performance is optimum today!