Database Performance Management

WHITE PAPER: This paper discusses how and why to design SQL that will reduce the number of times calls are made to DB2. We'll look at how to write SMART applications rather than writing applications that act like generic I/O modules to DB2, properly tune SMART SQL, and how to exploit SQL and application features in DB2 on z/OS version 8 and 9.

Posted: 30 Nov 2009 | Published: 30 Nov 2009

WHITE PAPER: This guidebook provides the answers with a series of detailed sections including essential activities such as planning, forecasting, risk management, team selection, communication and collaboration.

Posted: 04 Nov 2009 | Published: 04 Nov 2009

WHITE PAPER: Today’s data centers and cloud computing environments require increased I/O performance to support large-scale applications such as databases, web servers, e-commerce applications, file servers, and email. This whitepaper focuses on the performance benefits of using the Adaptec MaxIQ™ SSD Cache Performance Solution.

Posted: 02 Nov 2009 | Published: 02 Nov 2009

WHITE PAPER: This paper will help you understand the prospects that Postgres Plus RDBMS from EnterpriseDB and the JBoss Application Server from Red Hat can provide when used in combination.

Posted: 30 Oct 2009 | Published: 30 Oct 2009

WHITE PAPER: This paper details non-disruptive strategies for eliminating performance problems in existing data integration environments.

Posted: 29 Oct 2009 | Published: 29 Oct 2009

WHITE PAPER: Informational applications have become one of the most critical areas of IT activity. How will these challenges be met? This report examines an option -– use of IBM DB2 9.7 as an alternative to Oracle 11g -– that represents a major new opportunity for organizations to meet escalating demand while reducing IT costs.

Posted: 20 Oct 2009 | Published: 20 Oct 2009

WHITE PAPER: Many companies are considering Oracle R12 to help them thrive in the global business environment. But upgrading can affect the organization as a whole as well as processes and underlying technologies. To help you avoid costs and delays and take full advantage of the software, AT&T experts outline key steps for assessing your upgrade readiness.

Posted: 19 Oct 2009 | Published: 19 Oct 2009

WHITE PAPER: For processing data for BI analytics and other applications, the usual go-to software products include various extract, transform, load (ETL) and data warehousing solutions. However, these products do not always provide the speed required to deliver data on time. An additional product can speed the processing of high volumes of data.

Posted: 12 Oct 2009 | Published: 12 Oct 2009

WHITE PAPER: Alinean, a leader in IT value measurement, teamed up with HP and Novell to assess the financial merits of moving from a legacy Sun Solaris and SPARC environment to Novell SUSE Linux Enterprise Server (SLES) running on HP ProLiant DL 785 G6 x86 Servers versus upgrading to SUN Solaris 10 running on Sun SPARC T5440. Read this paper for the results.

Posted: 05 Oct 2009 | Published: 05 Oct 2009

WHITE PAPER: This white paper reviews the common causes of application downtime and discusses Oracle's Maximum Availability Architecture framework that provides clear and concise guidance on implementing best practices using Oracle's proven high availability technologies.

Posted: 25 Sep 2009 | Published: 25 Sep 2009

WHITE PAPER: Infinite Cache™ from EnterpriseDB revolutionizes distributed cache management on commodity blade server hardware by substantially increasing the amount of memory available to hold data including entire databases with outstanding performance.

Posted: 23 Sep 2009 | Published: 23 Sep 2009

WHITE PAPER: This paper describes a comprehensive set of best practices that allow mid-market enterprise SAP customers to appropriately configure and use HP management software to monitor, manage, and operate an SAP® environment.

Posted: 18 Sep 2009 | Published: 18 Sep 2009

WHITE PAPER: Application grid brings the same type of efficiency, scalability, and quality of service to the application layer that database clusters brings to the database layer. With an application grid you get greater efficiency, exceptional agility, and superior quality of service. Download this free white paper now.

Posted: 18 Sep 2009 | Published: 18 Sep 2009

WHITE PAPER: This white paper describes ways in which organizations can use Microsoft SQL Server 2008 to save time and money.

Posted: 18 Sep 2009 | Published: 18 Sep 2009

WHITE PAPER: A recent study conducted by the Edison Group, shows how Oracle Database extends the lead over IBM DB2 9.5 for database manageability. In the whitepaper, Edison reveals how Oracle Database saves 40% in time for day-to-day administrative functions and 43% in database management costs over IBM DB2 9.5.

Posted: 18 Sep 2009 | Published: 18 Sep 2009

WHITE PAPER: In August 2008, Microsoft Corporation commissioned Forrester Consulting to examine the total economic impact and potential return on investment (ROI) enterprises might realize by upgrading from SQL Server 2000 or 2005 to SQL Server 2008. Read the results here.

Posted: 18 Sep 2009 | Published: 18 Sep 2009

WHITE PAPER: Because of the success of SQL Server in recent years, unintended consequences have developed. These include low levels of utilization, poor availability, and an enormous management burden inflicted on many IT departments. This paper describes a solution: HP PolyServe Software for Microsoft SQL Server.

Posted: 17 Sep 2009 | Published: 17 Sep 2009

WHITE PAPER: This free white paper details key steps for achieving a superior data management strategy—a ‘must have’ capability for applications to operate with extreme, predictable performance and scalability.

Posted: 10 Sep 2009 | Published: 10 Sep 2009

WHITE PAPER: In this whitepaper presented by the Edison Group, reveals how Oracle Database widens the manageability lead over Microsoft SQL Server 2008. The study shows how Oracle Database can save 43% in time and 41% in database management costs over Microsoft SQL Server 2008.

Posted: 09 Sep 2009 | Published: 09 Sep 2009

WHITE PAPER: With its new unified management and auditing tools, SQL Server 2008 makes it easier to manage multiple instances on fewer servers. And by hosting these instances on Dell PowerEdge Servers powered by multi-core processors, you can guarantee the best levels of availability, as well as ensure the best possible performance.

Posted: 01 Sep 2009 | Published: 01 Sep 2009

WHITE PAPER: Making sure mission critical databases are highly availably (HA) is the main challenge of IT departments. This paper discusses the failover and redundancy capabilities of specific HA products that can be used in conjunction with PostgreSQL, Postgres Plus, and the Oracle compatible database Postgres Plus Advanced Server.

Posted: 27 Aug 2009 | Published: 27 Aug 2009

WHITE PAPER: This paper explores the data explosion phenomenon and why column-oriented database systems are able to provide the boost that is needed to gain the performance edge. The paper contrasts row-oriented systems with column-oriented systems, and then elaborates on the benefits of the columnar approach.

Posted: 06 Aug 2009 | Published: 06 Aug 2009

WHITE PAPER: How do Oracle and Microsoft SQL Server database platforms compare on reliability, scalability and cost when run under enterprise software? Download this white paper for details.

Posted: 19 Jun 2009 | Published: 19 Jun 2009

WHITE PAPER: This document is intended for executives evaluating the use of a horizontally scalable grid for database application deployment, as well as project managers, system engineers, integration specialists, and other technical staff looking to design, implement, and tune database applications in a grid computing environment.

Posted: 05 Jun 2009 | Published: 05 Jun 2009

WHITE PAPER: Performance optimization is a key ingredient in the struggle to stretch an invested IT dollar to its absolute limit. Read this whitepaper to learn about the 3-step 'prevent, find, fix' approach to handling performance optimization problems at any stage of the development lifecycle.

Posted: 29 May 2009 | Published: 29 May 2009